mattm

explore: mp_events {
  view_label: "Mixpanel"
  label: "Mixpanel"

  join: mp_new_blog_content {
    view_label: "Mixpanel"
    type: left_outer
    relationship: many_to_one
    sql_on: ${mp_new_blog_content.current_url} = ${mp_events.current_url} ;;
  }

mattm

SELECT
  COUNT(viewed_pricing_at) AS viewed_pricing,
  COUNT(viewed_sign_up_at) AS viewed_sign_up,
  COUNT(signed_up_at) AS signed_up
FROM (
  SELECT
    pricing.distinct_id,
    MIN(viewed_pricing_at) AS viewed_pricing_at,
    MIN(viewed_sign_up_at) AS viewed_sign_up_at,
    MIN(signed_up_at) AS signed_up_at

mattm

SELECT
  pricing.distinct_id,
  MIN(viewed_pricing_at) AS viewed_pricing_at,
  MIN(viewed_sign_up_at) AS viewed_sign_up_at,
  MIN(signed_up_at) AS signed_up_at
FROM (
  SELECT
    distinct_id,
    time AS viewed_pricing_at
  FROM mp.event

mattm

SELECT
  pricing.distinct_id,
  viewed_pricing_at,
  viewed_sign_up_at,
  signed_up_at
FROM (
  SELECT
    distinct_id,
    time AS viewed_pricing_at
  FROM mp.event

mattm

SELECT
  pricing.distinct_id,
  viewed_pricing_at,
  viewed_sign_up_at
FROM (
  SELECT
    distinct_id,
    time AS viewed_pricing_at
  FROM mp.event
  WHERE

mattm

SELECT
  distinct_id,
  time AS viewed_pricing_at
FROM mp.event
WHERE
  name = "Viewed Page" AND
  current_url LIKE "https://www.helpscout.net/pricing/%"
  
+----------------------------------------------------+--------------------------------+
|                    distinct_id                     |       viewed_pricing_at        |

mattm

[
    {
        "dataset": "$mixpanel",
        "distinct_id": "162a9bea91d1cb-01213631147e12-3f636c4c-1aeaa0-162a9bea91e8cf",
        "labels": [],
        "name": "Signed Up",
        "properties": {
            "$browser": "Safari",
            "$browser_version": 11.1,
            "$city": "Verrieres-le-Buisson",

mattm

function main() {
  return Events({
    from_date: '2018-04-09',
    to_date: '2018-04-09',
    event_selectors: [{event: 'Signed Up'}]
  });
}

mattm

connection: "bigquery"

include: "*.view.lkml"

explore: mp_events {
  view_label: "Mixpanel"
  label: "Mixpanel"

  sql_always_where: STRPOS(${full_url}, "https://www.helpscout.net") = 1 OR STRPOS(${full_url}, "https://secure.helpscout.net") = 1 ;;

mattm

view: mp_events {
  sql_table_name: mp.event ;;

  dimension: event_id {
    primary_key: yes
    type: number
    sql: ${TABLE}.event_id ;;
  }

  dimension: browser {