Many of our clients use Excel to manage their ad campaigns, visualize marketing performance, and perform complex data analysis. Most analysts use the Google Analytics Export feature to manually export their report data to CSV files. Then they import the CSV file into Excel. No longer! Now, with the Google Analytics API you can bypass this manual step and export Google Analytics data directly from within Excel! Once you’ve set it up, there’s no need to visit the Analytics reports to view data in Excel.
Thanks to a variety of developers, here are four solutions that can transform you from a reporting monkey to an analysis ninja (as Avinash would say).
ShufflePoint – Works somewhat differently than the solutions above. ShufflePoint has developed a query language that works with the Google Analytics API to achieve common tasks, such as defining the last 30 days as a date range. One then uses this language to construct an Analytics Data Export API query either by navigating to a URL within Excel, or by using their web-based query builder, then importing this data into Excel. This process allows the ShufflePoint solution to work across most versions of Excel, as well as Powerpoint, and iGoogle gadgets.
Shufflepoint’s Web Based Query Builder
We continue to be impressed by the new solutions developers are bringing to market by leveraging the Google Analytics Platform. If you have developed a useful new tool or integration on top of Google Analytics, drop us an email at firstname.lastname@example.org. If it’s innovative and useful we’ll highlight it to our readers on this blog.
Posted by Nick Mihailovski, Google Analytics API Team
Do you need help growing your business? Srinivas Katam is a Digital Marketing Strategist and Consultant with over 200 successful SEO and Social Media client engagements completed. I’ve worked with brands across the world as a digital marketing consultant to deliver revenue growth from content-focused inbound marketing campaigns. He is an Innovative Marketer who specializes in digital marketing, specifically in social media, SEO and online strategy.