Welcome Guest, you are in: Login

QVSource: The QlikView & Qlik Sense API Connector (Docs)


This application provides a simple way for you to get Google Analytics data into QlikView, so that you can make comparisons between websites and get a deeper understanding of your web presence.

It uses the Google Analytics Connector (v2).

You can view it online here.

NOTE: There is a more basic demo application for Google Analytics here.

Download

IMPORTANT: You should use QVSource 1.4.5 or later to use this application.

The latest version of this demo application can be downloaded from here:
QVSource Google Analytics Demo - Load Script & Data Model v1.0.0.2.zip


We are starting to move our QlikView applications over to GitHub.

To understand why we are doing this and what it means to you, we have written this page.

You can download the latest Zip file here or you can visit the QVSource repository on GitHub here where you can track changes and download it.

Please review the 'Notes' tab in the application's load script to see the change log for the current version along with a To Do list.

Usage

The demo download should comprise of a QVW and a TXT file as shown below

Image

You can use the config file to easily customise some aspects of the demo application for your own needs. Please ensure that the config file sits next to the QlikView application.

PLEASE NOTE: You need to populate the GoogleAnalyticsProfiles table with your own profile ids before you run this application, see below for details of how to do this


/*
Edit the following table so that the left column contains the 
Google Analytics ID and the right column contains a friendly name
for each of the sites you want to get data for.
You can find the ID by going to the Google Analytic connector in QVSource and
looking at the WebProfiles table.
*/
GoogleAnalyticsProfiles:
LOAD * INLINE [
    ga_id, WebsiteProfile
    01234567, yourwebsite1
    34567890, yourwebsite2
    98765432, yourwebsite3
];

/*
This is the date to get the data from and is used the first time the 
application is reloaded (specified as the number of days back from today).
*/
let vTemp = Date(timestamp(now(1)) - 30);
let vDateToGetDataFromOnFirstReload= date(vTemp, 'YYYY-MM-DD');

Getting Set Up

As mentioned above, before you reload the application for the first time you need to populate the GoogleAnalyticsProfile table in the config text file. Go to QVSource, open the Google Analytics V2 connector and authenticate as described here.

Next go to the 'Connector Data' tab and select the 'WebProfiles' table.

Image

Next, identify the websites that you want to get data for and copy the 'id' value into the 'ga_id' field of the GoogleAnalyticProfiles table that is in the config text file. You can also enter the 'name' value into the 'WebsiteProfile' field, or you can give it a friendly name. You can enter as many profiles as you want.

Set the vDateToGetDataFromOnFirstReload's date to be the day before the date that you want to get data. So, if you want to get data from the 1st July 2012, you need to enter '2012-06-30'.

Loading

Once you've set up the config file and saved it, you should be able to reload the application for your data (don't forget that QVSource must be running).

A QVD is created for location data as well as a QVD for each profile that you get data for. These are saved along side the demo application.

PLEASE NOTE:
  • Each time the application reloads it will get data from this date to yesterday - we hope to improve this limitation in a future version.
  • Further, the application also currently loops through and does a separate load statement for each individual day in the range. If the load is taking a long time you should consider reworking the script to load in larger date ranges in each load statement, possibly the entire date range you are interested in.


Screenshots

Image

Image

Schema

Image

Change Log

Please see the change log section in the 'Notes' tab of the application's load script.


(QVSource works with Qlik Sense as well as QlikView - See this page for notes.)
QVSource - The QlikView & Qlik Sense API Connector | © Copyright 2011 - 2016 Industrial CodeBox Ltd