Page Comparison

{excerpt}Sample Blend template for use with Google Analytics{excerpt} that can be easily added to your installation.  It demonstrates how to blend data from a sample customer support system with Google Analytics web traffic data.

{youtube}W_fsCuuIkJk{youtube}

h1. Prerequisites

In order to follow along with this how-to guide you will need a desktop installation of Pentaho Business Analytics.
[Download Pentaho|http://www.pentaho.com/download]

h2. Google Analytics account

You must have a Google Analytics account and API key in order to access your website data.  If you are new to Google Analytics, there is more information [here|http://www.google.com/analytics].

If you have signed up and already have an API key but don't remember what it is, go [here|https://code.google.com/apis/console] and select "API Access". You will need to be signed into your Google account.

h2. Data Files

You will also need the sample Customer Support spreadsheet available [here|Google Analytics Customer Service Blend^CustSupportData_GADemo.xls].   Save it to your data folder.  Navigate to the install directory where Pentaho Data Integration is installed.  From there, navigate to:
{code}/pentaho-solutions{code}

h2. Add the Google Analytics Blend sample template to your copy of Pentaho Data Integration

Now that there is data in the right place, all you need to do is drop the Template into the correct folder.
# *Get the Template*: Click [here|Google Analytics Customer Service Blend^GoogleAnalyticsBrowserBlend.ktr] to download the Template and save it to your PDI folder.  Navigate to the install directory where Pentaho Data Integration is installed.  From there, navigate to:
{code}plugins/spoon/agile-bi/platform/pentaho-solutions/system/instaview/templates/Samples{code}

h2. Configure JDBC Driver: 

Follow the directions to configure the Thin Kettle JDBC Driverdriver: http://wiki.pentaho.com/display/EAI/Configuration+of+the+Thin+Kettle+JDBC+driver

h2. Try the sample

# *Start*: Start up Pentaho Data Integration (you do *not* need to restart) Business Analytics and open the "GoogleAnalyticsBrowserBlend.ktr" template.
!Instaview^InstaviewPerspective.png|border=1!
# From the GoogleAnalyticsBrowserBlend transformation:
# Click: "Create New"
# Click: "Samples"
# Select: "Google Analytics MrkSpendInput"
# A dialog box will appear. Enter your connection details for Google Analytics and a date range as shown in the image.
_Click to enlarge image._
!GaDialog.png|thumbnail,border=1!
 step
# 

* Enter a Google email, password and API key tied to your Google Analytics account as described above.
* Press the "Get Profiles" button to fill the drop down list with your web site information
* Select the website to profile from the "Get tableId from profile" dropdown
* Enter a start and end date
* You should use the "Preview" button on the bottom of the dialog to ensure your selections are correct.
* Press "OK" when done

# Open a browser and open the Pentaho User Console.
# Select Manage Data Sources
# Create a data source using the data service from the GoogleAnalyticsBrowserBlend transformation.