To use Data Visualisation Desktop with data from Google Analytics

Question

Summary

Content

I created VA project that referring to the follwoing blog.

https://www.rittmanmead.com/blog/2016/11/connecting-oracle-data-visualization-desktop-to-google-analytics-and-google-dri…

Connecting Oracle Data Visualization Desktop to Google Analytics and Google Drive

Get data from Google Analytics in Oracle Data Visualization Desktop,

I want to create the graph in time series.

The connection was successful, I can get GA data.

but I cannot add the Time dimension.

Does anyone know how to do it?

Masu09-Oracle · Answer

Even if I could get report data from Google Analytics,

It should be meaningless unless we can add the Time dimension and perform time series analysis.

Syedsalmancs110 · Answer

Do you already have Time Dimension created in some other datasource? where are you tying to add time dimension and from where?

Because its obvious you won't have same in non-modelled data source.

But if you have Time Dimension present in some other datasource then you can join your Google Analytics data source data with same,given that you have date columns to join with time dimension table, see below documents which explains how to connect two different data sources.

https://docs.oracle.com/en/middleware/bi/data-visualization-desktop/bidvd/creating-project-and-choosing-data-sources.htm…

https://docs.oracle.com/en/middleware/bi/data-visualization-desktop/bidvd/blending-data-that-you-added.html

Masu09-Oracle · Answer

Thank you for your reply.

I want to add following Time dimension.

https://developers.google.com/analytics/devguides/reporting/core/dimsmets#view=detail&group=time

Time - Dimensions

ga:date

For example, Let's assume I create new datasource and add following Session metrics to Project.

https://developers.google.com/analytics/devguides/reporting/core/dimsmets#view=detail&group=session

Session - Dimensions & Metrics Explorer

If I want to add a second datasource (Time Dimension) to this project, What should I do?

GA Session metrics doesn't have Time Dimension...