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