topic Re: Rest Connector and Google Analytics in Connectivity & Data Prep

Rest Connector and Google Analytics

Wed, 27 Jul 2016 19:59:00 GMT

Has anyone had any luck with the Rest Connector and connecting to the Google Analytics. I get the connection made perfectly. The problem is then trying to parse the data in Qlik Sense to make it usuable.

I am using the getdata api

I put in ga:sessions, ga:pageviews as the metric

I put in ga:usertype, ga:year, ga:month, ga:day

Date ranges 2016-06-01 through yesterday.

It creates the string to I can make the connection. I get the Authorization id. No Keys. It connects fine.

The problem is when it comes back it is in an array with one row:

Usertype

Year

Montth

Day

Sessions

Pageviews

I am sure I have to create a pivot table or something but dont know where to begin. Can anyone give me some pointers?

Thanks,
David

Re: Rest Connector and Google Analytics

Anonymous — Wed, 27 Jul 2016 23:05:13 GMT

Hi David,

Have you looked into our QVSource connectors?

They enable very rich Google Analytics queries.

Google Analytics Connector For QlikView & Qlik Sense - QVSource: The QlikView & Qlik Sense API Connector (Docs)

Re: Rest Connector and Google Analytics

Wed, 27 Jul 2016 23:14:46 GMT

‌I have but I thought that Qlik bought them and they are no longer supported or can give you a trial version. Is that not correct.

Re: Rest Connector and Google Analytics

Anonymous — Wed, 27 Jul 2016 23:17:55 GMT

Yes, Qlik has bought QV Source and we directly support the connectors.

I would connect with your Account Manager and ask for a trial.

Re: Rest Connector and Google Analytics

john9inno — Thu, 22 Sep 2016 02:25:59 GMT

please see below link.

that will get you idea where to start.

thanks.

Rest connector to get Google Analytics