Nielsen DAR connector reference

This reference explains in detail how to configure data collection from Nielsen DAR.

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.