search

mydatastack / pipes

One-click deployment, open source platform for moving data with radically less overhead and cost
2 stars 5 forks source link

Use cases for materialized views #9

Open tarasowski opened 5 years ago

tarasowski commented 5 years ago

This exec tearsheet is our most important dashboard. Each dashboard included the metrics that the teams were responsible for in the exec tearsheet, and also included other supporting metrics. The metrics that we measure exist in relation to our engagement funnels. You can think of three funnels at 500px: 1) visitor -> signup -> daily active -> daily engaged -> paid subscriber 2) visitor -> signup -> photo upload -> photo submit to marketplace -> photo sold on marketplace 3) visitor -> signup -> purchase photo from marketplace

Each team owns different parts of this funnel for different products:1) The marketing teams own (page views) and the top and bottom (revenue) of this funnel. 2)The product teams has less of an emphasis on top of funnel metrics. 3)The development teams (web and mobile), want to see the entire funnel with respect to their own products.

Source: https://medium.com/@samson_hu/building-analytics-at-500px-92e9a7005c83

tarasowski commented 5 years ago

See a full list of sample redshift queries from Amplitute: https://help.amplitude.com/hc/en-us/sections/115001244288-Sample-Redshift-Queries