Case studies

Real projects. Measurable business impact.

Engagements I have taken on, each tagged with the outcome it was judged against. Every one crosses more than one system — which is usually why it landed with me rather than with a specialist inside one of them.

Client names are withheld under confidentiality, so each engagement is identified by sector. Outcomes are based on project estimates and operational reporting, with approximate figures labelled accordingly.

Case 01Replacing Paid Data ConnectorsInternational training and subscription businessCost

~$10ksaved annually

Problem

Recurring third-party connector fees added cost to reporting across Salesforce and multiple advertising platforms.

What changed

Built and maintained direct API integrations using Google Apps Script to retrieve and standardise data from Salesforce, Meta Ads, Google Ads and LinkedIn Ads, reducing dependency on paid extraction tools such as Supermetrics.

Outcome

Replaced recurring connector subscriptions with owned, maintainable data pipelines, saving approximately $10,000 per year while keeping the reporting data available.

Google Apps Script
Salesforce
Meta Ads
Google Ads
LinkedIn Ads

Sources against conformed dimensions

Source	Customer	Campaign	Revenue
Salesforce	feeds Customer	feeds Campaign	does not feed Revenue
HubSpot	feeds Customer	feeds Campaign	does not feed Revenue
GoHighLevel	feeds Customer	feeds Campaign	does not feed Revenue
Google Ads	does not feed Customer	feeds Campaign	does not feed Revenue
Meta Ads	does not feed Customer	feeds Campaign	does not feed Revenue
GA4	does not feed Customer	feeds Campaign	does not feed Revenue
Stripe	feeds Customer	does not feed Campaign	feeds Revenue
Chargebee	feeds Customer	does not feed Campaign	feeds Revenue
Xero	does not feed Customer	does not feed Campaign	feeds Revenue

Brand is a column on every one of them, not a separate report.

~$10k
Annual connector savings: 4
Major platforms integrated: Direct API
Instead of paid connectors

Case 02Moving High-Volume Automation to n8nInternational training and subscription businessCost

~200kZapier tasks migrated

Problem

Growing task volume on Zapier increased reliance on usage-based automation fees and made workflow costs harder to control.

What changed

Rebuilt existing Zapier flows in self-hosted n8n, retaining integrations and business logic while bringing execution and infrastructure under direct control.

Outcome

Migrated workflows representing approximately 200,000 Zapier task executions, reducing exposure to per-task charges. A specific annual dollar saving has not been independently established.

n8n
Zapier
APIs
Webhooks

Acquisition to revenue

SpendRevenue attributed

Google Ads
Meta Ads
LinkedIn Ads
Organic / direct

Same spend, redistributed. The channel with the largest budget was not the channel producing the revenue.

~200k
Task executions migrated: Self-hosted
n8n automation: Lower
Usage-based fee exposure

Case 03Custom Dashboards Instead of Viewer LicencesInternational training and subscription businessCost

~50dashboard users

Problem

Providing reporting access through individual Power BI viewer licences added recurring cost and limited how access could be tailored by team or role.

What changed

Built a role-based JavaScript dashboard for approximately 50 users, with controlled access to operational KPIs and reporting views, hosted on a DigitalOcean server.

Outcome

Reduced dependence on paid viewer licences by delivering reporting through a custom web application. Hosting cost was approximately $24 per month; net savings depend on licence and operating costs.

JavaScript
Power BI
DigitalOcean
APIs

Unified customer record

Sources joined

To first call

11 min

Record status

Complete

META ADSClicked campaign · Q3 WebinarD+0
GOHIGHLEVELForm submitted · 14:02D+1
SALESFORCELead assigned · owner setD+2
AIRCALLOutbound call · 4m 12s · connectedD+3
SALESFORCEOpportunity created · £14,400D+4
CHARGEBEESubscription active · annualD+5

~50
Dashboard users: $24/mo
Server hosting cost: Role-based
Reporting access

Case 04Subscription Intelligence & Historical CRM DataTraining and subscription businessRevenue

~20%CLV & ROI improvement

Problem

Subscription retention, customer lifetime value and historical CRM activity were difficult to analyse consistently, while long-term records put pressure on Salesforce data-storage costs.

What changed

Developed customer lifecycle and subscription analysis, unified payment and CRM records, and built a historical data-access layer outside expensive Salesforce record storage while keeping older customer information available.

Outcome

Analytics and operational initiatives supported approximately 20% improvement in subscription customer lifetime value and ROI. Moving historical records out of primary CRM storage also reduced reliance on paid Salesforce storage expansion; monetary storage savings were not quantified.

