I am tracking the number of reads per author done in the last 30 days. This is straightforward as it directly gives me the value. However, since the number of posts published by each author can vary, I wanted to calculate the number of avg. reads per author based on the articles read.
Unique articles that were read in the last 30 days (event-post title) - 10
Total no. of reads (event- read) - 300
Unique articles that were read in the last 30 days (event-post title) - 1
Total no. of reads (event- read) - 40
I want the final metrics to be something like this
Author 2 - 40 (40/1)
Author 1 - 30 (300/10)
I can’t get this cause when I add post title event under breakdown, it segregates the total articles into individual article names.
This is what I use in insights reports
Event - Post reads
Breakdown - Author
Breakdown - Post title
I cannot use post title as event as it is not an event.
Is there a way to do this?
Thanks in advance.
Best answer by Muffaddal Qutbuddin
Basically you will divide total read by unique reads and breakdown by author. This will get you avg reads per user. Note: Unique read will be unique users and not unique post