Collecting data from Nielsen One

This guide explains how to collect data from Nielsen One. 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 Nielsen One, see Nielsen One.

Limitations

Collecting data from Nielsen One comes with the following limitations:

There are certain limitations when collecting data in a time range from Nielsen One. Data created today or yesterday cannot be collected, and the data extracts for these days would be empty. The length of the campaign also determines the date range in which you can collect data. For more information on these limitations, see Advanced Nielsen One tips.

For the report type Campaign Site Placement Reference, you can only collect data for a maximum of 200 campaigns.

Creating a datastream to collect data from Nielsen One

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 Nielsen One.

Configuration: Choose the data you want to collect from Nielsen One

To choose what data to collect and customize the Nielsen One datastream configuration, follow these steps:

(Optional) Rename your datastream.

In Report type, select the type of data to collect from Nielsen One. The selected report type determines the additional fields to populate. By default, the report type Campaign Data Exposure is selected.

In Advertisers, Campaigns and Countries, select the advertisers, campaigns and countries 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.

In Dimensions and Metrics, change the list of fields that you want to see in your data extract.

In Granularity, select the time unit in which you want to retrieve your data. The length of the campaign selected in the Campaign field determines the available options in this field. To collect data for the whole campaign, select Lifetime. For more information, see Advanced Nielsen One tips.
In TV data sources, select the TV data sources for which to collect data.
In Brands, Platforms, select the brands and platforms 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.
In Campaign status, select the statuses for which to collect data. If you do not select any items in a drop-down list, Adverity collects data only for active campaigns.
In Placement status, select the statuses for which to collect data. If you do not select any items in a drop-down list, Adverity collects data only for active placements.

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

Advanced Nielsen One tips

Time range limitations when collecting data from Nielsen One

You can only collect data in time ranges when fetching data from Nielsen One. The data is then aggregated for active campaigns within the specified time range. This causes the following limitations when collecting data from the Nielsen One connector:

Data cannot be separated by day in the data extract.
You cannot collect data for a single day.
You cannot collect data created today or yesterday. For more information, see the example below.

The following example highlights the limitations when collecting data in a time range from Nielsen One.

If today is 12 December and you collect data with a date range from 1 December to 12 December, the data extract only contains data for the days from 1 December to 10 December. This is because you cannot collect data created today or yesterday. In the data extract, the rows for 11 and 12 of December are empty.

The length of a campaign selected in the Campaign field determines the available options in the Granularity field. For example, if a campaign runs for less than three months, you cannot select the option Quarterly in the granularity field. To collect data for the whole campaign, select Lifetime

Limitations on the start and end dates when collecting data

When collecting data from Nielsen One, there are certain limitations when using the different granularity values. The start date or end date can be ignored when applying a date range depending on which granularity values are used. These limitations are best described using a worked example.

In the example below, data is being collected for the following date range: 2022-07-14 to 2022-07-17 (Thursday to Sunday). The examples below explain what data will be collected when each granularity option is selected.

Lifetime: Data for all available dates, including the end date, is collected. This includes dates earlier than the start date, essentially ignoring the start date. Adverity checks the latestReleasedDate. If this date is earlier than the selected end date, then the end date is set to the latestReleasedDate to prevent empty data extracts. Using the example date range above, if data is only available until 2022-07-15, then Adverity automatically sets the end date of the date range to 2022-07-15.
Quarterly: The start date of the date range must be the first day of a quarter. Like with the Lifetime granularity option, Adverity checks the latestReleasedDate to prevent empty data extracts. If a latestReleasedDate cannot be found, then Adverity uses the start date of the date range.
Monthly: The start date of the date range must be the first day of a month. If the date range does not start on the first day of a month, Adverity automatically sets the start date of the date range to the first day of the month containing the start date. Using the example date range above, Adverity will automatically set the start date to 2022-07-01. The monthly granularity option will only collect data for one month.
Weekly: The start date of the date range must be the first day of a week. If the date range does not start on the first day of a week, Adverity automatically sets the start date of the date range to the first day of the week containing the start date. Using the example date range above, Adverity will automatically set the start date to 2022-07-11 because this date is a Monday. The weekly granularity option will only collect data for one week.