ComboStrap Analytics - Page Statistics
About
The ComboStrap Page Statistics are a list of page statistics that are available in the analytical data.
Example Words Summary
For instance, if you want to get statistics over words, you could execute the below query.
select
count(*) as page_count,
round(avg(word_count)) as words_avg,
sum(word_count) as words_count,
max(word_count) as words_max,
min(word_count) as words_min
from
(
select
id,
json_extract(analytics, '$.statistics.word_count') as word_count
from
pages
where
analytics is not null
)
And this is the result that we get on this website.
page_count | words_avg | words_count | words_max | words_min |
---|---|---|---|---|
268 | 181 | 45933 | 1301 | 11 |
See
You can see them by having a look to the data of a page with the export URL. For instance, for this page, you could check them at the following URL
ComboStrap Analytics - Page Statistics
You would see the statistics below the statistics property:
"statistics": {
"char_count": 1919,
"fixme": 0,
"header_count": {
"h1": 1,
"h2": 3
},
"internal_backlink_count": 5,
"internal_link_count": 3,
"internal_link_distance": {
"avg": 0,
"max": 0,
"min": 0
},
"word_section_count": {
"avg": 75
}
}
Definition
- authors the authors and their number of edits
- edit_count: the number of edits
- char_count: the number of chars
- fixme: the number of fixme present in the page
- heading_count: the number of heading by level
- internal_backlink_count: the number of internal backlinks
- internal_link_count: the number of internal links
- internal_broken_link_count: the number of internal broken links
- internal_link_distance: the distance of the internal links with the actual page. A value 2 would mean that you need to go in the directory structure:
- down or up 2 times
- or down one time and up one time
- interwiki_link_count: the number of interwiki links (ie such as this one interwiki)
- local_link_count: the number of local links (ie fragment link such as #id)
- word_section_count: summary on words by section
- word_count: the number of words.
- syntax_count shows the number of times that a syntax is used.
Media
media shows a number of count statistics on media such as image.
Example:
"media": {
"total_count": 5,
"internal_count": 5,
"internal_broken_count": 0,
"external_count": 0
}
where:
- total_count: the total number of media for the page
- internal_count: the number of internal media for the page
- internal_broken_count: the number of internal media that does not exists, creating a broken link
- external_count: the number of external media (ie hosted on an external server, example: https://host/myimage.png)