www.enhencer.com
Turn Data to Profit in Minutes
Predict customer's behavior with the most practical Automated Machine Learning platform.

www.enhencer.com/churn-prediction
Churn Prediction
Focus only on 5% of your customers who are 90% likely to leave.Know who they are and how they behave.Take the right actions to the right customers at the right time by decreasing your marketing costs.

www.enhencer.com/purchase-propensity
Predict Purchase Propensity
Increase the positive return of such campaigns up to 90% and learn why and how the marketing campaigns are made effective against which customer group.

Tuesday, September 2, 2014

Analyzing Google Analytics data in Tableau

Google Analytics is the  most widely used website statistics service. It provides a great online platform to analyze your web site traffic. Although it provides powerful charts, reports and dashboards to analyze data, if you have needed to use it professionally, you hit its limitations frequently and do the following : Export the Google Analytics data to Excel and try to analyze it there. This manual and tedious process is always needed if you are trying to merge Google Analytics data and some other data in your analysis.

We know that Tableau provides a great data visualization tool and we could leverage its power to analyze Google Analytics data. But to bring the data into Tableau was tedious; you should export it first (to Excel manually or by using Google Analytics API and lots of scripting). Not anymore! With Tableau version 8 onwards, Tableau Software has released Google Analytics connector which makes it quite easy to pull in your Google Analytics data into Tableau. This does not only allow you to create incredibly interactive dashboards to analyze GA data but also allows you to integrate Google Analytics data with some other offline and online data to add great value to your web site analytics effort.

In this short video below, Ellie Fields from Tableau Software, demonstrates how powerful and interactive analytics opportunities Tableau brings to web traffic analysis. In the 3 minutes win Google Analytics challenge, she brings it some data from Google Analytics using the connector and then merges it with some offline data to create an interactive Tableau dashboard.

If you want to try it on your own, you can download Tableau here.

Tableau Google Analytics Connector makes it very easy to create web site traffic analysis dashboard

Tableau can import a Google Analytics extract into the Tableau fast in-memory data engine. This allows you to explore your web data at the speed of thought by easy drag & drop. You can Tableau Server and Tableau Online to build and store multiple small extracts of un-aggregated data. By reusing extracts you don’t have to pull every time from the Google Analytics interface and hit the 500,000 limit per individual per call. Start with a fixed date range and schedule automatic updates.

You can enhance the web-analytics data by Salesforce.com, spreadsheets, databases, cubes, Hadoop, or more. Then you can easily publish securely for your department or entire organization to use. Set permissions for dashboard, workbook, and data-source access by role and group or for individual named users.
Posted by at
Labels: , , , ,

1 comment:

  1. James ZicrovJuly 8, 2021 at 2:56 AM

    Good to see that such conferences are being carried out for the promotion of Tableau and hence I think this is something very useful.

    Tableau Rest Api Connection

    ReplyDelete

Subscribe to: Post Comments (Atom)