Cleaning Roster Datafor Union Campaign Success
Module 4 · Placeholders, Junk, and Standardization › 4.5 Card support % checkpoint
Subsection 4.5 · Checkpoint

Card support % checkpoint

~5 min

Checkpoint · Module 4

Time to prove what placeholders cost. In the Module 4 workbook, you will calculate Card Support % two ways and report the difference.

Your task

  1. Calculate raw card support %: signed-card rows divided by the total row count, with no cleaning.
  2. Calculate cleaned card support %: signed-card rows divided by valid-contact rows only.
  3. Report the delta in percentage points.

Hint

COUNTIFS lets you exclude multiple placeholder strings in one denominator. The numerator is signed-card rows. The denominator is valid-contact rows (everything except blanks, (000) -, and N/A).

You pass when:

Your cleaned-card-support formula reads:

=COUNTIF(E:E,"<>") / COUNTIFS(C:C,"<>(000) -", C:C,"<>N/A", C:C,"<>")

And the cell shows approximately:

  • Raw: 54%
  • Cleaned: 67%
  • Delta: +13 percentage points

Badge unlocked: Placeholder Detective

Submit the cleaned workbook in the LMS. The 13-point gap you just measured is the difference between a campaign that files prematurely and one that hits supermajority. Module 5 is next.

Action: Submit your checkpoint workbook in the LMS to unlock the next module.