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 percentNewSessions
FROM (
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 percentNewSessions
FROM (
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
Comments
0 comments
Please sign in to leave a comment.