canmove, Confirmed users, Bureaucrats and Sysops emeriti
2,798
edits
Mobile/Metrics/Redash: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
MarkFinkle (talk | contribs) mNo edit summary |
MarkFinkle (talk | contribs) mNo edit summary |
||
| Line 46: | Line 46: | ||
== Useful Queries == | == Useful Queries == | ||
This guide doesn't try to teach SQL, but assumes you have a basic understanding. | This guide doesn't try to teach SQL, but assumes you have a basic understanding. | ||
===Looking at Clients === | |||
Find the profile creation date for clients: | |||
=== Looking at Events === | === Looking at Events === | ||
| Line 90: | Line 93: | ||
submissiondate > current_date - interval '7' day and action = 'loadurl.1' | submissiondate > current_date - interval '7' day and action = 'loadurl.1' | ||
group by 1 | group by 1 | ||
== Resources == | |||
Turns out that many other companies use event data and SQL, so we can benefit from what they have already done. Here are some blogs and posts that might help you build some SQL queries. | |||
* [https://www.periscopedata.com/blog Periscope Data] has a blog with tons of posts on using SQL and event data for analyzing retention, churn and active users. They also cover some general SQL topics too. | |||
* [https://blog.modeanalytics.com/ Mode Analytics] covers using SQL on event data, but has a lot of general analysis posts too. | |||
* [https://segment.com/blog Segment] doesn't cover as much SQL as others, but does have posts on the process of data collection and analysis. Worth taking a look. | |||