Salesforce
Chargebee
Stripe
BigQuery
Power BI

Dormant records, by reason

Never contacted1,240£71k
Stalled at proposal890£96k
Lapsed customer1,610£58k
Contacted, no follow-up1,060£15k

4,800 records, scored on last contact, acquisition cost and stage at stall.

~20%
CLV and subscription ROI improvement: External
Historical CRM archive: Ongoing
Access to legacy records

Case 05Reporting AutomationMulti-channel training providerTime

30 hrs → 2 hrsper week

Problem

A recurring management reporting process relied on manual exports from five platforms, spreadsheet updates, data checks and repeated reconciliation. By the time the numbers were agreed, the week they described was already over.

What changed

The workflow was rebuilt around scheduled data pipelines, a modelled reporting layer with agreed KPI definitions, automated validation rules and alerting when a source stops delivering.

Outcome

Reporting preparation dropped from roughly 30 hours per week to around 2 hours of review and validation. Numbers now arrive before the meeting instead of after it.

BigQuery
n8n
Power BI
Google Ads
Meta Ads
Stripe

Weekly reporting process

93%
Less manual preparation: 6
Sources consolidated: Daily
Refresh instead of weekly

Case 06360° Lead & Sales IntelligenceSubscription business with an outbound sales teamVisibility

One customer.One view.

Problem

CRM records, call activity, marketing source data and payment history lived in four systems. Nobody could answer a simple question — what actually happened with this customer — without opening four tabs and guessing.

What changed

Lead, call, opportunity and payment signals were resolved to a single customer identity, cleaned of duplicates, and combined into one unified view with follow-up quality and pipeline movement made visible.

Outcome

Sales teams and management gained one clear picture of customer activity, follow-up and opportunity status — including the leads that had never been contacted at all.

Salesforce
Aircall
GoHighLevel
Chargebee
PostgreSQL

Unified customer record

Sources joined

To first call

11 min

Record status

Complete

META ADSClicked campaign · Q3 WebinarD+0
GOHIGHLEVELForm submitted · 14:02D+1
SALESFORCELead assigned · owner setD+2
AIRCALLOutbound call · 4m 12s · connectedD+3
SALESFORCEOpportunity created · £14,400D+4
CHARGEBEESubscription active · annualD+5

4 → 1
Systems to check: 100%
Calls matched to CRM records: Visible
Follow-up quality per rep

Case 07Revenue AttributionPaid-acquisition-led business, multiple marketsRevenue

Marketing → Revenueend to end

Problem

Marketing spend, lead activity and closed revenue were held in separate systems with inconsistent campaign naming. Channel performance was argued about monthly and never settled.

What changed

Campaign, lead, opportunity and payment data were connected through one attribution model, with enforced naming standards, validated tracking and revenue joined back to the original acquisition source.

Outcome

Management could finally see which channels and campaigns were contributing revenue rather than volume — and move budget on evidence instead of opinion.

Google Ads
Meta Ads
LinkedIn Ads
GA4
BigQuery
Stripe

Acquisition to revenue

SpendRevenue attributed

Google Ads
Meta Ads
LinkedIn Ads
Organic / direct

Same spend, redistributed. The channel with the largest budget was not the channel producing the revenue.

Spend → £
Joined at customer level: 3
Ad platforms reconciled: CAC / ROAS
Reported on real revenue

Case 08CRM Data RecoveryB2B services group, two prior migrationsReliability

31% → 0.4%duplicate records

Problem

Years of imports, manual entry and two migrations had left duplicate companies, contacts attached to the wrong parent, ownership that no longer matched the team, and campaign names that never agreed with the ad platform. Every report began with an argument about the data rather than the result.

What changed

Deduplication on deterministic keys first and fuzzy matching second, with a documented survivorship rule for which value wins. Ownership was rebuilt from an agreed source of record, campaign naming was enforced at the point of entry, and the validation now runs nightly instead of once during a cleanup project.

Outcome

The CRM moved from a system people worked around to the one people quote. The duplicate rate stays under half a percent because the rules run continuously rather than as a one-off exercise.

Salesforce
Python
BigQuery
n8n

Deduplication, one account

Northgate LtdImport 2021
Northgate LimitedManual entry
NORTHGATE LTD.Migration
Northgate LtdSurvivorship applied

Deterministic keys first, fuzzy match second, and a written rule for which field wins. The same rules then run nightly.

0.4%
Duplicate rate, sustained: Nightly
Validation instead of ad-hoc: 1
Agreed source of record

Case 09Dormant Opportunity RecoverySubscription business, five years of historyRevenue

