SQL and Data Cheat Sheets for Product Managers

Define the result you need before writing a query and check what the returned rows represent. The free English A4 PDF contains four fillable sheets with checks to work through and space to record decisions.

What’s inside

• From question to query. Specify the population and whether a row should represent a user, account, event or time period.
• Product funnel. Record who can enter the funnel, how steps are ordered and how participants are identified.
• Cohort retention. Define cohort entry and return events, then compare groups over equivalent observation windows.
• Result quality. Check whether joins duplicate records or missing data changes which records are counted.