All work

Automation Analysis · Sales Operations · Decision Story

Controlling Lead Reassignment Cost

A decision analysis testing whether repeated Zapier lead reassignment produces enough productive outcomes to justify automation-task consumption.

Controlling Lead Reassignment Cost dashboard preview

Why this matters

Reframed a reporting request into an automation-control decision using volume, productivity and repeated-run evidence.

The question

Problem

Repeated lead reassignments consume Zapier tasks, but task volume alone does not show whether the automation creates enough productive business outcomes.

The work

Approach

  1. 01

    Matched lead records to reassignment runs and standardized outcome categories.

  2. 02

    Separated total lead volume, reassigned leads and automation-run consumption.

  3. 03

    Compared productive and non-productive outcomes by source and lead type.

  4. 04

    Built an executive story focused on where automation should be controlled.

Verified evidence

What the analysis surfaced

1,798

Total leads

453

Reassigned leads

1,122

Matched runs

46.6%

Productive outcomes

53.4%

Non-productive outcomes

62.6%

Digital Marketing share

1,126 leads

The decision

Recommended action

  • Set reassignment limits where repeated runs show low incremental productivity.
  • Treat Digital Marketing quality as a portfolio-level issue because it dominates lead volume.
  • Measure automation with outcome-per-run metrics, not only total leads processed.

Capabilities demonstrated

Process-cost analysisRecord matchingOutcome classificationExecutive storytellingAutomation governance

Tools

RData cleaningOperational analyticsKPI designExecutive storytelling

Limits & responsible use

  • No monetary saving is claimed because a verified cost-per-task value was not provided.
  • The analysis reflects the available operational period and recorded outcome definitions.

A reliable analyst is a decision partner

Let's make the next decision clearer.

I'm interested in data analyst, business intelligence and analytics roles where rigorous analysis, reliable reporting and stakeholder communication matter.

Email me