Article date

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.

Prerequisites

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
ads_insights
  • 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

Bildschirmfoto_2022-04-07_um_17.26.20.png

 

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 ⬇️

Articles in this section

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