20 Years. An agency systems perspective.

Chris Lever, Founder, Agency DNA

My first UK marcoms role was in 1995 as agency FD of Bernard Hodes, an Omnicom/DAS group company. Obliged to conform to the rigour by which DAS managed its portfolio and deliver rapid improvement in their two key pertinent drivers, profit margin and the working capital ratio, I was aghast at the way DDS, the group imposed agency media booking/billing, job management and accounting system, made getting these metrics a major exercise. A single minded Kiwi Financial Controller who I’d hired to assist me had words I couldn’t even begin to pronounce for a system which offered not only opportunity for one-sided entry, but produced a balance sheet by downloading disparate ledgers and combining them in Excel.

chris.jpg

Fast forward 20 years, DDS rebranded as Media Ocean, rebuilt its database, and yet seems it still can’t handle supplier invoices with more than six characters, or allow a major network create a new field to hold the PO references of Google and Facebook, who quite rightly have their own booking systems. If a network with two billion pounds passing through its pay-as-you-go ledgers doesn’t get what it wants, what hope might a smaller agency have? Excel is a strong supplement.

Step back fifteen years and I’m on a team with other senior players from BMB&B, Leo Burnett and  BBH collectively giving up weeks of our lives to work with Maconomy, guiding them on the development of their agency solution on top of what was admittedly a complex, yet robust financial system.

Youthful and optimistic this was heralding a golden age where a Scandinavian vendor understood that agency complexity is a state of mind, we then waited for the release of a system that would look as good as the Power-Point slides suggested, give clear and instant visibility over the inner workings of our agencies, enhance our staff’s lives and make the coffee. Strange I have since felt a strong compulsion to apologise to the many Maconomy users who in those early days found themselves short of utopia. It was more like the Underworld.

Talking it through afterwards with Morton, the Danish Senior Developer, trying to understand what happened between stating our reasonable requirements and the end product, it seems back in Copenhagen they re-thought our needs, and built as only they knew how. Something got lost in translation.

Undaunted, this was the start of the new millennium and things would only get better.

The thing with Maconomy is you’re buying a big box of tricks, and you need to know what you’re doing, have a very detailed spec, patience and a frothy budget.

A range of separate and colourful workflow systems have been invented to fill the many gaps left by Maconomy, Deltek even brought one themselves, but the reality is Maconomy for many ends up an expensive and under-utilised general ledger and accounting system.  Excel reigns supreme.

In all this time, like a long-life battery powered toy soldier, Rebus, now Paprika has quietly and defiantly marched on to a steady beat. A Cobol-based solution developed almost 30 years ago, it was the go to system for smaller agencies and despite attempts by SAGE, QuickBooks and latterly, Xero, the NZ originated cloud system, in many ways it still is.

Paprika has never made a big show of itself, yet through the passage of time and the reluctance of agencies to change systems, it has built a tidy market share of around 1000 agencies, a handful who are global. Despite being clunky and not so easy to use, it’s seen as a safe bet.   

A major drawback though is it is a one currency database system. What this means is as soon as you open your first offshore office, you need two databases. Imagine you have 20 offices in 14 countries. That’s a lot of databases, and even more Excel.  

Today the large networks still angst over systems, systems like Maconomy were seen as a great leveller. Mid-tier platforms for standardising multiple agencies, before moving upwards onto something that allowed greater flexibility in global client billing and reporting hierarchies, and migration to some form of shared service. Indeed this was my own strategy in deploying it into WCRS, now The Engine Group, following our MBO in 2004.

The problem is upwards moves to say Microsoft Dynamics AX or SAP come with their own monumental challenges, and matching price tags. A litany of issues prevail in the network attempts with these systems.

For SME’s, the great hope is the cloud.  

New agile systems, built from the ground up overcome many of the limitations sitting in systems made in the past. Agencies can implement without major cash outlay, retain flexibility and enjoy inbuilt scalability. Cloud usually means seamless and automatic upgrades, allowing users to benefit from continuous system improvements. Never again be threatened with an unsupported version.  

The better cloud solutions have open API’s, allowing true connectivity with other business tools, CRM, CPM, and BI, fully embracing the notion that whilst they may do more, they also do it better. The really good ones integrate all the features of job management, accounting and resourcing – the benefits of which are staggering.

There is still no single panacea for the world of marcoms business management and reporting intelligence, and in a tight margin and competitive digital world, agencies need to find their own differentiators.

Assessing what is important to agencies, the information needs at all levels, the degree of flexibility and autonomy management wants to allow, requires a matching to increased number of suitable systems of today which can offer exactly that. Even Excel now competes with Google Docs.

Which all means it is a really interesting time for agencies.

Overall in the past 20 years agencies have not demanded more, and have been fearful of change, even at risk of continuously adding overhead to get basic information circulated. Accepting compromise has unfortunately ingrained vendor complacency.

Yet for many of the new breed of agency, client demands, the general increase in the variety, scope and speed required of work, and the associated massive increase in the volume of data, compromise and complacency can no longer be tolerated.

The good news is there is now choice. The cloud has brought options that are fully featured, continuously improving, intuitive, easy to use, cost effective and quick to implement.

Agencies fear making decisions on systems, but change should be embraced. As a famous person once said, “Not to change, is to die.”  

So the future for agency systems is indeed bright and can be whatever colour you choose for your management dashboard.

 

How Fit Is Your Agency Solution?

Assess Your Current Performance And Discover How To Transform Your Agency by AccountAbility

THE STATE OF PLAY:  AGENCY LIFE

Today’s agencies are experiencing a very real threat: the increased pressure from clients to do more for less. Add to this the emerging trend of some marketers to bypass agencies and go straight to the source of production and media, or bring the process in-house,  and you have genuine conflict in agency life.  These pressures have a number of consequences. 
It’s natural to respond by working faster, harder and  longer - which more often than not won’t deliver increased profitability or productivity (though it’ll probably get a client off your back for a week or so).

