Custom Reporting using Google Analytics and Google Docs - The Ultimate Analytics Mashup. The author's posts are entirely his or her own (excluding the unlikely event of hypnosis) and may not always reflect the views of Moz.
Realtime Google Analytics data inside a Google Doc—a panacea! Don't believe me? Check out that screenshot below. In this blog post I'll show how you can do this yourself, and I've created an easy template to help get you started. Google Analytics is my favorite analytics product. But, despite all the flexibility that Google Analytics offers, sometimes you want to access data in a spreadsheet and create a truly custom report. This blog post is going to show you how to create a custom report by connecting a Google Spreadsheet directly with your data from Google Analytics.
Analytics geeks: hold onto your seats! It all started with the Data Feed Query Explorer (Those who want to start accessing data in Google Docs should jump right to the next section.) Before we dive in, a little background. I first discovered Google's excellent Data Feed Query Explorer. Application Gallery. This gallery contains applications that extend Google Analytics in new and exciting ways.
They are solutions that help analysts, marketers, IT teams, and executives get more out of Google Analytics. Start by viewing our featured applications below or by browsing our categories to the left. Tableau Software Ted Wasserman - Jan 16, 2013 - About Tableau Software Tableau Software helps people see and understand data. Learn More Ducksboard Ducksboard - Nov 14, 2012 - Ducksboard is a real-time dashboard which helps you visualize and monitor your data in one single place. NEXT Analytics for Excel Nextanalytics - May 06, 2010 - NEXT V5 is the ultimate power tool for web and social media analysts that queries and analyzes data from Google Analytics, Facebook, Twitter, and YouTube.
SkyGlue SkyGlue Technology Inc. - Mar 27, 2012 - Supermetrics Data Grabber for Excel Supermetrics - May 05, 2010 - Chartio Chartio - Sep 10, 2012 - Chartio is building the best visualization interface for data. Google Tag Manager. Tracking social media activity on and off your website. Social media plays a big part in the online world now.
But how much? This post is going to cover a number of methods for tracking social media activity using Google Analytics. Tracking social interaction in and out of your website and seeing how social media users behave on your site is going to give you some of the best insights you could hope for. Other tools are available for tracking social activity, but none really dig deep into your website. Now considering your website is going to be where you make your money, I'm going to focus on that. The areas I'm going to cover here are: Tracking social buttons on your website..Tracking your social media content off your websiteAnalysing traffic from social media sources.A few extra ideas.
Tracking clicks on social buttons In the new version of Analytics, Google has introduced a Social report to automatically track clicks on the +1 buttons located on your site pages. Additionally, you can see which pages have seen which actions, all in one table.