LiveRamp’s Wholesale CTV Match Data Feed
LiveRamp can provide you with a batch transfer or feed of CTV match data from our large network of publishers, linking identifiers for advertisers (IFAs) and other CTV IDs to IP addresses (IPv4) and timestamps. This can power a range of use cases including CTV matching, offline attribution, and cross-device attribution.
Set Up CTV Match Data Deliveries
We typically deliver files to SFTP and S3 daily, but we also have a python script that can be used to download files on any schedule, as well as a real-time HTTPS stream. See “LiveRamp’s Wholesale Delivery Methods” for more information.
LiveRamp also needs the following information:
The desired delivery cadence (typically daily).
The desired data recency typically 12 months for match data, since CTV advertising IDs are long-lived).
Example File Format
For an example of the format of the files you'll receive, see the table below.
Column | Column Required? | Definition | Example |
|---|---|---|---|
Identifier for Advertiser | Yes | The Identifier for Advertiser (IFA) of the device. | 12d8c661-03de-2b3f-5f0a-9effbedebe7f |
ID Type | Yes | A static value to identify the type of ID. | CONNECTED_TV_ID |
User Agent | No | User Agent string of the device. | tcl |
Timestamp | Yes | Unix Timestamp (seconds since Unix epoch) of when the user was active/logged in. | 1455172609 |
ID Value | Yes | The primary linking ID for the device Identifier. This will be an IP address but supports additional linking IDs. | 68.85.187.160 |
Linking ID Type | Yes | The primary linking ID type against the device identifier. | IP_ADDRESS |
Opted-Out | No | “1” indicates that the user has explicitly opted out (otherwise the value should be “0”). If “1”, all fields except Identifier for Advertiser and ID Type should be empty. | 0 |
File Examples
A set of populated rows might look like this:
a2d4ab36-981b-562c-ff92-dd09eb1ff947,CONNECTED_TV_ID,huawei,68.85.187.160,1726498800,68.85.187.160,IP_ADDRESS,0
12d8c661-03de-2b3f-5f0a-9effbedebe7f,CONNECTED_TV_ID,oneplus,74.93.32.62,1725534000,74.93.32.62,IP_ADDRESS,0
cb682289-70c4-4699-bdb9-0f5e658320e0,CONNECTED_TV_ID,tcl,100.229.186.223,1725584400,100.229.186.223,IP_ADDRESS,0
788937a0-62f0-448d-b0bc-ba2ddd30ad81,CONNECTED_TV_ID,xiaomi,47.12.112.22,1725706800,47.12.112.22,IP_ADDRESS,0
41344c7f-f80a-49e9-8291-9fa27b022db3,CONNECTED_TV_ID,htc,72.130.235.60,1726095600,72.130.235.60,IP_ADDRESS,0
d17cdcce-9bf1-c982-824f-fe4b048d7a10,CONNECTED_TV_ID,google,71.179.3.76,1726876800,71.179.3.76,IP_ADDRESS,0