Goal completion rate
SQL query for Piwik Pro
Calculate the goal completion rate from the Goals table.
SELECT goal_name, COUNT(CASE WHEN is_completed = 1 THEN 1 END) / COUNT(*) AS completion_rate FROM Goals GROUP BY goal_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