Specifying Google Analytics Custom Tables in a JSON File

In Oracle Analytics, you can specify custom tables to analyze historical web-usage data from Google Analytics and generate reports that are similar to Google Analytics reports. For example, you might analyze the number of hits to landing pages over time.

This example Oracle Analytics report visualizes the number of hits to website landing pages over time.

Description of the illustration google-analytics-report.png

Before you connect to Google Analytics, you need a JSON file that specifies the Google Analytics historical tables to analyze. You can obtain a ready-made JSON file from the Google Analytics V4 website, in the Dimensions & Metrics Explorer area under Demos & Tools.

Example JSON File With Historical Tables for Website Landing Pages

{"LandingPage":["_landingPage", "_dateHourMinute", "averageSessionDuration", "keyEvents", "newUsers", "sessions", "totalRevenue", "totalUsers"]}

Changing the Default Date Range

By default, data from the last 30 days is retrieved for analysis. Append a dateRanges tag to specify a different time range. For example, to retrieve data from the last 100 days specify "dateRanges":[{ "startDate":"100daysAgo", "endDate":"today"}

{"User":["_audienceName", "_deviceCategory", "_yearMonth", "_country", "_userAgeBracket", "firstTimePurchaserRate", "activeUsers", "active1DayUsers", "active28DayUsers", "active7DayUsers", "engagedSessions"],
"dateRanges":[{ "startDate":"100daysAgo", "endDate":"today"}]}

Locating Custom Tables When You Create a Dataset

When you create a connection to Google Analytics, use the Import File option under Add Custom Tables to specify the Google Analytics historical tables to analyze.

When you create a dataset based on a Google Analytics connection created with historical tables, navigate to the GOOGLEANALYTICSV4 schema.

Description of the illustration google-analytics-schemas.png

Then scroll down to locate the historical tables.

Description of the illustration google-analytics-custom-tables.png