Connecting to Google Analytics in Qlik Cloud (Qlik Sense) through the Qlik Web Connectors package

This post looks at using Qlik Cloud (using a paid-for tier) to gather and analyse data from Google Analytics.

Qlik Cloud doesn’t allow user-added extensions, connectors or alterations (unlike the Qlik Sense Desktop and Enterprise products), but is free at the basic tier where you can load from uploaded files. As mentioned, I am using a “Plus” account which gives me access to more connectors.

With my account, there are a couple of built-in connectors available on Qlik Cloud if you don’t want to manage your data yourself. The one I’m using today is the “Google Analytics (BETA)” connector – obviously if you’re using Qlik Sense Desktop, QlikView or Qlik Sense Enterprise you’ll have to make a choice (more on that at the end).

 

We have three connection options, aside from the folder option (which is already setup)

 

Go to the data load editor (or add data) and use the “Qlik Web Connectors” option – this provides a growing list of connectors, more are promised over time. Note that this covers the two most popular social media platforms…and Google Analytics!

 

Qlik Web Connectors has three options on my subscription level, at the time of writing

 

Jumping into the “Google Analytics (Beta)” option, the page updates to give you a single option – which is API access to your signed in Google account. No setting up access or setup of keys from within your Google account required!

 

Next step – authenticate with your Google account!

 

This opens the Google login or access page and details what Qlik needs to connect.

 

Authentication access

 

At this point, things are a little less seamless. It takes you back to a Qlik site (the connectors site) and provides you with a Qlik-side authentication code. We’ll have to copy this and paste it into the connector for now – perhaps this will be simplified in the future.

 

Copy the authentication code from the Qlik site into the connector on Qlik Cloud

 

Hit authenticate and it should pull your account information (removed from mine below, sorry). Test the connection and you’re good to go!

 

Connected – test to confirm, and you’re good to go

 

The new connection is available from the Data Connections panel. This appears to be per-app at the moment (rather than shared across your account and all your apps).

 

A new connection is available…

 

And we’re connected! Google has a brilliant set of APIs and developer resources, which mean you have a lot of control about how you pull the data. Have a look at the Dimensions and Measures documentation for a glimpse at what you can pull down.

 

We’re connected – you have five “tables” to start

 

You’ll find that in the Qlik data load process you are presented with five “tables” – these are not typical database tables but rather five ways of accessing the data in Google Analytics:

  • Accounts – lists the Google Analytics accounts that your Google account has access to (accounts contain multiple profiles)
  • DataFromQueryURI – allows you to enter a query string directly, once you’ve built it on the Query Explorer
  • DataFromTemplateQuery – gives you access to some pre-built top queries (such as “Visitors and Pageviews over time”, and “Visits by Country”)
  • WebProfiles – this returns profiles, which sit under properties
  • WebProperties – this returns information about your individual websites, applications or devices

You can also use the Query Explorer Tool to help you piece together what you need, it’s quicker than doing it in Qlik Sense directly if you’re new to the Google Analytics platform as it has syntax helpers throughout the tool. You can then copy the parameters back into Qlik Sense to actually load the data.

One other thing to note – Qlik Sense Desktop and Enterprise don’t have this connected included by default, although they do have the Qlik REST connector if you want to piece together API calls yourself. The Google Analytics connector is a paid-for product on these platforms via the Qlik Web Connectors package.

I’ll pull some data and have a look in a later post.

3 Replies to “Connecting to Google Analytics in Qlik Cloud (Qlik Sense) through the Qlik Web Connectors package”

  1. Dave,

    Thanks for the post. It’s very helpful. I’m implementing something of the sorts for the first time and I have few questions.

    Here is the flowchart for getting Google Analytics data from Qlik Sense Server (Not cloud), as I understand it:

    1. Link your corporate account to a gmail account

    2. Allow the connector to authenticate the email once (this’ll give us a piece of script which has to be later pasted and authenticated)

    3. Go to Google Query and get the URI.

    4. Paste the URI link in the Web file connection option and then.. voila..

    5. You have data displayed and you hit ‘Load Data’

    Please let me know, if I’m missing anything in these steps.

    1. @Goutham – Yep, pretty much.

      Presumably if you have a corporate account to login to Google Analytics then you could use that to generate the authentication code, unless you’d prefer to limit account access. In that case, using a separate personal account only on the property you want to pull data from would work.

Leave a Reply

Your email address will not be published. Required fields are marked *