This package models data from a number of different Fivetran advertising/marketing connectors. The main focus of the package is to standardise the schemas from the various ad connectors and create a single reporting model for all activity.
Currently, this package supports the following ad sources:
This package contains a number of models, all building up to the ad_reporting model, which is a combination of all the data sources. A dependency on all the required dbt packages is declared in this package's packages.yml file, so it will automatically download them when you run dbt deps. The primary outputs of this package are described below.
| model | description |
|---|---|
| ad_reporting | Each record represents the daily ad performance from all sources, including information about the used UTM parameters. |
Check dbt Hub for the latest installation instructions, or read the dbt docs for more information on installing packages.
The package assumes that all packages are 'enabled', i.e. it will look to pull data from all the data sources listed above. If that is not the case, please set the relevant following variables to false:
# dbt_project.yml
...
config-version: 2
vars:
ad_reporting__pinterest_enabled: true
ad_reporting__bing_ads_enabled: true
ad_reporting__linkedin_ads_enabled: trueBy default, this package will look for your advertising data in your target database. If this is not where your advertising data is stored, please add the relevant _database variables (below) to your dbt_project.yml file.
By default, this package will also look to specific schemas for each of your data sources. The schemas for each source are highlighted in the code snippet below. If your data is stored in a different schema, please add the relevant _schema_ variables (below) to your dbt_project.yml file.
# dbt_project.yml
...
config-version: 2
vars:
bing_ads_schema: your_database_name
bing_ads_database: bing_ads
linkedin_schema: your_database_name
linkedin_database: linkedin_ads
pinterest_schema: your_database_name
pinterest_database: pinterest_ads For additional configurations information, please visit the relevant packages, as listed above.
Additional contributions to this package are very welcome! Please create issues
or open PRs against master. Check out
this post
on the best workflow for contributing to a package.
- Learn more about Fivetran here
- Check out Fivetran's blog
- Learn more about dbt in the docs
- Check out Discourse for commonly asked questions and answers
- Join the chat on Slack for live discussions and support
- Find dbt events near you
- Check out the blog for the latest news on dbt's development and best practices