QlikView and Google Analytics – Getting Started
as I got the challenge to integrate Google Analytics into our company warehouse with QlikView I will write a series of hopefully more or less usefull articles on how to fetch the data needed.
For accessing the Google Analytics API (v3) you have two possibilities:
- You are a technic geek and you know how to use REST-Services and OPENAUTH
- You use the ready to use and well tested tool QVSource – www.qvsource.com
As we had some time pressure for the analysis and I didn’t wanna write the “fetcher” by myself. We decided to order and use the QVSource solution.
Where to start?
Facing the “KPI-Definition List” from our marketing department and looking inside the google analytics dev documentation I realized that this will be a time consuming and knowledge building task;)
After digging into more and more details (help from dev friends) I ended up on this fancy little tool:
How to configure this tool is as simple as login into the tool with your oauth google credentlials (your normal google account). Then you can select the google analytics profile and the site you wanna query on.
To get started, I build a simple request structure where I ask for the dimension:
- ga:date (YYYYMMDD)
Can be selected as followed:
And the following metrics:
- ga:users (former visitors)
- ga:sessions (former visits)
If you have the feeling of getting lost within dimensions and metrics (measures) within the google analytics datamodel – I did so too – took me about 2 days to understand what’s going on (birdseye)…
The really cool part now is, that by clicking on the following symbol:
After you clicked this you can use the generated code to fetch the first records from google!
I made a quick an dirty line/bar chart to display the so fetched metrics:
Check out my next posts, to see and learn more! Philipp;)