The Redundancy Hunt: Auditing a Lending Company's Tool List

Marketing Academy · Field Work●Marketing Tools

All projects·From: Building Your Martech Stack

MiniAudit· 30 minutes

Five-Star Business Finance

Objective: Given a real list of marketing tools a mid-size NBFC is paying for, apply the lesson's audit framework to flag duplicates, ghost subscriptions, and coverage gaps across the six martech layers.

You're the marketing ops analyst at Five-Star Business Finance, the Chennai-founded NBFC that listed on the NSE/BSE in November 2022 raising roughly $240M. Finance has asked why the marketing software bill keeps climbing while nobody can say what half the tools actually do.

Sort the 14-tool list by martech layer, flag anything duplicating another tool's job, flag anything nobody has logged into in 90 days, and name the one layer with zero coverage.

Before you start

What you'll need

Free path (everything below is enough to finish)

Google Sheets

FreeBuild the audit and reconciliation tables

Free, works for any team size, no integration needed to start

The process

2 steps

Step 01 of 02

Auditing existing tools for duplicates, ghosts, and gaps

The lesson's Step 2 says every audit should surface duplicates (two tools doing the same job), ghost tools (subscriptions nobody uses), and gaps (jobs with no tool at all) — most audits find 2-3 redundant tools and 1-2 critical gaps.

The list has two social schedulers (Buffer and Hootsuite, both active), zero CDP, and a $400/month 'analytics suite' with no login in 6 months. What do you cut, what do you keep, and what's missing?

Google Sheets— Paste the 14-tool list into a sheet with columns: Tool, Layer, Monthly Cost, Last Login, Owner.

Procedure

List all 14 tools with their monthly cost and layer
Flag Buffer and Hootsuite as a duplicate pair (both do Layer 2 social scheduling)
Flag the $400/month analytics suite with no login in 6 months as a ghost tool
Check each of the six layers for zero coverage, mark Layer 1 (Data and Audience) as the gap since there's no CDP

Sample output

Five-Star Business Finance, Tool Audit (excerpt)

DUPLICATES
  Buffer ($15/mo) + Hootsuite ($99/mo), both Layer 2 social scheduling. Keep Buffer, cancel Hootsuite. Saves $99/mo.

GHOST TOOLS
  DataSuite Analytics ($400/mo), 0 logins in 180 days. Cancel pending finance sign-off. Saves $400/mo.

GAPS
  Layer 1 (Data and Audience), no CDP. Lead data lives in 3 disconnected spreadsheets.

Healthy

Every tool maps to exactly one layer, no tool sits unused for 90+ days, all six layers have at least baseline coverage.

Unhealthy

Two tools doing the same job, a $400/month subscription with zero logins, and a foundational layer (data/audience) with no tool at all.

What this means

The audit isn't about counting tools, it's about counting jobs with no owner and jobs with two owners, both waste money.

So what do I do about it?

Symptom	Action	Effort
Two schedulers both active and both billed	Cancel the lower-usage one this billing cycle	5 min
A $400/mo tool with no logins in 6 months	Cancel or reassign an owner with a 30-day usage check-in	30 min

YouYou can do this yourself, no engineering access required.

Step 02 of 02

Diagnosing fragmented data as the root cause of stack failure

The lesson's 'Why Most Stacks Fail' section says the root cause is almost never weak tools, it's fragmented data, when tools don't talk to each other, teams end up with three different versions of the same number and trust none of them.

Marketing reports 340 leads last month. Sales reports 210. Finance's dashboard shows 275. All three numbers come from different tools tracking the same funnel. Which number is right?

Google Sheets— Build a lead-count reconciliation table pulling the raw count each tool reports plus its data source (form fills, CRM stage change, deal creation).

Procedure

List what each of the three numbers actually counts (form fills vs CRM contacts vs closed-won-stage deals)
Identify that none of them are wrong, they're measuring different funnel stages that were never explicitly connected
Recommend the one system of record (CRM) that all three teams should read from going forward

Sample output

Lead Count Reconciliation

Marketing (340): raw website form fills, no dedupe
Sales (210): CRM contacts marked 'Sales Qualified'
Finance (275): deals created in the billing system

Root cause: three tools, three definitions of 'lead', zero shared ID between them.

Healthy

One system of record, every team's report traces back to the same underlying records.

Unhealthy

Three teams reporting three numbers for what should be one metric, each convinced their own tool is correct.

What this means

This isn't a math error, it's a plumbing error, the tools were never connected, so the same event got counted three different ways.

So what do I do about it?

Symptom	Action	Effort
Marketing, Sales, and Finance report three different lead counts	Designate the CRM as system of record and route the other two reports off it	half day

EitherYou or a developer can handle this, depending on your access.

Final deliverable

A completed tool audit table (duplicates/ghosts/gaps flagged) plus a one-paragraph recommendation naming the single system of record for lead counts.

See a reference example

Sample output

Jyoti CNC Automation, Q3 Tool Audit Summary

Cut: 1 duplicate scheduler ($99/mo), 1 ghost analytics tool ($400/mo). Total savings: $499/mo.
Gap flagged: no CDP, lead data lives in 3 spreadsheets, recommend Segment or HubSpot's native CDP add-on once contact volume passes 5,000.
System of record: CRM stage changes only, marketing and finance dashboards to be rebuilt off CRM data by end of quarter.

Success criteria

You're done when you can:

Correctly identifies the duplicate tool pair and its cost
Correctly identifies the ghost tool via login/usage data
Names the layer with zero coverage
Recommends a single system of record for the lead-count discrepancy