Download data from Google Analytics to local storage to avoid #BigData Problems
For many web sites, Google Analytics will send sampled data (also known as Fast Access Mode). The problem is that, when sampled data is present, the numbers are wrong, making them useless for many types of business decisions.
- Some software solutions, including NEXT Analytics, can automatically break up a date range down to day by day queries, which often avoids sampling. The approach mitigates the problem but has weaknesses because it still downloads a large date range of data on each refresh, even though the only data which changes was likely yesterday’s. This can be time consuming and resource intensive. Some companies report that the numbers change, too.
NEXT allows you to save each day’s data locally, which is usually a small and fast download. With local data, you use query tools for reporting and dashboards.
Key benefits of Local Storage
Your reports and dashboards are based on a local copy of the data.
- local data access is much much faster than downloading,
- especially if it is processed before storing
- avoids redundant downloads, and
- you have complete control over the data.
You get more options for distributing reports,
- any query, reporting, dashboard, or visualization software
- Google Docs, Spreadsheets, and Visualization can be used as part of your solution
- Office 365 can be part of your solution
- And of course, you can distribute Excel files by automated email.
Benefit from much broader reach into the organization
- Mobile apps can be developed that query databases; or
- Many kinds of software can query databases and present the results
How it Works
NEXT Analytics issue queries and saves the data, each day.
- Database table (MySQL, SQL Server, ODBC)
- Azure Database
- Google Spreadsheets
- CSV file
Having stored the data locally, you now have a wealth of options for creating dashboards and reports.
- Any Business Intelligence product
- Excel (Desktop)
- Office 365
- Google Site and Google Visualization
- Avoid re-work. If your business grows, you might start to experience data sampling. This approach would minimize the impact of that.
- better responsiveness (databases are faster than downloads),
- increased independence (you aren’t dependent on outside data stores), and
- complete control (you administer who can use the data through database and platform security).
- Broad range of expertise. Anyone knowledgeable in Business Intelligence products can prepare reports and dashboards.
- Increase reach of data. Business Intelligence platforms are very good at distribution of reports and dashboards, and they support a broad range of hardware and operating systems.