Collecting data from Nielsen DAR

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

Limitations

Collecting data from Nielsen DAR comes with the following limitations:

There are certain limitations when collecting data in a time range from Nielsen DAR. 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 DAR 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 DAR

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

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

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

(Optional) Rename your datastream.

In Report type, select the type of data to collect from Nielsen DAR. The selected report type determines the additional fields to populate. By default, the report type Campaign Data Exposure is selected. The rest of this guide outlines the additional fields for this report type.

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 DAR tips.
In Audience qualifier, select the demographics on which you want to collect data. If you do not select any demographics, Adverity collects data for all demographics.

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 enrichments to your datastream.
Load your data into Adverity Data Storage to send it to BI tools using data shares
Load your data into an external destination of your choice

Advanced Nielsen DAR tips

Time range limitations when collecting data from Nielsen DAR

You can only collect data in time ranges when fetching data from Nielsen DAR. The data is then aggregated for active campaigns within the specified time range. This causes the following limitations when collecting data from the Nielsen DAR or the Nielsen DAR (Deprecated) 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 DAR.

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 DAR, 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.
Daily: Data for all dates in the date range, including the end date, is collected.