By Alex Rolnik

Facebook Ads

Integrates with:
facebook ads integration etl to redshift

The Facebook Ads Kit combines data from multiple entities in the Facebook Ads Marketing API and provides a full data model for tracking paid Facebook performance and insight analysis. 

This Kit includes…

Data flow and data model diagrams

 

Configuring this Kit for use

Variables

In this Kit, there are two variables that are used to make for dynamic use of target configuration. 

  • {SCHEMA_facebook_Ads} is used in all Target configurations and queries as the target schema name.
  • {Facebook_Ads_Failure_Group} is used as the alert email address(es) for when a river fails.
  • {aws_file_zone} is used as the File Zone Bucket for all Redshift Target configurations. This variable should already be populated in your Rivery account as long as a Redshift connection has previously been created. 

Go to the Variables menu on the left side navigation bar and create variables for SCHEMA_Facebook_Ads and Facebook_Ads_Failure_Group. Then fill in the values as the Redshift 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

 

Have questions about this Kit?

Set up a meeting with a Rivery solutions engineer.