Categories
To use Data Visualisation Desktop with data from Google Analytics

Summary
To use Data Visualisation Desktop with data from Google Analytics
Content
I created VA project that referring to the follwoing blog.
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?
Answers
-
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.
0 -
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...
0 -
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.
0