By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    predictive analytics in dropshipping
    Predictive Analytics Helps New Dropshipping Businesses Thrive
    12 Min Read
    data-driven approach in healthcare
    The Importance of Data-Driven Approaches to Improving Healthcare in Rural Areas
    6 Min Read
    analytics for tax compliance
    Analytics Changes the Calculus of Business Tax Compliance
    8 Min Read
    big data analytics in gaming
    The Role of Big Data Analytics in Gaming
    10 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    Promising Benefits of Predictive Analytics in Asset Management
    11 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
Latest News
ai software development
Key Strategies to Develop AI Software Cost-Effectively
Artificial Intelligence
ai in omnichannel marketing
AI is Driving Huge Changes in Omnichannel Marketing
Artificial Intelligence
ai for small business tax planning
Maximize Tax Deductions as a Business Owner with AI
Artificial Intelligence
ai in marketing with 3D rendering
Marketers Use AI to Take Advantage of 3D Rendering
Artificial Intelligence
How Big Data Is Transforming the Maritime Industry
How Big Data Is Transforming the Maritime Industry
Big Data
Aa
SmartData Collective
Aa
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.

More Read

Stalking the why: selling visual analysis

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
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai software development
Key Strategies to Develop AI Software Cost-Effectively
Artificial Intelligence
ai in omnichannel marketing
AI is Driving Huge Changes in Omnichannel Marketing
Artificial Intelligence
ai for small business tax planning
Maximize Tax Deductions as a Business Owner with AI
Artificial Intelligence
ai in marketing with 3D rendering
Marketers Use AI to Take Advantage of 3D Rendering
Artificial Intelligence

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 in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?