LinkedIn Ad Analytics (Source)

This package models LinkedIn Ad Analytics data from Fivetran's connector. It uses data in the format described by this ERD.

Models

This package contains staging models, designed to work simultaneously with our LinkedIn Ad Analytics modeling package. The staging models:

• Name columns consistently across all packages:
  • Boolean fields are prefixed with is_ or has_
  • Timestamps are appended with _at
  • ID primary keys are prefixed with the name of the table. For example, the campaign table's ID column is renamed campaign_id.

Installation Instructions

Check dbt Hub for the latest installation instructions, or read the dbt docs for more information on installing packages.

Configuration

By default, this package will look for your LinkedIn Ad Analytics data in the linkedin_ads schema of your target database. If this is not where your LinkedIn Ad Analytics data is, please add the following configuration to your dbt_project.yml file:

# dbt_project.yml

...
config-version: 2

vars:
    linkedin_schema: your_database_name
    linkedin_database: your_schema_name 

Additionally, the package allows you to select whether you want to add in costs in USD or the local currency of the ad. By default, the package used USD. If you would like to have costs in the local currency, add the following variable to your dbt_project.yml file:

# dbt_project.yml

...
config-version: 2

vars:
    linkedin__use_local_currency: True

Contributions

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.

Resources:

• Find all of Fivetran's pre-built dbt packages in our dbt hub
• 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