Alooma can read and replicate all of the Google Analytics report data from your Google Analytics account. This allows you to merge customer usage data with the other data in your data warehouse.
Alooma provides a way for you to pull your Google Analytics data using Google's Core Reporting API. Alooma pulls the Analytics data daily at 5am PST, and each report row is streamed as an event.
We recommend experimenting with the structure and contents of the resulting table by playing with the Google Query Explorer before creating the input. Note that we are subject to the Core Reporting API limits and quotas, and will emit notifications in the dashboard if we don't pull data or pull sampled data due to these limits.
You can connect Google Analytics to Alooma in just a few steps:
Add your Analytics input from Alooma's plumbing screen
Sign in with the account associated with Google Analytics
Supply the following information:
Name - We’ll use the input name in the UI and to name the events that come from this input. Note that after creation, input name can’t be changed.
Account - By default we’ll bring all data from all accounts and properties (including if more are added later on), but feel free to choose a subset.
Property - By default we’ll bring all data from all accounts and properties (including if more are added later on), but feel free to choose a subset.
Profile - View. By default we’ll bring all data from all profiles and segments (including if more are added later on).
Segment - (Optional) To limit segments, use Google's segment syntax.
Metrics - Google's API supports up to 10 metrics.
Dimensions - Google's API supports up to 7 dimensions. One must be Date, as we use it to pull the latest data.
Filters - (Optional) Use filters to limit results. See Google's filter documentation for the syntax.
Sort - (Optional) Sort results. See Google's sort documentation for the syntax.
Under Advanced Settings, choose whether you'd like to import historical events (if not, it will pull data from the last 2 days).
Choose whether you'd like a stopping point for the input.
Keep the mapping mode to the default of OneClick if you'd like Alooma to automatically map the Google Analytics events directly to your target data warehouse. Otherwise, they'll have to be mapped manually from the Mapper screen.
That's it! You're ready to pull your Google Analytics data into your target data warehouse with Alooma.