Have field names changed between Console reporting and this API?
Certain fields have different, more precise names in the Reporting API compared to the TripleLift Console.
Name in TripleLift Console | Name in Reporting API |
---|---|
Date | Ymd |
Site | Domain |
Deal ID | Deal Code |
Placement | Placement Name |
Advertiser | Brand |
Ad Requests | Impressions |
Filled Impressions | Rendered |
What timezone is the data in?
All data is in UTC.
When is data for the current day available?
Current day data is not available in real time. Data is subject to processing delays, but the first hour of the day can generally be expected by 10:00 UTC.
What currency is the data in?
All monetary fields are in USD.
What dimensions & metrics are available to query?
Please refer to the GraphQL schema for up to date information on available endpoints, dimensions, and metrics in the TripleLift Reporting API.
You can start exploring the API using Altair, once you have obtained your API key, JWT, and have a TripleLift member account ID.
How does the domain threshold rollup work?
Domain is one of the highest cardinality fields exposed via the TripleLift Reporting API. Adding domain as a dimension can increase the number of rows by a factor of 100x or more.
Therefore, whenever a query contains the domain dimension, we automatically roll up all rows which contribute a marginal amount (less than 0.1%) of the total renders for the query into a single row with the domain name “Other”
.
e.g. If a report has a total of 2,000 renders, and you queried for the domain dimension, then any domain with fewer than 2 renders (2,000 * 0.001) will be rolled up into a single row with the domain name “Other”
.
You can opt out of this behavior with the optional query parameter useThreshold
.
How should the CSV from the asynchronous endpoints be parsed?
When using the asynchronous endpoints, you'll receive a response in the form of a CSV. Refer to the CSV Response Parsing section for tips on parsing the results.