Content.Ad - Snowflake
The Content.ad Kit contains the necessary rivers to pull data from three popular Content.ad reports: advertiser by ads, advertiser by campaigns, and advertiser click. Content.ad is a digital advertisement platform that helps brands and advertisers promote and engage their digital content across multiple channels.
This Kit includes…
- Predefined Report river to pull data from the advertiser endpoint grouped by ads and campaigns
- Source report river to pull data from the advertiser click report endpoint with the following properties
- Logic that runs both rivers in parallel
Minimum RPU Consumption: 4
Configuring this kit for use
Variables
In this Kit, there are three variables that are used to make for dynamic use of target configuration.
- {Database_Content} is used in all Target configurations and queries as the target database name.
- {Schema_Content} is used in all Target configurations and queries as the target database name.
- {Content_Alert_Group} is used as the alert email address(es) for when a river fails (optional).
Go to the Variables menu on the left side navigation bar and create variables for Database_Content, Schema_Content, and Content_Alert_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 Kit
