ComboStrap Analytics - Data (JSON)
Table of Contents
1 - About
ComboStrap performs regularly analytical calculation on pages.
Since version 1.11
2 - Format
The analytical data are composed of three parts:
- metadata: the metadata
- statistics : page statistics such as words_count, links, header
- quality data:
- low is the low quality page indicator
- quality score data
3 - Access
3.1 - 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)
3.2 - 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
4 - 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