{"repo":"fivetran/dbt_facebook_ads","free":true,"listed":false,"github":"https://github.com/fivetran/dbt_facebook_ads","clone":"git clone https://github.com/fivetran/dbt_facebook_ads.git","description":"Fivetran data models for Facebook Ads built using dbt.","language":null,"stars":53,"topics":["dbt","dbt-packages","fivetran","facebook-ads"],"license":"Apache-2.0","category":"data-pipelines","readme_excerpt":"Facebook Ads dbt Package This dbt package transforms data from Fivetran's Facebook Ads connector into analytics-ready tables. Resources - Number of materialized models¹: 34 - Connector documentation - Facebook Ads connector documentation - Facebook Ads ERD - dbt package documentation - GitHub repository - dbt Docs - DAG - Changelog - dbt Core™ supported versions - =1.3.0, Note : If you do not have your Facebook Ads connection schema change settings set to Allow all , it is very possible that you are missing basic ad actions or basic ad action values . If you would like to surface conversion metrics in your Facebook and/or Ad Reporting models, please ensure these reports are syncing. Otherwise, the conversions and conversions value fields will be null . Output schema Final output tables are generated in the following target schema: Final output tables By default, this package materializes the following final tables: Table Description :---- :---- facebook ads account report Represents daily performance aggregated at the account level, including spend , clicks , impressions , and conversions . Example Analytics Questions: How does performance compare across different accounts by account manager? Are currency fluctuations affecting results across markets? facebook ads campaign report Represents daily performance aggregated at the campaign level, including spend , clicks , impressions , and conversions . Example Analytics Questions: Which campaigns are most efficient in terms of c","default_branch":null,"files":null,"tree":[],"storefront":"/r/fivetran","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/fivetran/dbt_facebook_ads/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}