Hi everyone,I've been asked to create a report (in report builder) containing several week's worth of Unique Visitor data split out by week, i.e:Report:Week 1: xxxWeek 2: xxxWeek 3: xxxWeek 4: xxxI would typically do this by using the "Apply Granularity: Weekly" function. However, this will only giv...

Thanks Tanmay,I am trying to create this metric so that it can work with an eVar. I have an eVar set to hit that changes on each page view. I want to show an average time on each page view where this eVar is present, in a similar way to average time spent on page. So the report would look like:eVar ...

Hi everyone,I want to create a calculated Average Time spent on Page metric. I was thinking something along the lines of;([Total Seconds Spent] / ([Page Views] - [Bounces])Has anyone made this before? Would it be a good idea to also factor in Exits?ThanksToby

Hi Ryan,Thanks for this - a brilliantly simple solution.  Have a great weekend.Tobz

Hi,I'm creating a report in Excel in which I want to include all clicks on links to an external website that is linked to across our site. My initial thought was to create a segment of:Hit: Exit Link contains www.example.comAnd put this into a site metrics or site totals report in report builder wit...

Thanks, That's really helpful. I'll take a look into the implementation, but it might be worth holding out until the new version is released.Toby

Hi everyone,I hope you're all good.I was recently doing some tidying using Scheduled Reports manager in the Components Section of the Analytics interface. This caused a mini panic when I noticed that a number of scheduled reports I have created using the Report Builder Excel plugin were (according t...

Hi everyone,I hope you're all good. I regularly receive questions regarding the Visitor ClickMap Overlay Plugin. This is a tool a tend to avoid myself, but other teams seem to have a taste for it. Our ClickMap was implemented before my time, but ObjectID appears to be being set (using the URL), howe...

Hi Martijn,Thanks for this.Nope - no segments applied to the data.Toby

Hi,I've noticed when using report builder, a glitch in the Site Metrics report.I have created a monthly report which runs off a fixed date range: 01/03/2015 - 29/02/2016. The intention being that each month, the overall figures will automatically increase cumulatively, so users will get a running to...