ComboStrap Analytics - Data (JSON)

About

ComboStrap performs regularly analytical calculation on pages.

Format

The analytical data are composed of three parts:

• metadata: the page metadata
• statistics: the page statistics such as late publication page, links, header
• quality: the quality data:
  • low is the low quality page indicator
  • quality score data
  • quality rule information

Access

This data are accessible:

• via the database
• or via an URL

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 button
• 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.late publication page') 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