Expand my Community achievements bar.

SOLVED

## Average Visits per blogentry and its release

Level 5

I am having a question and maybe anybody could help me out on this.

We are having blog articles which get released diefefrently and also have different releasedates and amount of days.

What I would like to to is to see the total amount of all blog articles and per article plus per article its average amount of visits during their release times.

Here an example of my freeform I would like to see:

visits   average visits

blog 1 (3 days-public) 300 visits     300/3=100

blog 2 (4 days) public    200 visits   200/4= 50

is there a chance to do such thing and if yes, how? should I work with distic count of days?

I hope someone could help me out on this.

Best

laetizia

1 Accepted Solution

This would be pretty tough to get within the Analytics UI, but I could see it reasonably working within Report Builder. It would require some implementation changes, though.

1. First, you'd want to implement an eVar that is populated with publish date. You could also create a classification of publish date which would be retroactive, but that might be a pain to maintain. You'll want to ensure Excel can understand and recognize the date format you put it in.
2. Once you have publish date as available data somewhere, create a data request in report builder with the following:
1. Blog post name (column A)
2. Broken down by publish date (there should only be 1 per blog post - column B)
3. Page views as a metric (column C)
3. This should create a simple request that shows the top blog posts, their respective publish date, and how many page views it has during whatever date range you specify.
4. Column D would be a date difference formula, so something like "Today minus column B" - this will give you the number of days the blog post has been active
5. Column E would have the data you're looking for, which would be column C (page views) divided by column D (number of days published).
6. From there you can schedule the workbook to be sent to you on a regular basis. The only thing that you'd need to do at that point would be to sort by column E instead of column C, since Report Builder only sorts by Analytics data.