Workflows · From Tasks · from_xandr

Purpose

Imports data from Xandr.

Extract types

Below are the types of extract for Looker. Click on an extract type for an explanation.

type: segments

Load data from Xandr segments.

Example usage

extract:
    type: segments
    filtering:
      - field: search
        value: OSB Audience

Properties

propertytyperequireddescription
typeenumerator(segments)yesSet type to segments.
conn_idstringnoDefault is xandr.
filteringarray of objectsyesFilters. See full description below.

type: member_data_sharing

Load data from Xandr member_data_sharing.

Example usage

extract:
    type: member_data_sharing
    filtering:
      - field: search
        value: OSB Audience

Properties

propertytyperequireddescription
typeenumerator(member_data_sharing)yesSet type to member_data_sharing.
conn_idstringnoDefault is xandr.
filteringarray of objectsyesFilters. See full description below.

type: reports

Load data from Xandr reports.

Example usage

extract:
    type: reports
    report: advertiser_analytics
    advertiser_id: 12345678
    filtering:
      - field: search
        value: OSB Audience

Properties

propertytyperequireddescription
typeenumerator(reports)yesSet type to reports.
reportEnumerator (one of the following):yesDefines the report to export.
conn_idstringnoDefault is xandr.
advertiser_idstringnoAdvetiser_id to export data from. If not added, imports data from all advertisers in the member seat.
filteringarray of objectsyesFilters. See full description below.

Properties of filtering object

If you use filtering (see above) in the extract. You have to add an object every time with the fields below.

propertytyperequireddescription
fieldenumerator (code, search, id, short_name, advertiser_id, num_elements, offset, orders)yesContains the name of the field you want to filter on.
valuestringyesContains the value to filter one.

Details

itemdescription
APIXandr API