Workflows · 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 Workflows 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

property	type	required	description
`type`	enumerator (query)	yes	Contains the report you want to download.
`conn_id`	string	yes	Connection string as handed to you by the Onesecondbefore team. Default is `google_cloud_default`
`report_type`	enumerator (see list)	yes	Contains the report type. Full list can be found here.
`groupbys`	enumerator (see list)	yes	Contains the group bys. Same list as filters. Full list can be found here.
`filters`	enumerator (see list)	yes	Contains the filters. Full list can be found here.
`metrics`	enumerator (see list)	yes	Contains the metrics. Full list can be found here.
`share_email_address`	string	yes	Contains an email address that will also receive the report. Handy for debugging.

Details

item	description
`API`	DoubleClick Bid Manager API
`Pre-formatted schema`	Yes. Comes with a pre-formatted and described schema.