Ad Reporting Modellink
Updated November 1, 2023
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: For the best performance when using the ad reporting data model, we recommend that you have at least two connectors of any of the supported types in the following list.
The ad reporting data model supports the following connectors:
- Amazon Ads
- Apple Search Ads
- Facebook Ads
- Google Ads
- LinkedIn Ad Analytics
- Microsoft Advertising
- Pinterest Ads
- Reddit 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.