{"repo":"fivetran/dbt_social_media_reporting","free":true,"listed":false,"github":"https://github.com/fivetran/dbt_social_media_reporting","clone":"git clone https://github.com/fivetran/dbt_social_media_reporting.git","description":"Fivetran's social media reporting dbt package. Combine your Facebook Pages, Instagram Business, Twitter Organic, and LinkedIn Pages social activity using this package.","language":null,"stars":24,"topics":["dbt","dbt-packages","facebook","fivetran","instagram","linkedin","social-media","twitter"],"license":"Apache-2.0","category":"data-pipelines","readme_excerpt":"Social Media Reporting dbt Package This dbt package transforms data from Fivetran's Social Media Reporting connector into analytics-ready tables. Resources - Number of materialized models¹: 6 - Connector documentation - Facebook Pages connector documentation - Instagram Business connector documentation - Twitter Organic connector documentation - Linkedin Pages connector documentation - Youtube Analytics connector documentation - 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. 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 :---- :---- social media reporting rollup report Consolidates post performance across multiple social media platforms (Facebook, Instagram, LinkedIn, Twitter, and YouTube Analytics) to compare engagement, reach, and content effectiveness in one unified view. Example Analytics Questions: Which social media platform drives the highest engagement and reach for your content? How does content performance compare across different platforms and account types? What posting strategies work best across your entire social media presence? Materialized Models Each Quickstart transformation job run materializes the following model counts for each selected ","default_branch":null,"files":null,"tree":[],"storefront":"/r/fivetran","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/fivetran/dbt_social_media_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."}