By Alex Rolnik

DCM Standard Report

Integrates with:
DCM is an ad management and ad serving solution that helps agencies and advertisers manage their ad campaigns. The DCM Campaign Standard Report template 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 configured with the relevant keys for continuous data loading.

You can find the full contents used here.

Configuring this kit for use

NOTE: In the Source Tab within the “DCM Display Data” river, you must specify a Profile.

Variables

In this template, there are three variables that need to be initialized to make for dynamic use of the target configuration. 

  • {DB_DCM_Standard_Report} is used in all Target configurations and queries as the target database name.
  • {SCHEMA_DCM_Standard_Report} is used in all Target configurations and queries as the target schema name. 
  • {DCM_Failure_Group} is used as the alert email address(es) for when a river fails.

Go to the Variables menu on the left side navigation bar and create variables for DB_DCM_Standard_Report, SCHEMA_DCM_Standard_Report, and DCM_Failure_Group. Then fill in the values as the Snowflake database and schema where you would like the data to land and the email address(es) to which you would like the failure emails sent.

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 template

Have questions about this kit?

Set up a meeting with a Rivery solutions engineer.

Experience Rivery In Action

Control Your Data. Free Your Business.