Use our ad reporting data model to compare ad spend performance across multiple advertising platforms.
Fivetran’s pre-built, dbt Core*-compatible ad reporting data model aggregates data from our most popular advertising connectors. The model creates a unified table in your destination that shows your ad spend, clicks, and impressions for each advertising platform. With this unified view of your ad campaign performance, you can compare how well your campaigns perform on each platform and optimize your ad spend.
Learn more about the ad reporting data model on the Fivetran blog.
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 Ads
- Google Ads
- LinkedIn Ad Analytics
- Microsoft Advertising
- Pinterest Ads
- Snapchat Ads
- TikTok Ads
- Twitter Ads
To add the ad 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.