Kloudio's Google Analytics integration allows users to easily create reports from Google Analytics file data also user can run the same reports in Google Sheets and Excel Addon.
The following article will help you get started:
Step 1 : Go to Kloudio Connections and Click the button to create a New Connection.
Step 2: Now click on Google Analytics Setup Button
Step 3: Then Login with you Google Account which is associated with Google Analytics and click on Allow Button
Step 4 : Now it's time to setup your Google Analytics data sync settings.
This will enable you to sync your Google Analytics data to a database of your choice.
Kloudio will do this on your behalf by invoking Google Analytics APIs as per your configured sync frequency.
The following are the steps to configure Data Warehouse Settings and Data Options:
a. Connection name
b. Choose an Existing database connection: This is where Kloudio will sync your Google Analytics data. Once it's synced, it will be available for creating Kloudio reports in builder or SQL mode.
c. Choose a Schema name where you'd like your data to be synced
d. You can also optionally use Kloudio's Data Warehouse in case you don't have any data warehouse to sync your data to and then select the required Data Options.
Step 5 : Now select the required details like Metrics, Dimensions, Sync Start Date, Sync End Date and Click on Add Table
Step 6 : Then follow the below steps:
a. Select the Table you want to sync
b. Configure the Sync Schedule by selecting the Frequency and respective Interval
c. Enter the email for the notifications under 'Notifications'.
d. Now Click on "Save & Sync" button
Step 7 : Now the sync should start running and you will get a confirmation "Sync Job run successful" once it is successfully completed running the sync job
Step 8 : Once the Google Analytics connection is created successfully, you will able to create Reports using that Connection.
Now select the Reports and Create a New Report with the Report Builder
Step 9 : Finally Select the above created connection, table, columns and Click on Test Button to get the Data Preview of the Reports. Then Enter the report name and click on Save button to save the reports.
Feel free to chat with us or drop an email in case you have any questions related to this integration.