Is it possible to import my own data into Google Analytics?

Question

I want to compare my own data with the data generated by Google Analytics. For example, I want to see the number of my Twitter followers compared to my page visitors per day.

Is there a way to do something like this?

Answer 1

As far as I know, it’s not possible to import your data into Google Analytics. However, you can export data from Google Analytics and compare it with your own data in Open Office, Excel, or another graphical solution.

Google Analytics - Data Export API - Java (v2) - http://analytics.blogspot.com/2009/08/analytics-data-in-excel-through-our-api.html

Google Analytics Blog - Analytics data in Excel through our API - http://code.google.com/apis/analytics/docs/gdata/2.0/gdataJava.html

Google Analytics - How to Export a Google Analytics Report - http://www.google.com/support/analytics/bin/answer.py?hl=en&answer=57161

SEOmoz - How to export Google Analytics data to Excel via API - http://www.seomoz.org/blog/how-to-export-google-analytics-data-to-excel-via-the-api

Answer 2

Check out http://megalytic.com . You can upload both Google Analytics and Twitter to the same Excel workbook. Handles Facebook, Omniture and others.

Answer 3

You can write a script that runs daily on the server and connects to Twitter to measure the number of subscribers, and then uploads the number of subscribers to Google Analytics. You can also report this event to Google Analytics when you receive a new follower or when a follower tracks you.

There are several options for loading data into Google Analytics:

1. Use a library that implements the server-side ga.js script

When you use Google Analytics as described by Google, you include the script in your site. This script sends data from the visitors browser to the Google Analytics server.

This script was reverse engineered and implemented in server side libraries. Now you can send the same data from the server to the Google Analytics server. You can use PHP-GA for PHP or pyga for Python.

2. Use the Google Analytics measurement protocol

The Google Analytics Measurement Protocol is the new API for sending data to Google Analytics. You can send data by sending POST requests to the API.

Answer 4

For a higher-level overview, you can use SWIX - I have not tried it, but it allows you to make dashboards with input from a bunch of pre-generated sources, including Twitter, Facebook and GA. I suspect you could build something similar with YouCalc , but it should work out of the box with SWIX.

Answer 5

If you want to use Google Sheets (which I can recommend), you can use a simple script to automatically import Google Analytics data.

The following is a complete description of how to configure it: http://spreadsheetpro.net/how-to-import-google-analytics-data-into-google-spreadsheets-in-3-simple-steps/

Answer 6

You can use the Measurement Protocol to import your own data in real time. It does not support data loading in more than 4 hours (see the Queue time parameter). Therefore, you need to run updates regularly.

Answer 7

Google Analytics supports many different cases of using data import, which can be performed both through the API and through the Web interface . Currently, a specific use case may not be supported, but you may still be able to use it using some combination of Measurement Protocol and Import User Data.