The Google Analytics connector comes with two procedures for generating reports:
- get: Uses the Reporting API v3
- getV4: Uses the Reporting API v4
Both procedures and APIs are largely compatible with each other, but switching from v3 to v4 still requires a few changes.
This is an example call using the get procedure and therefore API v3:
SELECT PARSEDATE(a.date, 'yyyyMMdd') AS "date", CAST(a.users AS integer) AS users, CAST(a.newUsers AS integer) AS newUsers, CAST(a.percentNewSessions AS float) AS percentNewSessionsFROM ( EXEC google_analytics_src.get( profile => 68903984, startDate => '2017-04-01', endDate => '2017-04-02', metrics => 'users,newUsers,percentNewSessions', dimensions => 'date', samplingLevel => 'Higher_Precision', sort => 'users' )) a
Switching this query to API v4 involves:
- Changing the procedure from "get" to "getV4"
- Renaming the "profile" parameter to "viewId"
- If you use the "samplingLevel" parameter, the values have changed. Please see Google's migration guide for a mapping of old to new values.
After those changes, the call to v4 looks like this:
SELECT PARSEDATE(a.date, 'yyyyMMdd') AS "date", CAST(a.users AS integer) AS users, CAST(a.newUsers AS integer) AS newUsers, CAST(a.percentNewSessions AS float) AS percentNewSessionsFROM ( EXEC google_analytics_src.getV4( viewId => 68903984, startDate => '2017-04-01', endDate => '2017-04-02', metrics => 'users,newUsers,percentNewSessions', dimensions => 'date', samplingLevel => 'LARGE', sort => 'users' )) a
