analytic
113 sites
Security covered
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.