Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

skoppe
Not applicable

QlikView Google Analytics

Hi all,

I've managed to get Google Analytics data through REST connector, thanks to great hints in discussions Google analytics - authorization and pagination and REST CONNECTOR locate the Authorization token‌.

However, I found out that the data is not matching the Google Analytics web dashboard. For example metric users. When I get the data for 30 separate days into QlikView the total user count is exactly the same for each day in the web dashboard, however when I select a full month in the web dashboard the numbers are different in QlikView.

Same applies for metrics: bounceRate and newUsers.

Anyone has any experience with this? Managed to get the same results out of QlikView that are shown on the web dashboard?

Do you guys extract per day (like me) or use different periods? Other tips and tricks?

Thanks in advance!

Regards Stefan

1 Reply
raoballakur
Not applicable

Re: QlikView Google Analytics

Hi Stefan,

                 One of the reason's this might be happening is due to google api returning sampled data. You will have to set samplingLevel: 'HIGHER_PRECISION' when sending the request to google api along with the id and start date/end date & dimensions+metrics.

Regards,

Karthik