Social Media Reporting Model

Use our social media reporting data model to compare post performance across multiple social media platforms.

Overview

Fivetran's pre-built, dbt Core*-compatible social media reporting data model aggregates data from our most popular social media connectors. The model creates a unified table in your destination that shows your posts' clicks, impressions, shares, likes and comments for each social media platform. With this unified view of your post performance, you can compare how well your posts perform on each platform and maximize your social media engagement.

Supported connectors

IMPORTANT: You do not need to have all of these connector types to use this model, though you should have at least two.

The ad reporting data model supports the following connectors:

• Facebook Pages
• Instagram Business
• LinkedIn Company Pages
• Twitter Organic

Setup guide

To add the social media reporting data model to your dbt project, see our dbt setup guide.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.