Access Keys:
Skip to content (Access Key - 0)

Sample Instaview template for use with Google Analytics that can be easily added to your installation. It demonstrates how to integrate data from internal marketing sources with Google Analytics web traffic data.

Prerequisites

In order to follow along with this how-to guide you will need a desktop installation of Pentaho Data Integration with Instaview.
Download Instaview

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.

If you have signed up and already have an API key but don't remember what it is, go here and select "API Access". You will need to be signed into your Google account.

Data Files

You will also need the sample Market Spend spreadsheet available here. Save it to your instaview template Samples/data folder. Navigate to the install directory where Pentaho Data Integration (Instaview) is installed. From there, navigate to:

plugins/spoon/agile-bi/platform/pentaho-solutions/system/instaview/templates/Samples/data

Add the Google Analytics Market Spend sample template to your copy of Instaview

Now that there is data in the right place, all you need to do is drop the Template into the correct folder.

  1. Get the Template: Click here to download the Template and save it to your Instaview template Samples folder. Navigate to the install directory where Pentaho Data Integration is installed. From there, navigate to:
    plugins/spoon/agile-bi/platform/pentaho-solutions/system/instaview/templates/Samples
  2. Get the Icon: Click here to download the Icon and save in the same folder as the template from the previous step.

Try the sample

  1. Switch to Instaview: Start up Pentaho Data Integration (you do not need to restart) and select the "Instaview" perspective.
  2. From the Instaview Welcome Screen:
  3. Click: "Create New"
  4. Click: "Samples"
  5. Select: "Google Analytics MrkSpend"
  6. 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.
  • 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

This documentation is maintained by the Pentaho community, and members are encouraged to create new pages in the appropriate spaces, or edit existing pages that need to be corrected or updated.

Please do not leave comments on Wiki pages asking for help. They will be deleted. Use the forums instead.

Adaptavist Theme Builder (4.2.0) Powered by Atlassian Confluence 3.3.3, the Enterprise Wiki