By Alex Rolnik

Facebook Ads - BigQuery

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 for tracking paid Facebook performance and insight analysis.

This Kit can be used in combination with the Modular Marketing Logic Kit to create a full spectrum marketing analysis table. Find out how to do this using the directions in the Modular Marketing Logic Kit preview.

This kit includes

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 three variables that are used to make for dynamic use of target configuration. 

  • {Dataset_Facebook_Ads} is used in all Target configurations and queries as the target database name.
  • {Facebook_Alert_Group} is used as the alert email address(es) for when a river fails (Optional).
  • {gcs_file_zone} is used as the File Zone Bucket for all BigQuery Target configurations. This variable should already exist in your Rivery account as long as a BigQuery connection has previously been created. 

Go to the Variables menu on the left side navigation bar and create variables for Dataset_Facebook_Ads and Facebook_Alert_Group. Then fill in the values as the Google BigQuery dataset 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

Easily Solve Your Most Complex Data Challenges

No Credit Card Required.