By Taylor Mcgrath

DoubleClick to BigQuery

Integrates with:

The DCM Campaign Standard Report Kit extracts and combines basic marketing campaign parameters, statistics, and sets up the primary keys for continuous data updating.

This kit includes

Data ingestion rivers for for the following entities:DCM Standard ReportLogic that identifies the relevant keys for subsequent data loading.

Minimum RPU Consumption: 2

You can find the full contents used here.

Configuring this kit for use

Variables

In this Kit, there is only one variable that needs to be set, and that is the {dataset_dcm_standard} that defines the dataset in your BigQuery instance where you want the final data model to be created/outputted.Go to the Variables menu on the left side navigation bar and create a variable for dataset_dcm_standard. Then fill in the values for the BigQuery dataset where you want the data to land.

Connections

Kits are imported with ‘blank’ source and target connections. In order to use the kit, you have two options:Swap out blank connections with existing connectionsAdd credentials to the blank connections that come with the imported Kit

More Kits

Twitter Organic Tweets – BigQuery

Twitter Organic Tweets use the associated Stats report as a base table and adds in the…