By Alex Rolnik

Marketing Analytics B2C - Databricks

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 the following Facebook Ads entities and statistical reports:

Data ingestion rivers for the following Twitter Ads entities and statistical reports:

Data ingestion rivers for the following Snapchat Ads entities and statistical reports:

Logic that creates a Marketing data model across the three platforms in a Master orchestration river

Minimum RPU Consumption: 17

For more information on the kit, see the links below. 

Data flow diagrams

Data schema information

Configuring this Kit for use


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.
  • {MA_B2C_Alert_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_marketing_b2c and MA_B2C_Alert_Group. Then fill in the values as the Databricks database where you would like the data to land and the email address(es) to which you would like the failure emails sent.


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

Minimize the firefighting.
Maximize ROI on pipelines.

icon icon