By Taylor Mcgrath

Facebook Ads - Snowflake

Integrates with:
facebook ads integration
The Facebook Ads kit combines data from multiple entities in the Facebook Ads Marketing API and provides a full data model in Snowflake for tracking paid Facebook performance and insight analysis.

This kit includes

Data ingestion from the following Facebook Ads entities:

Logic that orchestrates and transforms raw Facebook Ads data to create a data model with related paid FB entities

Minimum RPU Consumption: 7

For a full list of included fields and output tables, see here.

Configuring this kit for use

In this kit, there are two variables that are used to make for dynamic use of target configuration.
{fb_ads_db} is used in all Target configurations and queries as the target database name.
{fb_ads_schema} 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 fb_ads_db and fb_ads_schema. Then fill in the values as the Snowflake database and schema where you would like the data to land.

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

Have questions about this kit?

Set up a meeting with a Rivery solutions engineer.


Time to Ride the River