Have field names changed between Console reporting and this API?
Yes, certain fields now have different, more accurate names compared to their names in the TripleLift Console UI.
Specifically:
| Name in Console UI | 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.
How does the domain threshold rollup work?
Domain is one of the highest cardinality fields exposed via the 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.