topic rest connector in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/rest-connector/m-p/1070553#M1659 <HTML><HEAD></HEAD><BODY><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">We tried to load Google Analytics data using metrics and dimensions in QlikSense but I think we have missed something. </SPAN></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">We were based on the following video: <A href="https://www.youtube.com/watch?v=QJpwJLSEpaU" style="color: #1155cc;" target="_blank">https://www.youtube.com/watch?v=QJpwJLSEpaU</A></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">that shows how to access to Google Analytics Metrics using the REST connector</P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">Attached, you will find a description of the steps in QlikSense and Google Analytics for Developers. The expected result is a table with, for each value of Dimension in a column, we should have its metric value in an other column. The fact is : the dimensions values (browsers) and the metrics (sessions) are in the same field @Value_u0. How can we get the dimension value in one column and the metrics values in another column ?</P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">Thanks for replying</P></BODY></HTML> Mon, 14 Mar 2016 17:47:50 GMT 2016-03-14T17:47:50Z rest connector https://community.qlik.com/t5/Connectivity-Data-Prep/rest-connector/m-p/1070553#M1659 <HTML><HEAD></HEAD><BODY><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">We tried to load Google Analytics data using metrics and dimensions in QlikSense but I think we have missed something. </SPAN></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">We were based on the following video: <A href="https://www.youtube.com/watch?v=QJpwJLSEpaU" style="color: #1155cc;" target="_blank">https://www.youtube.com/watch?v=QJpwJLSEpaU</A></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">that shows how to access to Google Analytics Metrics using the REST connector</P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">Attached, you will find a description of the steps in QlikSense and Google Analytics for Developers. The expected result is a table with, for each value of Dimension in a column, we should have its metric value in an other column. The fact is : the dimensions values (browsers) and the metrics (sessions) are in the same field @Value_u0. How can we get the dimension value in one column and the metrics values in another column ?</P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">Thanks for replying</P></BODY></HTML> Mon, 14 Mar 2016 17:47:50 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/rest-connector/m-p/1070553#M1659 2016-03-14T17:47:50Z