SQL Report
Query your data directly
The SQL Report gives analysts and technical users direct access to your KISSmetrics data via SQL queries. When the standard reports don't quite fit your needs, SQL lets you build exactly the analysis you need with no limitations.
Get Started for FreeWhy This Report Matters
Some questions require custom analysis that no pre-built report can answer. SQL access means your data team can explore any hypothesis, build any metric, and answer any question - with the full power of SQL at their fingertips.
Questions This Report Answers
If you're asking these questions, the SQL Report is your answer.
What custom analysis does my business need?
How can I join KISSmetrics data with other sources?
What advanced aggregations would help my analysis?
How can I build custom metrics not available in standard reports?
What edge cases need investigation that standard reports miss?
SQL Report in Action
Interactive demo or screenshot showcasing the SQL Report interface, configuration options, and example insights.
Key Capabilities
Everything the SQL Report can do for your analysis.
Direct SQL Access
Write standard SQL queries against your KISSmetrics data. Full SELECT capabilities with no artificial limitations.
Custom Query Building
Build any query you need - complex JOINs, subqueries, window functions, CTEs. If SQL supports it, you can do it.
Advanced Aggregations
Go beyond simple counts and sums. Use percentiles, running totals, moving averages, and custom calculations.
Data Source Joins
Combine KISSmetrics data with external data sources for comprehensive analysis.
Query Results Export
Export query results for further analysis in spreadsheets, BI tools, or other systems.
Saved Queries
Save and share queries with your team. Build a library of custom analyses.
Real-World Use Cases
How teams use the SQL Report to drive business results.
Custom Metric Definition
Build metrics that don't exist in standard reports.
Example:
Calculate "time to value" as the median days between signup and first core action completion.
Complex Cohort Analysis
Build cohorts with logic too complex for the UI.
Example:
Users who did A, then B within 3 days, but not C before D, grouped by acquisition month.
Edge Case Investigation
Investigate specific scenarios that standard reports aggregate away.
Example:
Find all users who experienced the same bug pattern in the last 48 hours.
Data Export for ML
Extract data for machine learning models and predictive analytics.
Example:
Export feature vectors for churn prediction model: activity frequency, feature usage, tenure, etc.
Pro Tips
Get the most out of the SQL Report with these expert recommendations.
Start with simpler queries and build complexity incrementally.
Use CTEs (WITH clauses) to make complex queries more readable.
Test queries on small date ranges before running against full history.
Document your queries - what question does this answer and why did you build it this way?
Share useful queries with your team to build institutional knowledge.
Ready to try the SQL Report?
Free to start. Full access to all 9 report types.