By Taylor Mcgrath

Marketing Analytics B2C - Snowflake

Integrates with:
facebook ads integration Snapchat data integration
The Marketing Analytics B2C kit combines Ad Performance data from Facebook Ads, Twitter Ads, and Snapchat Ads APIs into one consolidated data model, centralized in your data warehouse. This enables standardized, cross-channel advertisement analysis and performance tracking.

This kit includes

Data ingestion from the following Facebook Ads entities:

– Data ingestion rivers for ad statistics and entities for Facebook Ads, Twitter Ads, and Snapchat Ads
– Logic that creates a Marketing data model across the three platforms
– Master orchestration river

Minimum RPU Consumption: 17

For more information on the schema, data model, and output fields in this kit, see here.

Configuring this kit for use

Variables
In this kit, there are two variables that are used to make for dynamic use of target configuration.
{db_marketing_b2c} is used in all Target configurations and queries as the target database name.
{schema_marketing_b2c} is used in all Target configurations and queries as the target schema name.
Go to the Variables menu on the left side navigation bar and create variables for db_marketing_b2c and schema_marketing_b2c. Then fill in the values as the Snowflake database and schema where you would like 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 template

Have questions about this kit?

Set up a meeting with a Rivery solutions engineer.

Time to Ride the River

Rivery is free to try - no credit card required.