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 Name Description
1 device_id Device ID

 

Example Query:


Adelphic

Columns:

Column # Column Name Description
1 id Device ID
2 os iOS (idfa), Android (adid)
3 type idfa, adid

 

Example Query:


Addictive

Columns:

Column # Column Name Description
1 device_id Device ID

 

Example Query:


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

Columns:

Column # Column Name Description
1 device_id Device ID
2 type 1 (adid), 2 (idfa)
3 empty column
4 empty column
5 audience_id Audience Identifier

 

Example Query:


AppLovin

Columns:

Column # Column Name Description
1 device_id Device ID
2 device_id_type idfa or adid

 

Example Query:


Smadex

Columns:

Column # Column Name Description
1 audience_id Audience Identifier
2 device_id Device ID
3 device_id_sha1 sha1 Device ID
0

 

Example Query:


Verve

Columns:

Column # Column Name Description
1 device_id Upper idfa or Lower adid
2 device_id_type idfa or aaid (instead of adid)
3 timestamp Time of Query
4 audience_id Audience Identifier

 

Example Query:

 
 

Last Modified: May 13, 2022 at 1:17 pm