kokozi_PMKT_DASH
Tables (5)
Appsflyer_AOS (Untitled)
- Date (Key) — Date — Primary key — NOT NULL
- Media source (Field1) — String — Primary key
- Campaign (Field2) — String — Primary key
- Data Source (Field9) — String
- Currency (Field10) — String
- Installs (Field3) — Number
- af_buy Event Counter (Field4) — Number
- af_complete_registration Event Counter (Field5) — Number
- af_complete_signup Event Counter (Field6) — Number
- af_purchase Event Counter (Field7) — Number
- af_buy Sales (Field8) — Monetary
- af_purchase Sales (Field11) — Monetary
Appsflyer_iOS (Hold)
- Date (Key) — Date — Primary key — NOT NULL
- Media source (Field1) — String — Primary key
- Campaign (Field2) — String — Primary key
- Data Source (Field9) — String
- Currency (Field10) — String
- Installs (Field3) — Number
GA4 (CopyOfUntitled3)
- Date (Key) — Date — Primary key — NOT NULL
- Account ID (Key2) — Number — Primary key
- Account name (Key3) — String — Primary key
- Event name (Key4) — String — Primary key — NOT NULL
- Property ID (Key5) — Number — Primary key — NOT NULL
- Event Count (Key6) — String — Primary key — NOT NULL
- Session campaign (Key7) — String — Primary key — NOT NULL
- Session manual ad content (Key8) — String — Primary key — NOT NULL
- Session manual term (Key9) — String — Primary key — NOT NULL
- Session medium (Key10) — String — Primary key
- Session source (Key11) — String — Primary key
- Event count (Field1) — Number
- Event value (Field2) — Number
- Sessions (Field3) — Number
GAds (Untitled3)
- Date (Key) — Date — Primary key — NOT NULL
- Ad (Key2) — String — Primary key
- Ad Group Name (Key3) — String — Primary key
- Ad Group Type (Key4) — String — Primary key — NOT NULL
- Ad Type (Key5) — String — Primary key — NOT NULL
- Campaign (Key6) — String — Primary key — NOT NULL
- Campaign Type (Key7) — String — Primary key — NOT NULL
- Currency (Field) — String
- Data Source (Field2) — String
- All Conv.Value (Field5) — Monetary
- Clicks (Field6) — Number
- Conversions (Field3) — Number
- Cost (Field4) — Number
- Impressions (Field7) — Number
- Android First open (Field8) — Number
- Android In-app purchase (Field9) — Number
Meta (Untitled2)
- Date (Key) — Date — Primary key — NOT NULL
- Ad Account ID (Field3) — Number — Primary key
- Ad name (Field4) — String — Primary key
- Ad Set name (Field5) — String — Primary key
- Campaign Name (Field6) — String — Primary key
- Currency (Field) — String
- Data Source (Field2) — String
- Amount Spent (Field7) — Number
- App Installs (Field8) — Number
- Impressions (Field9) — Number
- Link Click (Field10) — Number
- Purchases (Field11) — Number
- Purchases Conversion Value (Field12) — Number