Facebook Ads template

In this guide you'll find the JSON file for the Facebook Ads modeling templates and a step-by-step guide on how to implement. Please check out the templates introduction guide to learn how to add a data modeling template in Y42.


In order to use this template, please make sure that you have selected these tables and columns inside your Facebook Ads integration:

 Table name  Column name
  • account_currency
  • account_name
  • action_values
  • actions
  • ad_id
  • ad_name
  • adset_id
  • adset_name
  • campaign_id
  • campaign_name
  • clicks
  • conversions
  • date_start
  • impressions
  • spend


Data lineage



Step-by-step guide

  1. Create a new model.
  2. Name it stg_fb_ads.
  3. Import the JSON file stg_fb_ads.
  4. Replace the INPUT node with your actual Facebook Ads ads_insights table
  5. Commit the model.

Please find the template JSON file down below ⬇️

Was this article helpful?
0 out of 0 found this helpful