Analytic
89 sites
Security covered
This project provides a system for storing and reporting on analytics data. It allows different types of data to be recorded and then viewed using a custom system that combines data from multiple tables and makes it available as fields in the Views UI.
The aim is to have a generic system that other projects, not just Visitors, can use to store analytics and build reports.
All data will be stored in tables using the schema below. The table names will follow this pattern analytic_YYYYMM.
Name Type id serial plugin varchar label varchar value float start datetime end datetime sequence int (1=day,2=week,etc) timestamp intA custom Views query plugin FULL JOIN the table on itself, allowing each "plugin" (column) to be treated as a different field it the Views UI.
This same custom query plugin will UNION the required analytic_YYYYMM tables for a given time range.