ComboStrap Analytics - Data (JSON)

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