Use our ad reporting dbt package to compare ad spend performance across multiple advertising platforms.
Fivetran’s pre-built ad reporting dbt package aggregates data from our most popular advertising connectors. The package 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 dbt package on the Fivetran blog.
IMPORTANT: You do not need to have all of these connector types to use this package, though you should have at least two.
The ad reporting dbt package supports the following connectors:
- Facebook Ads
- Google Ads
- LinkedIn Ad Analytics
- Microsoft Advertising
- Pinterest Ads
- Snapchat Ads
- Twitter Ads
To add the ad reporting dbt package to your dbt project, see our dbt setup guide.