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.


For a list of the fields that you can collect from Xandr, see Xandr.


Collecting data from Xandr comes with the following limitations:

  • You can only fetch data from the past 45 days using Xandr.

  • Xandr can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.

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:

  1. (Optional) Rename your datastream.

  1. In Report type, select the type of data to collect from Xandr.

  1. In Timezone, select the timezone in which the data will be reported. The default value is UTC.

  1. In Columns, change the list of fields that you want to see in your data extract.

  1. 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.

  1. (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 one geo_country field value:

    	{"bid_type": ["learn","optimized"]},
    	{"geo_country": "US"}

What's next?

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.