This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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} ;; | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
pricing.distinct_id, | |
viewed_pricing_at, | |
viewed_sign_up_at | |
FROM ( | |
SELECT | |
distinct_id, | |
time AS viewed_pricing_at | |
FROM mp.event | |
WHERE |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[ | |
{ | |
"dataset": "$mixpanel", | |
"distinct_id": "162a9bea91d1cb-01213631147e12-3f636c4c-1aeaa0-162a9bea91e8cf", | |
"labels": [], | |
"name": "Signed Up", | |
"properties": { | |
"$browser": "Safari", | |
"$browser_version": 11.1, | |
"$city": "Verrieres-le-Buisson", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function main() { | |
return Events({ | |
from_date: '2018-04-09', | |
to_date: '2018-04-09', | |
event_selectors: [{event: 'Signed Up'}] | |
}); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 ;; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
view: mp_events { | |
sql_table_name: mp.event ;; | |
dimension: event_id { | |
primary_key: yes | |
type: number | |
sql: ${TABLE}.event_id ;; | |
} | |
dimension: browser { |