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

April 28, 2017

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).

c 01 create new connection

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!

c 02 qlik web connectors

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!

c 025 request access

Next step - authenticate with your Google account!

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

c 03 google account access api

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.

c 04 authentication code

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!

c 05 connected

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).

c 06 new connection available

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.

c 07 connection tables

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.


Profile picture

From Dave, who writes to learn things. Thoughts and views are his own.

© 2024, withdave.