Custom Views
Request a custom data view to display your Hardal analytics exactly the way you need.
This documentation applies to the legacy Hardal platform. View current documentation or open the legacy dashboard.
Custom Views are pre-built SQL views in your Hardal ClickHouse database that surface your data in a specific shape — tailored to your business, your reporting tool, or your team's workflow.
What they are
A Custom View is a named view (e.g. view_daily_revenue_by_product) that Hardal creates in your database. Once active, it's available in:
- The Hardal dashboard
- Any BI tool connected via database connection (Looker Studio, Hex, Tableau, Power BI)
- Direct ClickHouse queries via the API
When to use one
Custom Views are useful when:
- You need a metric or aggregation the built-in reports don't provide
- You want to join Hardal event data with your own fields or segments
- Your BI tool needs data in a specific format or column structure
- You want to share a pre-filtered dataset with a stakeholder without giving full database access
How to request one
Reach out to the Hardal team with a description of what you need:
Contact Hardal Support
Describe your use case and we'll build the view for you
Include:
- What data you want to see
- How it should be grouped or filtered
- Which tool you plan to use it in
Accessing existing views
Once a view is created, query it directly:
SELECT * FROM view_your_custom_view_name
LIMIT 100
Or use the Analytics API to fetch data programmatically.
Database Connection
Connect your BI tool to query Custom Views