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:
Account (by default we'll pull from all accounts)
Property (by default we'll pull from all properties)
Profile (by default we'll pull from all profiles)
Metrics (up to 10)
Dimensions (up to 7 including Date, which is mandatory since we use it to pull the latest data)
Segment (Optional - leave blank to pull All Sessions)
Filters (Optional - syntax following Google's filter documentation)
Sort (Optional - syntax following Google's sort documentation)
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.