Skip to content
This repository has been archived by the owner on Feb 28, 2024. It is now read-only.

looker/app-marketing-facebook-ads-stitch-redshift

Repository files navigation

Facebook Ads

LookML files for a Facebook block compatible with Stitch's Facebook Ads Insights ETL.

To use this block, you will need to:

Include it in your manifest.lkml:

Note: This 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-facebook-ads-adapter

manifest.lkml

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


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

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

manifest.lkml
```LookML

remote_dependency: app-marketing-facebook-ads-adapter {
  url: "git://github.com/looker/app-marketing-facebook-ads-stitch-redshift"
  ref: "16795ca4726f79f808d274a4765781c72c974d4b"
}

remote_dependency: app-marketing-facebook-ads {
  url: "git://github.com/looker/app-marketing-facebook-ads"
  ref: "5a7d003d98be5b5adc93d7fd90bdd4105461186a"
}```

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

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

For example:

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

  dimension: facebook_ads_schema {
    hidden: yes
    sql:facebook_ads_stitch;;
  }
}
  1. Include the view files in your model.

For example:

marketing_analytics.model.lkml

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

For a reference of all of the fields names and definitions reference Facebook’s API documentation for breakdowns and parameters.

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages