Connecting Google Analytics
bipp brings the power of your Google Analytics into your bipp project.
Create a Google Sheets Datasource in bipp
-
Select Datasources from the Home Navigation pane to open the Datasources page.
-
Click New Datasource on the Datasources page.
-
Enter a Name. For example, TestGoogleSheets.
-
Select GoogleAnalytics for SQL Dialect for your database. bipp creates and enforces the rules for the selected dialect.
-
Enter the information for your Google Analytics file:
- View_id: the Google View ID is located on the Analytics Admin tab. In the View column, select View Settings.
- Start_date: the starting date to import.
- End_date: an optional ending date. If not specified, the current date is used.
- Credentials: click Choose File and navigate to the credentials file for Google Analytics. The credentials file must be set up through the Google API. Refer to Google Analytics Reporting API - Authorization.
-
Click Create to add the datasource.
Congratulations! You have successfully created a Google Sheets datasource in bipp.
IN THIS PAGE
Sign up for a forever free account!
Connect to leading SQL databases
Build visual data models without learning a new language
Create two dashboards and ten reports for free