Ad Reporting Model

Use our ad reporting data model to compare ad spend performance across multiple advertising platforms.

Overview

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.

Supported connectors

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:

Setup guide

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.