Top customers by revenue
SQL query for Piwik Pro
Get the top customers by revenue from the Customers table.
SELECT customer_name, SUM(revenue) AS total_revenue FROM Customers GROUP BY customer_name ORDER BY total_revenue DESC
Piwik Pro data model
Apps
Custom Dimensions
Product Custom Dimensions
User Annotations
System Annotations
Audit Log Entries
Logs
Users
Meta Sites
Modules
Audiences
Goals
Customers
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed