1.9K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
Guide Me

40 urls requiring very detailed comprehensive report - where to begin

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi there, I've been tasked with a comprehensive report on a theme within our site.


Situation is that, they're looking for the following (their words):


Page/Content Overview - high level reporting/vanity metrics etc
Landing Page Data - same as above but where the page/url was landing/entry page
Acquisition - method of customer capture; organic, referral etc

Entry path - path users already on site took to page/url

Exit destination - Page path to exit
New/Returning user ratios
Technology/device type used
Search Terms Driving Traffic (more of a GSC query)


NB all of the above requires the last 80days vs the 80days previous.


As you can imagine the pages themselves have associated content pieces... some have pagination (about 600 separate content items) and an additional complication is that much of this content was hosted externally and migrated in, so there are multiple redirects in place adding to all the source/channel data.


Now i can pull all of this individually and compile..l but that's pretty mega and i am sure there must be a way of constructing into a single report in a relatively time efficient manner. I've started pulling through individual items but it's proving laborious... can anyone shed any light on how i can do this quicker and easier, maybe someone has a prebuilt solution out there or a sneaky shortcut??? Anything at all is most appreciated.


Kind regards, 



1 Expert replyverified_user

Re: 40 urls requiring very detailed comprehensive report - where to begin

Top Contributor
# 2
Top Contributor
Grunt work is unavoidable, but you can automate the result using either the free Google Analytics Spreadsheet Add-on for Google Sheets, or the free Analytics Edge Add-in for Excel.:

There are also other free and paid reporting tools in the GA Partner Gallery here:
Mike Sullivan, Google Analytics Top Contributor
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.