We design and build

Marketing databases
Single customer view
Prospect pools
Data analysis
Reporting automation tools

We support and maintain

Database hosting
Database maintainence
Campaign planning
Data processing
Business intelligence reporting

We advise and consult

Project management
Data sourcing
Data product feasibility
Loyalty/CRM strategy and implementation
Supplier evaluation
Data planning



Approved Apteco FastStats Partner since 2007

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

OH MY GOD! This is so fantastic. Thank you so much for all your work on this. Life will be so much easier now. Very excited… — Rachel Hirons, Insight Analyst, Global Radio


Call Aszent on 07887 653595