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
type: member_data_sharing
type: reports

type: segments

Load data from Xandr segments.

Example usage

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

Properties

property	type	required	description
`type`	enumerator(segments)	yes	Set type to segments.
`conn_id`	string	no	Default is `xandr`.
`filtering`	array of objects	yes	Filters. 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

property	type	required	description
`type`	enumerator(member_data_sharing)	yes	Set type to member_data_sharing.
`conn_id`	string	no	Default is `xandr`.
`filtering`	array of objects	yes	Filters. 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

property	type	required	description
`type`	enumerator(reports)	yes	Set type to `reports`.
`report`	Enumerator (one of the following): advertiser_analytics advertiser_attributed_conversions advertiser_creative_frequency_and_recency buyer_approximate_unique_users_hourly buyer_bid_error_report buyer_deal_metrics buyer_engagement_report buyer_invoice_report buyer_reach_and_frequency_report buyer_segment_performance buyer_segment_performance_report clicktrackers_feed completed_creative_audits_report conversion_pixel_last_fire curator_analytics_report curator_bid_error_report curator_segment_performance_report data_usage_report engagement_metrics_report forecast_report geo_analytics_report identifiers_distinct_id_report identifiers_id_combinations_report insertion_order_frequency_report inventory_availability_report key_value_analytics_report line_item_frequency_report multi_buyer_seller_deal_metrics multi_key_value_analytics_report network_advertiser_analytics network_advertiser_video_analytics network_analytics network_analytics_feed network_attributed_conversions network_audio_analytics network_billing network_carrier_analytics network_creative_frequency_and_recency network_device_analytics network_publisher_analytics network_publisher_video_analytics network_site_domain_performance network_video_error_analytics_report network_video_inventory_availability_report nielsen_digital_ad_ratings_audience_profile_report nielsen_digital_ad_ratings_site_split_report offline_attribution_report prebid_server_premium_health_analytics prebid_server_premium_seller_analytics publisher_analytics publisher_brand_review_report segment_load segments seller_bid_error_report seller_billing_report seller_brand_review_report seller_cmp_analytics_report seller_deal_metrics_report seller_detected_site_domain_report seller_fill_and_delivery_network_report seller_fill_and_delivery_publisher_report seller_invoice_report seller_segment_performance_report seller_site_domain_report site_domain_performance_report vendor_usage_report video_ad_pod_report video_analytics_network video_mediation_demand_report	yes	Defines the report to export.
`conn_id`	string	no	Default is `xandr`.
`advertiser_id`	string	no	Advetiser_id to export data from. If not added, imports data from all advertisers in the member seat.
`filtering`	array of objects	yes	Filters. 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.

property	type	required	description
`field`	enumerator (code, search, id, short_name, advertiser_id, num_elements, offset, orders)	yes	Contains the name of the field you want to filter on.
`value`	string	yes	Contains the value to filter one.

Details

item	description
`API`	Xandr API