Skip to content

Instantly share code, notes, and snippets.

@mattm
Last active October 2, 2018 00:18

Revisions

  1. mattm revised this gist Oct 2, 2018. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions facebook-ad-insights-joining.lookml
    Original file line number Diff line number Diff line change
    @@ -2,10 +2,10 @@ explore: fb_ad_insights {
    label: "Facebook"
    view_label: "Facebook"

    join: fb_ad_insights_action_values {
    join: fb_conversions {
    view_label: "Facebook"
    type: left_outer
    relationship: one_to_one
    sql_on: ${fb_ad_insights.primary_key} = ${fb_ad_insights_action_values.primary_key} and ${fb_ad_insights_action_values.action_type} = "offsite_conversion.fb_pixel_purchase" ;;
    sql_on: ${fb_ad_insights.primary_key} = ${fb_conversions.primary_key} ;;
    }
    }
  2. mattm created this gist Oct 1, 2018.
    11 changes: 11 additions & 0 deletions facebook-ad-insights-joining.lookml
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,11 @@
    explore: fb_ad_insights {
    label: "Facebook"
    view_label: "Facebook"

    join: fb_ad_insights_action_values {
    view_label: "Facebook"
    type: left_outer
    relationship: one_to_one
    sql_on: ${fb_ad_insights.primary_key} = ${fb_ad_insights_action_values.primary_key} and ${fb_ad_insights_action_values.action_type} = "offsite_conversion.fb_pixel_purchase" ;;
    }
    }