Creates the dbt model described bellow using Facebook Ads data from Windsor's connector.
| Model | Description |
|---|---|
| ad_report | performance at the ad level |
To use this dbt package, you must sync Facebook Ads data to BigQuery.
- Add five destination tasks following the example below.
- To import the following five tables.
- Using the following fields URL parameters in the Connector URL field.
| Table | Fields parameter |
|---|---|
| account | account_id,account_name |
| campaign | account_id,account_name,campaign_id,campaign |
| ad_set | campaign_id,adset_id,adset_name,adset_start_time,adset_end_time,adset_bid_strategy,adset_daily_budget |
| ad | adset_id,ad_id,ad_name |
| report | ad_id,date,clicks,impressions,spend |
Details about Facebook Ad campaign structure is available here.
- Include the following dbt_facebook_ads package version in your packages.yml file.
packages:
- git: "https://github.com/Oleg-Solovyev/dbt_facebook_ads.git"- Run
dbt deps.
Add the following configuration to your root dbt_project.yml
vars:
dbt_facebook_ads:
report: '<facebook ads schema>.<report table>'
ad: '<facebook ads schema>.<ad table>'