Google Analytics Automated Reporting

[lauramrobinson32]

HI all,

I tend to do a big reporting powerpoint deck using screenshots from google analytics and tables I create year end and mid year. It's like an 80 page report for the 10 webisite swe have and then I go ahead and make annotations as I see from the data.

That being said this can take a lot of time, up to a 40 hours of time to pull it all together or more which is challenging when you have daily meetings.

Anyhow, I've looked into automating and tried a couple things:

1. Tableau- but it keeps crashing and seems tedious

2. Dashlane and supergrabber- seem a bit tedious to set up too.

Anyone have ideas on how to better shar ereporting in the organization in this type of format for a website (websites)? Organic, paid, traffic, etc.

Laura

[Stramark]

Consider connecting analytics to google spreadsheets. This way you can create your own dashboards and still pull in the annotations you want for your websites.

https://developers.google.com/analytics/solutions/google-analytics-spreadsheet-add-on

[Matt-Williamson]

Hi Laura

You may want to check out http://www.analyticsseo.com/ - I have worked with this previously and it can produce the sort of reports you are talking about - kicking them out to powerpoint etc - http://www.analyticsseo.com/seo-reports/

You can create custom reports, connected to analytics and choose the format and then schedule the system to automatically run the report at a scheduled interval and email it to you.

Hope this helps

[DmitriiK]

Hello, my friend.

I can't recommend you a solution on a market, since I haven't used any, but what you can use is a automated reporting, built-in in GA.

Or, and this is what I use, Google Analytics API. Gives you all data you want, you can style it however you want and customize it whichever way you want. Takes initial effort, but pays off later. Especially, since you said you gotta do it every year.