By Taylor Mcgrath

DCM Standard Report - BigQuery

Integrates with:

<img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" alt="" decoding="async" data-srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" data-src="https://rivery.io/wp-content/uploads/2020/12/bq.png" data-sizes="(max-width: 225px) 100vw, 225px" class="attachment-full size-full lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="225" height="225" src="https://rivery.io/wp-content/uploads/2020/12/bq.png" class="attachment-full size-full" alt="" decoding="async" srcset="https://rivery.io/wp-content/uploads/2020/12/bq.png 225w, https://rivery.io/wp-content/uploads/2020/12/bq-150x150.png 150w, https://rivery.io/wp-content/uploads/2020/12/bq-200x200.png 200w, https://rivery.io/wp-content/uploads/2020/12/bq-220x220.png 220w" sizes="(max-width: 225px) 100vw, 225px" />

<img width="260" height="200" src="https://rivery.io/wp-content/uploads/2021/01/doubleclick.png" class="attachment-full size-full" alt="" decoding="async" srcset="https://rivery.io/wp-content/uploads/2021/01/doubleclick.png 260w, https://rivery.io/wp-content/uploads/2021/01/doubleclick-250x192.png 250w" sizes="(max-width: 260px) 100vw, 260px" />

<img width="200" height="200" src="https://rivery.io/wp-content/uploads/2023/07/google-cloud.svg" class="attachment-full size-full" alt="" decoding="async" />

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 Report
Logic 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 connections
Add credentials to the blank connections that come with the imported Kit

<img width="930" height="427" src="https://rivery.io/wp-content/uploads/2021/05/14d49bd57b924368b74d9418f8511d90_Screen_Shot_2021-07-12_at_14.30.25-930x427.png" class="attachment-wysiwyg-content size-wysiwyg-content" alt="" decoding="async" srcset="https://rivery.io/wp-content/uploads/2021/05/14d49bd57b924368b74d9418f8511d90_Screen_Shot_2021-07-12_at_14.30.25-930x427.png 930w, https://rivery.io/wp-content/uploads/2021/05/14d49bd57b924368b74d9418f8511d90_Screen_Shot_2021-07-12_at_14.30.25-300x138.png 300w, https://rivery.io/wp-content/uploads/2021/05/14d49bd57b924368b74d9418f8511d90_Screen_Shot_2021-07-12_at_14.30.25-768x352.png 768w, https://rivery.io/wp-content/uploads/2021/05/14d49bd57b924368b74d9418f8511d90_Screen_Shot_2021-07-12_at_14.30.25-1024x470.png 1024w, https://rivery.io/wp-content/uploads/2021/05/14d49bd57b924368b74d9418f8511d90_Screen_Shot_2021-07-12_at_14.30.25-293x134.png 293w, https://rivery.io/wp-content/uploads/2021/05/14d49bd57b924368b74d9418f8511d90_Screen_Shot_2021-07-12_at_14.30.25-250x115.png 250w, https://rivery.io/wp-content/uploads/2021/05/14d49bd57b924368b74d9418f8511d90_Screen_Shot_2021-07-12_at_14.30.25-1090x500.png 1090w, https://rivery.io/wp-content/uploads/2021/05/14d49bd57b924368b74d9418f8511d90_Screen_Shot_2021-07-12_at_14.30.25-540x248.png 540w, https://rivery.io/wp-content/uploads/2021/05/14d49bd57b924368b74d9418f8511d90_Screen_Shot_2021-07-12_at_14.30.25-600x275.png 600w, https://rivery.io/wp-content/uploads/2021/05/14d49bd57b924368b74d9418f8511d90_Screen_Shot_2021-07-12_at_14.30.25.png 1264w" sizes="(max-width: 930px) 100vw, 930px" />

Easily Solve Your Most Complex Data Challenges

Get Started for Free

Talk To An Expert

No Credit Card Required.