The following document defines the tables accessible within Query for the creation of custom queries.

IMPORTANT NOTE: Latitude and Longitude values are populated based on a 3rd party IP lookup service and are associated with a general city center location.

---

Clicks Tables

The following tables associated with Click data are accessible within Query.

 

click_identifiers:

 

* Indicates the foreign key for Click Tables JOIN.

 

click_properties:

 

* Indicates the foreign key for Click Tables JOIN.

 

clicks_primary:

 

* Indicates the foreign key for Click Tables JOIN.

 

Click Table Join Example:

/* Click Tables JOIN Example */
SELECT *
FROM clicks_primary c
    LEFT OUTER JOIN click_properties cp
        ON c.click_id = cp.click_id
    LEFT OUTER JOIN (
            SELECT click_id,
                identifier_value
            FROM click_identifiers
            WHERE identifier_type = 'idfa') AS ci
        ON c.click_id = ci.click_id
WHERE DATE(c.date_received) = '2016-09-20'
LIMIT 10

---

Events

 

event_attribution:

 

** Indicates the foreign key for Event Table JOIN.
** Indicates the foreign key for Click or Impression Tables JOIN.

 

event_dimensions:

 

* Indicates the foreign key for Event Tables JOIN.

 

events_primary:

 

* Indicates the foreign key for Event Tables JOIN.
** Indicates the foreign key for Install Table JOIN.

 

Event Table Join Example:

/* Event Tables JOIN Example */
SELECT *
FROM events_primary e
    LEFT OUTER JOIN event_attribution ea
        ON e.event_id = ea.event_id
    LEFT OUTER JOIN (
            SELECT event_id,
                dimension_value
            FROM event_dimensions
            WHERE dimension_key = 'receipt_status') ed
        ON e.event_id = ed.event_id
WHERE DATE(e.date_occured) = '2016-09-20'
LIMIT 10

---

Identity Link

 

identity_link:

 

* Indicates the foreign key for Event Tables JOIN.
** Indicates the foreign key for Install Tables JOIN.

---

Impressions Tables

 

impression_identifiers:

 

* Indicates the foreign key for Impression Tables JOIN.

 

impression_properties:

 

* Indicates the foreign key for Impression Tables JOIN.

 

impressions_primary:

 

* Indicates the foreign key for Impression Tables JOIN.

 

Impression Table Join Example:

/* Impression Tables JOIN Example */
SELECT *
FROM impressions_primary i
    LEFT OUTER JOIN impression_properties ip
        ON i.impression_id = ip.impression_id
    LEFT OUTER JOIN impression_identifiers ii
        ON i.impression_id = ii.impression_id
WHERE DATE(i.date_received) = '2016-09-20'
LIMIT 10

---

Attribution Tables

 

install_attribution:

 

* Indicates the foreign key for Install Table JOIN.
** Indicates the foreign key for Click or Impression Tables JOIN.

---

Installs Tables

 

install_identifiers:

 

* Indicates the foreign key for Install Tables JOIN.

 

install_influencers:

 

* Indicates the foreign key for the Click Tables JOIN.
** Indicates the foreign key for Impression Tables JOIN.
*** Indicates the foreign key for Install Tables JOIN.

 

installs_primary:

 

* Indicates the foreign key for Install Tables JOIN.

 

Install Table Join Example:

/* Install Tables JOIN Example */
SELECT *
FROM installs_primary i
    LEFT OUTER JOIN install_attribution ia
        ON i.install_id = ia.install_id
    LEFT OUTER JOIN (
            SELECT install_id,
                identifier_value
            FROM install_identifiers
            WHERE identifier_type = 'idfa') AS ii
        ON i.install_id = ii.install_id
WHERE DATE(i.date_occurred) = '2016-09-20'
LIMIT 10

---

Ad Revenue Tables

 

user_level_ad_revenue:

*Maps to ironSource (Ad Unit)
**Maps to ironSource (Segment)
***Maps to ironSource (Ad Network)

---

SKAdNetwork Conversion Table

 

skad_conversions:

 

**Subject to Apple’s “privacy threshold”.