Skip to main content

Data Source

Follow the instructions below to create a new data flow that ingests data from a Nielsen Digital Ad Ratings source in Nexla.
nielsen_digital_ad_ratings.png

Nielsen Digital Ad Ratings

Create a New Data Flow​

  1. To create a new data flow, navigate to the Integrate section, and click the New Data Flow button. Then, select the desired flow type from the list, and click the Create button.

  2. Select the Nielsen Digital Ad Ratings connector tile from the list of available connectors. Then, select the credential that will be used to connect to your Nielsen Digital Ad Ratings account, and click Next; or, create a new Nielsen Digital Ad Ratings credential for use in this flow.

  3. In Nexla, Nielsen Digital Ad Ratings data sources can be created using pre-built endpoint templates, which expedite source setup for common Nielsen Digital Ad Ratings endpoints. Each template is designed specifically for the corresponding Nielsen Digital Ad Ratings endpoint, making source configuration easy and efficient.
    • To configure this source using a template, follow the instructions in Configure Using a Template.

    Nielsen Digital Ad Ratings sources can also be configured manually, allowing you to ingest data from Nielsen Digital Ad Ratings endpoints not included in the pre-built templates or apply further customizations to exactly suit your needs.
    • To configure this source manually, follow the instructions in Configure Manually.

Configure Using a Template​

Nexla provides pre-built templates that can be used to rapidly configure data sources to ingest data from common Nielsen Digital Ad Ratings endpoints. Each template is designed specifically for the corresponding Nielsen Digital Ad Ratings endpoint, making data source setup easy and efficient.

Endpoint Settings​

  • Select the endpoint from which this source will fetch data from the Endpoint pulldown menu. Available endpoint templates are listed in the expandable boxes below. Click on an endpoint to see more information about it and how to configure your data source for this endpoint.

    UniverseEstimateReference

    This endpoint template provides population base information for each reportable demographic from the Nielsen Digital Ad Ratings API. Use this template when you need to retrieve universe estimate reference data, which contains population base information for demographic segments used in digital ad ratings reporting.

    • This endpoint automatically retrieves universe estimate reference data. No additional configuration is required beyond selecting this endpoint template. The endpoint sends a POST request to retrieve the reference data.

    This endpoint returns population base information for each reportable demographic, which is used as reference data for digital ad ratings reporting. The universe estimate reference data provides the population base for demographic segments, which is essential for calculating reach, frequency, and other ad ratings metrics.

    For detailed information about universe estimate reference data, API response structures, and demographic information, see the Nielsen Digital Ad Ratings API documentation.

    Method reference

    This endpoint template returns the list of all available methods with method definitions from the Nielsen Digital Ad Ratings API. Use this template when you need to discover available reporting methods, method definitions, and method configurations for digital ad ratings reporting.

    • This endpoint automatically retrieves method reference data. No additional configuration is required beyond selecting this endpoint template. The endpoint sends a POST request to retrieve the method reference data.

    This endpoint returns the list of all available methods with method definitions, which provides information about available reporting methods, method configurations, and method parameters for digital ad ratings reporting. Use this endpoint to discover which methods are available and how to configure them for your reporting needs.

    For detailed information about method reference data, available methods, and method definitions, see the Nielsen Digital Ad Ratings API documentation.

Endpoint Testing​

Once the selected endpoint template has been configured, Nexla can retrieve a sample of the data that will be fetched according to the current settings. This allows users to verify that the source is configured correctly before saving.

  • To test the current endpoint configuration, click the Test button to the right of the endpoint selection menu. Sample data will be fetched & displayed in the Endpoint Test Result panel on the right.

  • If the sample data is not as expected, review the selected endpoint and associated settings, and make any necessary adjustments. Then, click the Test button again, and check the sample data to ensure that the correct information is displayed.

Configure Manually​

Nielsen Digital Ad Ratings data sources can be manually configured to ingest data from any valid Nielsen Digital Ad Ratings API endpoint. Manual configuration provides maximum flexibility for accessing endpoints not covered by pre-built templates or when you need custom API configurations.

With manual configuration, you can also create more complex Nielsen Digital Ad Ratings sources, such as sources that use chained API calls to fetch related data or sources that require custom request parameters or filters.

API Method​

  1. To manually configure this source, select the Advanced tab at the top of the configuration screen.

  2. Select the API method that will be used for calls to the Nielsen Digital Ad Ratings API from the Method pulldown menu. Nielsen Digital Ad Ratings API typically uses POST method for submitting data requests.

API Endpoint URL​

  1. Enter the URL of the Nielsen Digital Ad Ratings API endpoint from which this source will fetch data in the Set API URL field. This should be the complete URL to your Nielsen Digital Ad Ratings API endpoint (e.g., https://api.developer.nielsen.com/watch/dar/reporting/v1/UniverseEstimateReference). Include any required query parameters in the URL.

Ensure the API endpoint URL is correct and accessible with your current credentials. The Nielsen Digital Ad Ratings API endpoint URL should point to a valid endpoint. You can test the endpoint using the Test button after configuring the URL.

Request Body​

  1. Configure the request body that will be sent to the Nielsen Digital Ad Ratings API. The request body should contain your request parameters formatted as JSON. The request body format depends on the specific endpoint you're using. Refer to the Nielsen Digital Ad Ratings API documentation for the required request body format for your endpoint.

The request body must be valid JSON and must match the Nielsen Digital Ad Ratings API's expected format for the specific endpoint you're using. For detailed information about request body formats, available endpoints, and request parameters, see the Nielsen Digital Ad Ratings API documentation.

Response Data Path​

  1. Enter the JSONPath expression in the Response Data Path field to specify which part of the API response should be treated as the relevant data by Nexla. For Nielsen Digital Ad Ratings API responses, use $[*] to extract all items from the response array, or use a more specific JSONPath expression based on your response structure.

The JSONPath expression must correctly reference the structure of your Nielsen Digital Ad Ratings API response. Nielsen Digital Ad Ratings API responses may return data in different structures depending on the endpoint. Ensure your JSONPath expression matches the structure returned by your specific endpoint. The JSONPath expression determines which data will be extracted and processed by Nexla.

Save the Data Source​

  1. Once all of the relevant steps in the above sections have been completed, click the Next button to proceed with the rest of the data flow configuration, or click Save to save the data source configuration for later use.