route1io_connectors.google.google_analytics module

Google Sheets connectors

This module contains functions for interacting with Google Analytics reporting

connect_to_google_analytics(credentials: google.oauth2.credentials.Credentials) → googleapiclient.discovery.Resource

Return a connection to Google Drive

Parameters

credentials (google.oath2.credentials.Credentials) – Valid Credentials object with necessary authentication

Returns

google_drive_conn – Connection to Google Drive API

Return type

googleapiclient.discovery.Resource

get_google_analytics_data(analytics, view_id: str, dimensions: Optional[List[str]] = None, metrics: Optional[List[str]] = None, start_date: str = '7daysAgo', end_date: str = 'today') → pandas.core.frame.DataFrame

Return a pd.DataFrame of Google Analytics data between the requested dates for the specified view ID

Parameters

• view_id (str) – View ID that we want to view

• dimensions (List[str]) – List of dimensions https://ga-dev-tools.web.app/dimensions-metrics-explorer/

• metrics (List[str]) – List of metrics https://ga-dev-tools.web.app/dimensions-metrics-explorer/

• start_date (str) – Dynamic preset such as 7daysago or YYYY-MM-DD

• end_date (str) – Dynamic preset such as today or YYYY-MM-DD

Returns

df

Return type

pd.DataFrame