The draw query language is relational and structured in tables. This documentation is an overview of those tables. Fields are interpreted as a custom single table.
Contains all unique consumers which ever interacted in any way with the site. A consumer is only captured once and he will be identifier as long as he does not delete his cookies.
Contains all experiments created through the editor or the DuckProve user interface. To use the experiment table in a useful manner, it should be used together with the @sessions and field tables.
Contains all associated tags for each experiment. This is a table very often used with joins in generic custom reports in order to illustrate overall statistics.
The primary is a virtual table which corresponds to the currently selected primary fields table. Field tables are automatically created and can be deleted at any time.
Contains all sessions created automatically by the consumers. A session is destroyed after the browser closes or the cookies are deleted.
Contains all tags which are dynamically managed through the experiments description. A tag can be used to group experiments together.
The user agents table holds data of all kinds of user agents it knows about. Generally the view stores a relation to the user agent.
Contains all page views made on the website. A page view represents a single HTTP Request made to a site which has DuckProve installed.
All fields are interpreted as custom tables. Those tables are called field tables and contain the goal data.
Field tables are automatically created and can be deleted at any time.