I have 3 questions about Podlove Analytics.
(1) My analytics page says I had 1,495 downloads in September and 5,127 all time.
But if I do this query in MYSQL: “SELECT COUNT(DISTINCT
accessed_at BETWEEN ‘2017-09-01 00:00:00’ and ‘2017-09-30 23:59:59’” I get 607 downloads in September.
And if I change COUNT(DISTINCT
request_id) to COUNT(*) instead, I get 4,355 downloads in September.
How does the plugin arrive at 1,495 downloads in September (in my instance)?
(2) If I click on a specific episode from the Analytics main page, I get a set of graphs headed by a graph that tracks three factors: Cumulative, Current Episode, and Average Episode. Can you define for me what each of these factor labels mean?
(3) What does the httprange field track in the wp_podlove_downloadintent table?