• Home
  • Google Analytics
    • Customizations
    • For Ecommerce
  • Speaking
  • About
    • About Me
    • Contact Me
    • Disclaimer and Privacy Policy

Analytics Talk

Digital Analytics for Business

You are here: Home / Uncategorized / Set Your Data Free

Set Your Data Free

Posted: June 13, 2006 4 Comments

One of my rants is about web analytics data. Not how accurate it is, but where it belongs. For the majority of people the default reports in a given web analytics package are completely adequate. New visitors, returning visitors, campaign tracking, click path analysis… they’re all very helpful and can be used to optimize your advertising and site content. But, in my opinion, once you really start to dig into the data you begin to realize that no application will support the key performance indicators (KPI’s) that are specific to your business model. And that really is the key. What are the specific performance indicators for your business and how do you measure them?

What’s the solution? Set your data free! Export it from your analytics package and move it to a venue where you can perform your analysis based on the KPI’s that you’ve defined for your business and your website. You could use something as simple as Microsoft Excel. Eric T. Peterson has an outstanding book called the The Big Book of Key Performance Indicators. It comes with an Excel KPI worksheet that you can configure for your use. If you haven’t worked with analytics data outside of your analytics application give it a try, it’s very liberating! And Eric’s book is a great place to start.

Now, I know what you’re saying. “But there is no easy way to export my data from my analytics application.” Believe me, I know. We use Google Analytics & Urchin Software and neither are very friendly when it comes to exporting data. There are export features in both but they require someone to manually click on a link in a report to start the export. Not very usable, especially when you need to export data every day of the week! This shortcoming has not stopped us. We have pieced together solutions that automatically extract an XML or text export of the data so we can work with it in other applications.

For Urchin, there is u5data_extractor.pl, a Perl script on the support site that can be used to export data in text format. We use this script to automate the delivery of analytics data to the appropriate analytics. Then the analyst can import the data to another application for analysis. Depending on your needs you may be able to automate the extraction from Urchin and the insertion into your analysis application.

Getting your data out of Google Analytics is a bit more difficult. I don’t want to give away the screts, but if you know some basic web scripting (including cURL) you should be able to write a script that extracts data from the GA reports.

Do you feel empowered? I hope so. Get out there and start extracting your data!

Filed Under: Uncategorized Tagged With: google-analytics, Tips, urchin, Web Analytics

Comments

  1. trnfrmr says

    May 17, 2007 at 3:06 am

    Can you please say more about how to export more usable data from Google Analytics?

    I would like to join-up/ stitch together adwords campaign and ad group reports.

    Reply
  2. Delgado Business Software says

    January 10, 2009 at 4:53 am

    I’ve been searching HIGH AND LOW for data on how to export Analytics data. I read somewhere that there is now an API but still have not come across it!

    If I come across anything I’ll let you know!

    Reply
  3. Justin Cutroni says

    February 11, 2009 at 4:14 pm

    Yes, there is now an API. It is currently a closed beta, but hopefully Google will roll this feature out to everyone soon.

    Thanks for the comment,

    Justin

    Reply

Trackbacks

  1. Analytics Talk » Top 5 Google Analytics Resolutions for 2007 says:
    January 3, 2007 at 1:14 pm

    […] 4. I will export data from Google Analytics and create my own key performance indicator and reports […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

My Books

Google Analytics by Justin Cutroni
Learn More on Amazon.com

Performance Marketing co-authored by Justin Cutroni
Learn More on Amazon.com

Recent Posts

  • Understanding the Google Analytics Cohort Report
  • Using Offline and Online data to drive Google Analytics Remarketing
  • Understanding Cross Device Measurement and the User-ID
  • Universal Analytics: Now out of beta!
  • Advanced Content Tracking with Universal Analytics

Categories

  • About Google Analytics (25)
  • Analysis (52)
  • Analytics Strategy (3)
  • Campaign Tracking (14)
  • Ecommerce (8)
  • Event Tracking (10)
  • Remarketing (2)
  • Reporting (10)
  • Resources (7)
  • Tag Management (5)
  • Tips (25)
  • Tracking (52)
  • Uncategorized (64)
  • Universal Analytics (9)
  • Web Analytics (15)

Copyright © 2023 ·News Pro Theme · Genesis Framework by StudioPress · WordPress