Query – Activation Partners – Expected Columns

The following document defines the columns expected for activation partners while utilizing the Kochava Query option for an audience activation. The SELECT statement must select these columns to successfully complete the activation.

NOTE: Any Activation Partner not specified in this list can send any columns needed, however the general recommendation is to select device_id, device_id_value.

WARNING: Facebook, Snapchat, Twitter, and Smadex activations will fail immediately if the wrong number of columns are provided.

---

Facebook/Snapchat/Twitter

Columns:

Example Query:

SELECT
  adid as device_id
FROM
 events_primary
WHERE
  date_occurred BETWEEN TIMESTAMP('2018-10-31')
  AND TIMESTAMP('2018-11-01')

---

Adelphic

Columns:

Example Query:

SELECT
  adid as device_id,
  'android' as os,
  'adid' as type
FROM
 events_primary
WHERE
  date_occurred BETWEEN TIMESTAMP('2018-10-31')
  AND TIMESTAMP('2018-11-01')

---

Addictive

Columns:

Example Query:

SELECT
  adid as device_id,
FROM
 events_primary
WHERE
  date_occurred BETWEEN TIMESTAMP('2018-10-31')
  AND TIMESTAMP('2018-11-01')

---

Adsquare (tubemogul, mediamath, appnexus, doubleclick bid manager/DBM, inmobi, adcolony)

Columns:

Example Query:

SELECT
  adid as device_id,
  'adid' as type,
  '' as col3,
  '' as col4,
  '123947192' as audience_id
FROM
 events_primary
WHERE
  date_occurred BETWEEN TIMESTAMP('2018-10-31')
  AND TIMESTAMP('2018-11-01')

---

AppLovin

Columns:

Example Query:

SELECT
  adid as device_id,
  'adid' as device_id_type
FROM
 events_primary
WHERE
  date_occurred BETWEEN TIMESTAMP('2018-10-31')
  AND TIMESTAMP('2018-11-01')

---

Smadex

Columns:

Example Query:

SELECT
  '123947192' as audience_id,
  adid as device_id,
  SHA1(device_id) as device_id_sha1
  0 as col4
FROM
 events_primary
WHERE
  date_occurred BETWEEN TIMESTAMP('2018-10-31')
  AND TIMESTAMP('2018-11-01')

---

Verve

Columns:

Example Query:

SELECT
  LOWER(adid) as device_id,
  'aaid' as device_id_type
  CURRENT_TIMESTAMP as `timestamp`
  '1234901238' as audience_id
FROM
 events_primary
WHERE
  date_occurred BETWEEN TIMESTAMP('2018-10-31')
  AND TIMESTAMP('2018-11-01')