# ComboStrap Analytics - Data (JSON)

ComboStrap performs regularly analytical calculation on pages.

## Format

The analytical data are composed of three parts:

## Access

This data are accessible:

### URL

You can get the analytical data as json with an export.

• via a direct URL by by adding ?do=export_combo_analytics to a page URL. For instance, to get the data of the actual page, click on this link
• via the Analytics menu item by clicking on the following icon (only for logged user)

### Database

The Analytical data are stored in the database in the analytics column of the page table in a json format. You can then query it with the json function of SQLite.

For instance, you can then execute a query such as the following that extracts low quality pages and their words and links statistics

select
id,
json_extract(analytics,'$.quality.failed_mandatory_rules') as failed_rules, json_extract(analytics,'$.statistics.words_count') as words,
json_extract(analytics,'$.statistics.internal_links_count') as internal_links, json_extract(analytics,'$.statistics.internal_backlinks_count') as internal_backlinks
from
pages
where
json_extract(analytics, '\$.quality.low') = true


To know how to query the database online, check this page ComboStrap Analytics - How to query the analytics database

## JSON Support

JSON supports was added for SQLite 3.9.0 (2015-10-14).

• You can verify your version with this query
select sqlite_version();

• You can also verify that you have the JSON extension compiled with the following pragma
PRAGMA compile_options;

• An extension can be installed .

If you don't have the JSON extension or can't install it, you can always download the database file and query it locally for instance with dbeaver