We work with dozens of agencies who are trying to keep pace with rapid changes in the value chain on top of new technology, while still delivering outstanding work for their clients. It’s far from easy and no agency is perfect. 

Click here to download the full ebook

Putting the colour back into Agency Finance

For all the creativity and expertise in executing costly and memorable advertising, the slick, cutting-edge, technology-savvy image that defines the client view of agencies is often a thin veneer.

For many agencies, whilst their front-of-house seeks to project laser-beams of product consciousness directly into their client's consumer brains, their back office is often a dark place. The back office is more often a Dickensian workhouse where off-the-shelf general ledger systems, separate workflow and timesheet systems, and a plethora of spreadsheets are operated by grey prickly men and women. These individuals are (not) living the dream of working in the fast moving and exciting world of advertising and communications.

A new client for them is a nightmare of even more spreadsheets linked to the ones they have so carefully nurtured to produce a version of "the truth" for management. The ever-present risk of these falling over with the catastrophic consequence of them having no idea of where they are financially speaking, just got worse.

That these businesses make any money is typically assumed to be testament to management's orchestration of the talent and output to deliver on the clients promise. This is twinned with a commercial robustness that has allowed them some slack, and this is probably right. Up to a point.

What this view overlooks is the underlying (sometimes undying) loyalty of the grey finance people, who are daily tested to the extreme in bringing the commercial picture of the agency's creative effort into management's view.
However, given the web tangle of data being reported in yet another smart looking spreadsheet, can agency managers be confident the view they are receiving is derived from "one source of the truth"?

In many cases they're not. Some typical quotes I've heard from agency CFO's go along the lines of:
"Our systems are not integrated, we've got plenty of data it's just not all in the one place", to "I know our figures are not 100% right."
How did it get like this?
Perhaps it has always been this way.

Many agencies set-up in business with the talent to conceive and execute outstanding creative work, yet leave their financial systems to be upgraded at later stage. This is typically when their first major client starts demanding greater analysis and evidence they can control and manage their multi-million-dollar/pound account.

Some agencies upgrade even later when they're looking to step up a gear, move into new territories, raise capital or they cannot continue without fully knowing the facts that only a real-time and integrated system can bring.

It is not untypical that up to this point, most (if not all) client budgeting, reporting and analysis is done in spreadsheets. With these financial data views not coming directly from a transaction system, there is no one source of the truth, and this disconnect carries risk.
Client job budgets can be thousands of dollars/pounds, sometimes millions. This is split between the value of the agency time determined to deliver the job, the third party costs and a fee comprising most of the profit element.

Without integration between the spreadsheet budget and general ledger, the time spent on the job may not be known, the agency can lose sight of third party costs and, very soon, the expected profit and working capital positions are exposed.

Integrated systems provide visibility over client jobs at any stage and so help ensure agency's management stay in control of their jobs. It also ensures they can earn the profit needed to continue employing the creative talent which has set them apart in the first place.

One big reason why agencies delay going with an integrated system from the outset is cost, with legacy systems requiring an intensive capital investment in licensing, hardware, and implementation consultancy.

The current compromise is for start up agencies to go with an off-the-shelf product, such as SAGE, Quickbooks, and supplemented by spreadsheets until the need to upgrade arises. They hope to manage the disconnection.
As these start-ups grow, the choice of integrated systems opens up for agencies in the 25 to 100 headcount (user) range. Although these carry their own restrictions on functionality and scalability, meaning they are still likely to be faced with another upgrade, at say more than 100 users. Here the cost becomes truly significant.

Another typical factor for delay is the disruption associated with a systems upgrade, and a "leap of faith" that management needs to go with one vendor or another.

Early on and the disruption can be contained to a small number of people, although even here there will still be a step change when the need for a "grown up" finance system becomes an urgent imperative.
It has been my long held objective to redefine the systems landscape for creative agencies and make the decision on which system to choose a "no-brainer".

Enter AccountAbility 
With AccountAbility, this "holy grail" is close to becoming a reality.

Peer-group functionality 
Agency management can now take-on a very grown-up, fully integrated system with the functionality and real time reporting built into the core architecture of AccountAbility. This gives the agency visibility and control over their business from day one.

Variable-cost model 
An agency's subscription to AccountAbility is based on the numbers of users in any given month. This is ideal where freelancers make up a high proportion of the headcount at various times. With the exception of a few days consulting and training, there is no upfront capital outlay. Total cost of system ownership is low.

Scalability 
No-one is saying agencies will never have to contemplate a systems upgrade, but with a current client rolling out the system globally for all of its 1,000 users, this will satisfy the life-time needs of most agencies.

User-ability 
The system was purpose built for agencies and every part of the workflow has been developed carefully with agency people in mind. With an intuitive system comes an encouragement to use, and this improves the chance for timely and accurate information.
Agency management can achieve greater control over job profitability, because they can now know where they are on a job at any stage, without having to call in the grey men.

Cloud solution
The system comes with all the benefits of a cloud solution, providing instant access 24/7, seamless version upgrades and automatic functionality improvements. This is delivered with no reliance on IT support for updating hardware, maintaining servers and managing the back-up processes.
These benefits and a future savings pot growing as the money that would have to have been set aside for a finance systems upgrade can now be provisioned to invest in creative or other productive staff.
This can also translate to turning the grey men and women in Finance into valuable business analysts, removing them from repetitive data entry and spreadsheet hell. Instead, rewarding them with the fulfilled roles they have so long desired in the fast and colourful world of advertising that they chose to join.

By Chris Lever