Collecting data from Xandr
This guide explains how to collect data from Xandr. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.
Introduction
For a list of the fields that you can collect from Xandr, see
Limitations
Collecting data from Xandr comes with the following limitations:
-
You can only fetch data from the past 45 days using Xandr.
Creating a datastream to collect data from Xandr
The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from Xandr.
Configuration: Choose the data you want to collect from Xandr
To choose what data to collect and customize the Xandr datastream configuration, follow these steps:
-
(Optional) Rename your datastream.
-
In Report type, select the type of data to collect from Xandr.
-
In Timezone, select the timezone in which the data will be reported. The default value is UTC.
-
In Columns, change the list of fields that you want to see in your data extract.
-
In Advertisers, select the advertisers for which to collect data. If you do not select any items in a drop-down list, Adverity collects data for all items in the drop-down list.
-
(Optional) To apply filters to your data, provide a valid JSON in the Filters field. For more information, see the Xandr documentation.
For example, the following expression filters for data matching two
bid_type
field values and onegeo_country
field value:[ {"bid_type": ["learn","optimized"]}, {"geo_country": "US"} ]
What's next?
-
Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.
-
Transform your data to meet your needs by creating and applying transformations to your datastream.
-
Load your data into Explore & Present to visualize your data in Adverity
-
Load your data into an external destination of your choice
Troubleshooting Xandr
I see an error message when fetching data from Xandr
The report cannot be ran for that many days in the past
error message appears because you are trying to fetch data that is more than 45 days old.
To resolve this issue, change the selected date range for your fetch so that you are only fetching data from the past 45 days.