A client came to us looking for an automated solution that would allow them to view refreshed data regularly, without having to spend hours each week updating the reports in Excel themselves, as they had been doing for years.
The reports consisted of three separate Excel files, with data coming in from ten different Google Analytics accounts, which the client was copying and pasting to create the summary reports.
This project required:
- Finding an appropriate reporting tool to visualize the data
- Data automation to regularly refresh the data
- Data blending from ten Google Analytics sources
This solution saved hours of manual report updates every month and provided user-friendly, interactive reports that could be shared around the company with a link or PDF export. Our client was thrilled to get this laborious task off his plate and his colleagues appreciated being able to access the information at any time.