Spreadsheet or agency software? Start with the client brief

What to take away

Start with the brief, not the format

A Leeds agency replacing a £900 a month reporting suite should write the client deliverable first. Then score tools against it, whether that tool is a spreadsheet or a subscription platform.

If the brief is one monthly performance report, Google Sheets may be enough. It is free with a Google account and supports shared editing. Microsoft Excel is part of Microsoft 365 and suits complex financial models.

If the brief covers ten clients, paid media and weekly dashboards, software is usually cheaper than staff time.

A brief template to score against

Write the brief on one page before any demo. These six lines are enough to score a spreadsheet and a platform on the same terms:

A Leeds agency replacing its reporting subscription would fill in ten clients, weekly output, three ad and analytics sources and client logins. Those four answers already rule out a shared spreadsheet before any price is compared.

Spreadsheet or software: the trade-offs

Spreadsheets are flexible, cheap and familiar. They struggle with version control, permissions and large data sets. Both offer pivot tables and charts. Neither is built for client logins.

Software adds integrations, audit trails and scheduled exports. It also adds per-seat costs, contracts and switching risk. Airtable has a free tier and paid per-seat plans. Smartsheet charges per user for project tracking.

AgencyAnalytics is built for agency client reporting and connects ad and analytics accounts, including Google Analytics, Google Ads and Meta Ads. Its pricing usually scales with client numbers.

Five options to shortlist

How to decide

Use the brief to set criteria. Count clients, reporting frequency, data sources, team size and budget.

Spreadsheet if one client, one source, monthly output. Software if many clients, many sources, weekly output. Spreadsheet if budget under £50 a month. Software if staff time saved exceeds the licence.

Score each shortlisted option against the brief on five criteria: time saved, licence cost per seat as quoted by the vendor for your seat count, setup, training and export quality. Give each criterion a score from 1 to 5 against the brief, then add them up; where the brief is multi-client and weekly, count time saved twice, because that is the cost that compounds. A brief with ten clients, weekly dashboards and paid media sources pushes the score towards software, because copy-paste time is the line item that grows. A brief with one client, one source and a monthly report pushes it towards a spreadsheet, where the money stays on the report.

An illustrative scorecard for the Leeds brief (ten clients, weekly dashboards, three ad and analytics sources, client logins) shows how the method works. A shared Google Sheet might score 1 for time saved, 5 for licence cost, 4 for setup, 5 for training and 3 for export quality: 18, or 19 with time saved counted twice. A dedicated reporting platform such as AgencyAnalytics might score 5, 2, 3, 3 and 4: 17, or 22 with time saved counted twice. Your own scores will differ; the point is that the weighting comes from the brief, not from the demo.

Run a one-month trial on live work. Record where people work around the tool. Agree who owns the rollout before you sign: who migrates the existing reports, who trains new starters, and who calls time on a tool that is not earning its place.

Contracts, data and compliance

Check who owns the data, where it is hosted and how long it survives cancellation. Under UK GDPR, that is a controller and processor question, not a support ticket; the Information Commissioner's Office (ICO) is the regulator, and its register of fee payers shows which controllers have paid the data protection fee. Shared links add access risks.

Advertising claims your agency makes on behalf of clients also carry rules. The Committee of Advertising Practice (CAP) writes the UK Advertising Codes and the Advertising Standards Authority (ASA) enforces them, and the AdviceOnline library sets out detailed guidance on specific advertising issues, which is useful when a tool promises automated compliance.

Reporting on organic search also depends on how search engines fetch and render client pages, and the Google crawler overview explains the user agents and infrastructure involved.

Where training fits

A licence without training is a subscription to unused seats. Price the handover: who teaches new starters, who owns the internal playbook, and who updates it when the interface changes.

Some agencies buy external training rather than build it in house, and the IPA's bespoke training is one route for procuring that support.

Review the licence after twelve months. Tools that fit ten people may not fit thirty.

Common questions

These are the questions buyers ask most often when the choice is between a spreadsheet and a paid tool.

When is a spreadsheet enough?

When one client, one or two data sources and a monthly report are the norm. Move to software when copy-paste time passes the licence cost.

When should we buy software?

When reporting is recurring, multi-client and needs permissions, scheduled exports or integrations. Match the tool to the brief, not the demo.

What is the biggest hidden cost?

Migration and training, plus the staff time spent on both. Ask for those hours in the proposal so they appear in the budget rather than in a quiet overspend.

Do we need a contract review before signing?

For anything above a few hundred pounds a month, yes. Check renewal uplift, auto-renewal notice and the data export clause before you commit.