{"repo":"fivetran/dbt_ad_reporting","free":true,"listed":false,"github":"https://github.com/fivetran/dbt_ad_reporting","clone":"git clone https://github.com/fivetran/dbt_ad_reporting.git","description":"Fivetran's ad reporting dbt package. Combine your Facebook, Google, Pinterest, LinkedIn, Twitter, Snapchat, Microsoft, TikTok, Reddit, Amazon, and Apple Search advertising metrics using this package.","language":null,"stars":220,"topics":["dbt","dbt-packages","fivetran","ad-reporting","snapchat","twitter","google-ads","adwords","microsoft-ads","pinterest"],"license":"Apache-2.0","category":"data-pipelines","readme_excerpt":"Ad Reporting dbt Package This dbt package transforms data from Fivetran's Ad Reporting connector into analytics-ready tables. Resources - Number of materialized models¹: 10 - Connector documentation - Amazon Ads - Apple Search Ads - Facebook Ads - Google Ads - LinkedIn Ad Analytics - Microsoft Advertising - Pinterest Ads - Reddit Ads - Snapchat Ads - TikTok Ads - Twitter Ads - dbt package documentation - GitHub repository - dbt Docs - DAG - Changelog - dbt Core™ supported versions - =1.3.0, NOTE: You do not need to have all of these connector types to use this package, though you should have at least two. Additionally, individual platform models may include platform-specific metrics and fields that are better suited for deeper, platform-level analysis. 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 :---- :---- ad reporting account report Represents daily performance aggregated at the account level across all advertising platforms, including spend , clicks , impressions , and conversions . Example Analytics Questions: How does cross-platform performance compare across different accounts and platforms? Which advertising platforms are delivering the best ROI by account? Are there seasonal performance patterns consistent across platforms? ad reporting campaign report Represents daily performance aggregated at the campaign level across all advert","default_branch":null,"files":null,"tree":[],"storefront":"/r/fivetran","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/fivetran/dbt_ad_reporting/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."}