ComboStrap Analytics - Data (JSON)

1 - About

ComboStrap performs regularly analytical calculation on pages.

Since version 1.11

2 - Format

The analytical data are composed of three parts:

3 - Access

This data are accessible:

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