By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    customer experience analytics
    Using Data Analysis to Improve and Verify the Customer Experience and Bad Reviews
    6 Min Read
    data analytics and CRO
    Data Analytics is Crucial for Website CRO
    9 Min Read
    analytics in digital marketing
    The Importance of Analytics in Digital Marketing
    8 Min Read
    benefits of investing in employee data
    6 Ways to Use Data to Improve Employee Productivity
    8 Min Read
    Jira and zendesk usage
    Jira Service Management vs Zendesk: What Are the Differences?
    6 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Using TIBCO Spotfire to Analyze Google Analytics Data
Share
Notification Show More
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Visualization > Using TIBCO Spotfire to Analyze Google Analytics Data
AnalyticsBusiness IntelligenceData VisualizationDecision ManagementExclusivePredictive AnalyticsStatisticsWeb Analytics

Using TIBCO Spotfire to Analyze Google Analytics Data

gopykryshna
Last updated: 2012/03/29 at 3:02 PM
gopykryshna
5 Min Read
Left Menu in GA
SHARE

Using TIBCO Spotfire to Analyze Google Analytics Data

At one of the websites where I have been tracking traffic for many years using Google Analytics (GA) I wanted to do analysis beyond what GA would allow. I present in this post a way of extracting data out of GA and importing it into an anlysis tool of my choice (TIBCO Spotfire), but I am sure you could use other tools as well like SPSS, SAS, Tableau, Excel etc. This post assumes a level of comfort using GA amongst its readers.

Using TIBCO Spotfire to Analyze Google Analytics Data

At one of the websites where I have been tracking traffic for many years using Google Analytics (GA) I wanted to do analysis beyond what GA would allow. I present in this post a way of extracting data out of GA and importing it into an anlysis tool of my choice (TIBCO Spotfire), but I am sure you could use other tools as well like SPSS, SAS, Tableau, Excel etc. This post assumes a level of comfort using GA amongst its readers.

I chose the old version of GA for the purpose extracting data. I extracted data for four years by

  1. Clicking on Visitors | Overview on the left menu of GA
  2. Changing the date range to (1/1/2008-12/31/2011)
  3. I then clicked on Export and chose “CSV for Excel”. It created a CSV file with a generic name like Analytics_www.yoursite.com_200811-201112_(VisitorsOverviewReport).csv in the browsers default Download directory.

Left Menu in GA

Traffic in Google Analytics

Now that I have the raw data I will move to TIBCO Spotfire. But before I do so I have to clean up and massage the data to make it usable in Spotfire. Clean up  and massaging involved the following steps:

  1. I opened the CSV file in Excel.
  2. Removed the 9 rows at the top and 10 rows at the bottom to be left with
  3. Used an Excel formula to remove day-of-week at the beginning and convert to date by using the formula  =Datevalue(SUBSTITUTE(A13,LEFT(A2, SEARCH(“,”,A2)),””))
 Raw Excel Data from GA

We now have data which should look like:

 
 Cleaned up data in Excel

Now that we have the data ready we open this Excel file in Spotfire.

  1. File | Open | {Your Excel File} | {Correct Worksheet} | 
  2. Ensure that the “Date in GA” is imported as a Date field, and the Visitors as an Integer.

Using the power of Spotfire, very quickly we can get some comparisons, here are a few:

Four years by quarter
 
This indicates that the rate of growth in traffic in Q1 over the foour years has been faster than in the other 3 quarters.

Pie Charts

Spotfire has the ability to generate such charts and also do drill-down with just a few clicks.  The pie-charts above indicate that September is usually the busiest month for the website with 14.3% of the traffic. Most traffic at the site is during the fourth quarter. Finally there has been significant increase in traffic year after year from 2008 at 11.2% to 2011 at 37.6%.

Weekly Traffic

Mondays, Tuesdays and Wednesdays the traffic at the site is at a peak, Saturday being the quietest.

Day of week by week number

Note that by using a Zoomer Slide we have restricted the view to between weeks 20 and 45. We notice that consistently that number of visitors increases during weeks 35 to 37, with a peak on week 37. Several marketing campaigns can be targeted during this period to get the best conversion.
 
All these charts were drawn in TIBCO Spotfire using few clicks and took no more than couple minutes each. This is just the “tip of the iceberg”. We can extract data from Google Analytics under different categories like geography, keywords, browser used, screen resolutions etc. Spotfire can then provide in-depth segmentation and analysis of this data. While GA does provide some capability  for segmentation and analysis, using a specialised tool for statistical analysis like TIBCO Spotfire really makes sense.

I am a regular blogger in this network. You can see some of my other blogs on Social media here:

http://socialmediatoday.com/posts/published/user/117154

 

TAGGED: spotfire visual analysis tool
gopykryshna March 29, 2012 March 29, 2012
Share This Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai can help with nurse burnout
Breakthroughs in AI Are Helping to Prevent Nurse Burnout
Artificial Intelligence Exclusive
AI in marketing
AI Can’t Replace Creativity When Crafting Digital Content
Artificial Intelligence
ai in furniture design
Top 5 AI-Driven Furniture Engineering Design Applications
Artificial Intelligence
data protection regulation
Benefits of Data Management Regulations for Consumers & Businesses
Data Management

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

Stalking the why: selling visual analysis

6 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?