Transfer · From Tasks · from_dcbm

Purpose

Imports data from Display & Video 360 (previously DoubleClick Bid Manager).

Method of use

Before you can download data from DoubleClick Campaign Manager you have to give Transfer access. You also have to switch on the API here.

Configuration

Example usage

extract:
    type: query
    report_type: TYPE_GENERAL
    groupbys:
        - filter_advertiser_currency
        - filter_advertiser
        - filter_advertiser_name
        - filter_date
        - filter_media_plan
        - filter_media_plan_name
        - filter_insertion_order
        - filter_insertion_order_name

    metrics:
        - metric_impressions
        - metric_clicks
        - metric_client_cost_ecpm_advertiser_currency
        - metric_media_cost_advertiser
        - metric_revenue_advertiser

Properties

propertytyperequireddescription
typeenumerator (query)yesContains the report you want to download.
conn_idstringyesConnection string as handed to you by the Onesecondbefore team. Default is `google_cloud_default`
report_typeenumerator (see list)yesContains the report type. Full list can be found here.
groupbysenumerator (see list)yesContains the group bys. Same list as filters. Full list can be found here.
filtersenumerator (see list)yesContains the filters. Full list can be found here.
metricsenumerator (see list)yesContains the metrics. Full list can be found here.
share_email_addressstringyesContains an email address that will also receive the report. Handy for debugging.

Details

itemdescription
APIDoubleClick Bid Manager API
Pre-formatted schemaYes. Comes with a pre-formatted and described schema.