Total number of visits per app
SQL query for Piwik Pro
Get the total number of visits for each app in the Apps table.
SELECT app_name, COUNT(*) AS total_visits FROM Apps GROUP BY app_name
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