Skip to content

Instantly share code, notes, and snippets.

@mattm

mattm/pricing-page.sql

Created April 12, 2018 19:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mattm/0034dbe3e87929c209a0ae9a31cc51f7 to your computer and use it in GitHub Desktop.
Save mattm/0034dbe3e87929c209a0ae9a31cc51f7 to your computer and use it in GitHub Desktop.
Download ZIP
Viewed Pricing Page
Raw
pricing-page.sql
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 |
+----------------------------------------------------+--------------------------------+
| 1628dfc9f7e0-0184dcc4e-71615c5a-49a10-1628dfc9f800 | 2018-04-03 17:09:27.000000 UTC |
| 16291bd96456-01abc2a0f-87a6c72-2c880-16291bd9648ae | 2018-04-04 10:41:32.000000 UTC |
| 162936a4e6f37-01526b61-6b4b327d-25800-162936a4e738 | 2018-04-04 18:27:46.000000 UTC |
| 162a0381d481-0b3137c58-60031d3c-3d10d-162a0381d496 | 2018-04-07 06:10:35.000000 UTC |
+----------------------------------------------------+--------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment