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
- dbt package documentation
What does this dbt package do?
This package enables you to aggregate and model data from multiple Fivetran social media connections, standardize schemas from various social media connections, and analyze post performance by clicks, impressions, shares, likes, and comments. It creates enriched models with metrics focused on unified social media reporting across platforms.
Currently, this package supports the following social media connector types:
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:
<your_database>.<connector/schema_name>_social_media_reporting
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:
|
Materialized Models
Each Quickstart transformation job run materializes the following model counts for each selected connector. The total model count represents all staging, intermediate, and final models, materialized as view, table, or incremental:
| Connector | Model Count |
|---|---|
| Social Media Reporting | 6 |
| Facebook Pages | 11 |
| Instagram Business | 7 |
| LinkedIn Company Pages | 23 |
| Twitter Organic | 11 |
| Youtube Analytics | 11 |
¹ Each Quickstart transformation job run materializes these models if all components of this data model are enabled. This count includes all staging, intermediate, and final models materialized as view, table, or incremental.
Prerequisites
To use this dbt package, you must have the following:
- At least one Fivetran Social Media Reporting connection syncing data into your destination.
- A BigQuery, Snowflake, Redshift, Postgres, or Databricks destination.
Connector: Have at least one of the below supported Fivetran ad platform connections syncing data into your destination. This package currently supports:
While you need only one of the above connections to utilize this package, we recommend having at least two to gain the rollup benefit of this package.
How do I use the dbt package?
You can either add this dbt package in the Fivetran dashboard or import it into your dbt project:
- To add the package in the Fivetran dashboard, follow our Quickstart guide.
- To add the package to your dbt project, follow the setup instructions in the dbt package's README file to use this package.
How is this package maintained and can I contribute?
Package Maintenance
The Fivetran team maintaining this package only maintains the latest version of the package. We highly recommend you stay consistent with the latest version of the package and refer to the CHANGELOG and release notes for more information on changes across versions.
Contributions
A small team of analytics engineers at Fivetran develops these dbt packages. However, the packages are made better by community contributions.
We highly encourage and welcome contributions to this package. Learn how to contribute to a package in dbt's Contributing to an external dbt package article.