Support Home > Advanced Tools > Custom Query > Query – Activation Partners – Expected Columns

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:

Column #Column NameDescription
1device_idDevice ID

 

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:

Column #Column NameDescription
1idDevice ID
2osiOS (idfa), Android (adid)
3typeidfa, adid

 

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:

Column #Column NameDescription
1device_idDevice ID

 

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:

Column #Column NameDescription
1device_idDevice ID
2type1 (adid), 2 (idfa)
3empty column
4empty column
5audience_idAudience Identifier

 

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:

Column #Column NameDescription
1device_idDevice ID
2device_id_typeidfa or adid

 

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:

Column #Column NameDescription
1audience_idAudience Identifier
2device_idDevice ID
3device_id_sha1sha1 Device ID
0

 

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:

Column #Column NameDescription
1device_idUpper idfa or Lower adid
2device_id_typeidfa or aaid (instead of adid)
3timestampTime of Query
4audience_idAudience Identifier

 

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')

 
 

Last Modified: Dec 28, 2023 at 11:35 am