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.
Facebook/Snapchat/Twitter
Columns:
| Column # | Column Name | Description |
|---|---|---|
| 1 | device_id | Device ID |
Example Query:
|
1 2 3 4 5 6 7 |
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 Name | Description |
|---|---|---|
| 1 | id | Device ID |
| 2 | os | iOS (idfa), Android (adid) |
| 3 | type | idfa, adid |
Example Query:
|
1 2 3 4 5 6 7 8 9 |
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 Name | Description |
|---|---|---|
| 1 | device_id | Device ID |
Example Query:
|
1 2 3 4 5 6 7 |
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 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:
|
1 2 3 4 5 6 7 8 9 10 11 |
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 Name | Description |
|---|---|---|
| 1 | device_id | Device ID |
| 2 | device_id_type | idfa or adid |
Example Query:
|
1 2 3 4 5 6 7 8 |
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 Name | Description |
|---|---|---|
| 1 | audience_id | Audience Identifier |
| 2 | device_id | Device ID |
| 3 | device_id_sha1 | sha1 Device ID |
| 0 | — | — |
Example Query:
|
1 2 3 4 5 6 7 8 9 10 |
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 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:
|
1 2 3 4 5 6 7 8 9 10 |
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') |
