By Taylor Mcgrath

Marketing Analytics B2C - Snowflake

Integrates with:
facebook ads 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 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

Upon importing the Kit, you can select pre-existing source and target connections, which will be applied to the imported rivers where applicable. If you skip this step, Kits are imported with ‘blank’ source and target connections. In this case, 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

Minimize the firefighting.
Maximize ROI on pipelines.

icon icon