£240ksurfaced from records already owned

Problem

Leads that were never contacted, opportunities abandoned mid-pipeline, and customers who had lapsed quietly. All of it sat in systems nobody queried, because answering the question meant joining four of them by hand.

What changed

Every dormant record was scored against last contact, acquisition cost, previous value and the stage it stalled at — then surfaced as a working queue with the reason attached, refreshed each morning rather than exported once.

Outcome

The sales team gets a daily list of real opportunities drawn from data the business had already paid for, instead of a static export that goes stale within a week.

Salesforce
Chargebee
BigQuery
Power BI

Dormant records, by reason

Never contacted1,240£71k
Stalled at proposal890£96k
Lapsed customer1,610£58k
Contacted, no follow-up1,060£15k

4,800 records, scored on last contact, acquisition cost and stage at stall.

4,800
Records re-scored: £240k
Pipeline surfaced: Daily
Queue refresh

Case 10Call IntelligenceHigh-volume inbound sales teamVisibility

Every call,actually read

Problem

Several hundred calls a week, each logged as a duration and a disposition picked from a dropdown. Managers sampled a handful; the rest was invisible. Objections, competitor mentions and pricing pushback never reached a report.

What changed

Calls are transcribed, then classified against a taxonomy the sales team agreed to — outcome, objection, competitor named, next step committed — and written back onto the CRM record. The model summarises and tags; the rep still decides what happens next.

Outcome

Management can see what customers actually said, at full volume rather than by sample. Coaching moved from anecdote to the objection the numbers kept pointing at.

Aircall
Python
Salesforce
BigQuery

One call, classified

Transcript · 06:42

“It is not the price. We looked at this two years ago and the rollout took most of a quarter, so I need to know what that looks like before I take it to the board.”

Outcome: Follow-up booked
Objection: Implementation time
Competitor: Named — incumbent
Next step: Proposal by Thursday

Written back to the record the same day. The model tags; the rep decides.

100%
Of calls classified: 6
Objection categories tracked: Same day
Written back to the record

Case 11One Warehouse, Three BrandsGroup operating three trading brandsVisibility

9 sources.One model.

Problem

Three brands, three CRMs, two ad accounts each, and a finance system that knew nothing about any of them. Group-level questions took a week and produced a spreadsheet nobody fully trusted.

What changed

A warehouse with one modelled layer above it: shared customer and campaign dimensions, brand carried as a column rather than as a separate report, and every definition agreed in writing before anything was built.

Outcome

Group and brand numbers now come out of the same model, so they cannot disagree with each other. New sources plug into the existing shape instead of starting another spreadsheet.

BigQuery
Python
n8n
Power BI
Salesforce
HubSpot

Sources against conformed dimensions

Source	Customer	Campaign	Revenue
Salesforce	feeds Customer	feeds Campaign	does not feed Revenue
HubSpot	feeds Customer	feeds Campaign	does not feed Revenue
GoHighLevel	feeds Customer	feeds Campaign	does not feed Revenue
Google Ads	does not feed Customer	feeds Campaign	does not feed Revenue
Meta Ads	does not feed Customer	feeds Campaign	does not feed Revenue
GA4	does not feed Customer	feeds Campaign	does not feed Revenue
Stripe	feeds Customer	does not feed Campaign	feeds Revenue
Chargebee	feeds Customer	does not feed Campaign	feeds Revenue
Xero	does not feed Customer	does not feed Campaign	feeds Revenue

Brand is a column on every one of them, not a separate report.

9
Sources conformed: 1
Shared dimensional model: Both
Group and brand from one source

Case 12Lead Routing & Follow-upInbound-led services businessTime

2 hrs → 4 minfirst response

Problem

New enquiries landed in a shared inbox and were picked up by whoever noticed first. Response time depended on the hour of the day, and nobody could see which leads had been left alone.

What changed

Validation, enrichment and routing on rules the team agreed — territory, value band and current load — with an SLA clock running on every record and an escalation when it expires.

Outcome

First response fell from around two hours to four minutes. Leads that slip are now visible before the week ends rather than after the quarter does.

GoHighLevel
Salesforce
n8n
Slack

Inbound lead handling

4 min
Median first response: 0
Leads unassigned overnight: Per rep
SLA performance visible

Need your data to work harder?

I can build the full solution.

Whether you need dependable data pipelines, CRM optimisation, better reporting or automation, I can help design, build and improve the solution from end to end.

Discuss a project LinkedIn

hello@mehrdadfashami.com

Start with whichever is true

Taking on new work.