app-marketing-linkedin-ads-fivetran-snowflake's Introduction

LinkedIn Ads

LookML files for a schema mapping on BigQuery for LinkedIn Ads compatible with Fivetran's LinkedIn Ad Analytics ETL. This is designed to work with a ETL agnostic LinkedIn Ads block.

To use this block, you will need to:

Include it in your manifest.lkml:

Note: As of Looker 5.24 this block requires the Project Import feature currently in /admin/labs to be enabled on your Looker instance.

Via local projects:

Fork this repo and create a new project named app-marketing-linkedin-ads-adapter

manifest.lkml

local_dependency: {
  project: "app-marketing-linkedin-ads-adapter"
}


local_dependency: {
  project: "app-marketing-linkedin-ads"
}```

Or remote dependency which don't require a local version.

manifest.lkml
```LookML

remote_dependency: app-marketing-linkedin-ads-adapter {
  url: "git://github.com/looker/app-marketing-linkedin-ads-fivetran-bigquery"
  ref: "3aa0e9dca82f327f9bb79ed7cb8889ea49d0de23"
}

remote_dependency: app-marketing-linkedin-ads {
  url: "git://github.com/looker/app-marketing-linkedin-ads"
  ref: "991ba4a6ff6bb1e3a99c0d3a3e5c77546031097b"
}```

Note that the `ref:` should point to the latest commit in each respective repo [linkedin-ads-fivetran-bigquery](https://github.com/looker/app-marketing-linkedin-ads-fivetran-bigquery/commits/master) and [linkedin-ads](https://github.com/looker/app-marketing-linkedin-ads/commits/master).

2. Create a `linkedin_ads_config` view that is assumed by this project. This configuration requires a  file

For example:

linkedin_ads_config.view.lkml
```LookML
view: linkedin_ads_config {
  extension: required

  dimension: linkedin_ads_schema {
    hidden: yes
    sql:linkedin_ads;;
  }
}

Include the view files in your model.

For example:

marketing_analytics.model.lkml

include: "/app-marketing-linkedin-ads-adapter/*.view"
include: "/app-marketing-linkedin-ads/*.view"
include: "/app-marketing-linkedin-ads/*.dashboard"

For a reference of all of the fields names and definitions reference LinkedIn’s API documentation for Ads Reporting.

Recommend Projects