We advise and consult

SearchStar

Bespoke reporting system

Introduction

SearchStar, established in 2005 by Dan Fallon, is an online marketing agency, specialising in search engine marketing. SearchStar undertakes the entire process involved in search engine marketing, from strategy and objective setting through to ongoing monitoring of and optimisation of the campaigns. An integral part of their service is full monitoring and reporting on the results of their advice.

The reporting service is critical to optimisation and since information has to be analysed from multiple sources, it can be a lengthy process, with much manual intervention.

The challenge

SearchStar produces weekly and monthly reports for approximately 30 SearchStar clients. Each client typically receives 3-4 reports showing different levels of detail for their Google, MSN or Yahoo Pay-Per-Click (PPC) campaigns. To do this data was manually copied from the downloaded reports and entered into spreadsheets which were formatted and emailed to clients. This process used to take two days to complete, which meant that speed of campaign optimisation was compromised.

The solution

Aszent designed and built a simple Excel based solution to accelerate and automate the reporting process. We analysed the existing workflow, the input data and output requirements to ensure that no part of the process was overlooked or omitted. At the heart of the solution is a common results database; this is the reporting engine from which the automated reports are derived and created.

The benefits

SearchStar can now produce accurate reports in one hour, not two days, saving a total of 108 man-days of effort per annum.

Contact

Dan Fallon, SearchStar

We want to say a huge THANK YOU for all your work on our Supporter Survey…we have learned a lot about our Supporters and have already been able to make better informed decisions based on the results.— Clare Walsh, Fundraising manager, Send a Cow