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 int

A 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.

Supporting organizations: 

Project information

Releases