Skip to main content
Web Wizard Dev
All projects

Client project · Labor union

Teachers' Union Website & Member Platform

Moved a 14,000-member teachers' union off a hard-to-edit Drupal site onto one platform where staff publish content without a developer and members sign in with an emailed code.

Client
Philadelphia Federation of Teachers
Industry
Labor union
Timeline
May 2026 to present
Year
2026
Platforms
Web
PFT homepage with the breaking-news banner, a hero carousel and quick links to the contract, FAQs, enrollment and Find Your Rep

Results at a glance

14,000+members on the roster the platform serves
250+members signed in with an emailed code since September 2026
86 to 100Lighthouse accessibility, old Drupal homepage vs the new pft.org homepage
75%less time to count an email audience as filters change (805 to 203 ms)

The challenge

Baseline · email audience count805 msto update the member count on each filter change

  1. Much of the old site was frozen in code: the staff-rep lookup was a script with the school-to-rep mapping typed into arrays, the membership figure had drifted about 360 members above the real roster, and endorsements were a hand-edited list. Every change needed a developer.
  2. The roster is a monthly CSV from an outside vendor that replaces the member list each time. Between two exports the vendor changed its member IDs (0 of 13,700 matched) and 41 members changed email address, so a naive import would have duplicated or wrongly removed thousands of people.
  3. Over 14,000 members needed to sign in without anyone creating accounts. Passwords add support load, and one-time links sent to school email are often "clicked" by the mail scanner before the teacher sees them.
  4. Staff wanted to email members by school or legislative district, honor every unsubscribe, and know exactly who did not get a message. A full-roster send takes far longer than a serverless function may run, and the audience count took 805 ms to update on each filter change.
  5. Staff need different permissions over sensitive member data, including bulk exports, and the union needs a record of who looked at or exported what.
  6. 18 years of press releases lived on the old site, many stamped with a later migration date, with links pointing at pages and tracking services that no longer exist.

About the project

Designed and built the new pft.org for the Philadelphia Federation of Teachers, replacing a Drupal site hosted by the national union. The public site covers news, events, press releases, the contract, enrollment, a staff-rep lookup and election endorsements, and staff edit all of it from an admin area. Behind it sits a member platform: passwordless sign-in for everyone on the roster, a roster import with preview and safe deactivation, an email campaign tool that targets members by school or legislative district, role-based staff access, and an audit log of staff changes, exports and member searches. 18 years of archived press releases were recovered with their original dates, and their old URLs still work.

Scope

  • Site migration
  • Member portal
  • Passwordless sign-in
  • Roster import
  • Email campaigns
  • Admin tools
  • Content archive recovery
  • Accessibility & SEO

What it does

  • A public site staff edit themselves

    News, events, press releases and PD posts with a rich-text editor and a shared media library. The homepage carousel and breaking-news banner are editable. Site-wide search runs on a static index built at deploy time. If the database goes down, cached pages keep serving their last good copy, and a page that cannot load shows a branded error page with the office phone number.

  • Find Your Rep

    294 school listings mapped to their staff reps, in the database, with an admin screen to add schools and reassign reps.

  • PFT Votes

    Endorsed candidates by office and district, plus canvass and phone-bank shifts. Candidate labels are derived from the seat, so the card and the district filter can never disagree.

  • Passwordless member sign-in

    A member types their email address and gets a 6-digit code, with a sign-in link as a backup. The roster decides who has access, so no one creates accounts. Access is re-checked on every request, and a member who leaves the roster sees an "access ended" screen. Over 250 members have signed in since it opened in September 2026.

  • Roster import

    It takes the vendor's CSV and checks the file before touching anything, warns when a column arrives emptier than the roster's, shows a preview (new, returning and leaving members), and marks departed members inactive rather than deleting them. A drop of more than 20% needs an admin to sign off. It has run 3 times on the live roster.

  • Email campaigns

    Templates, drafts, a live preview and merge fields. Audiences are built by filters: school, job title, bargaining unit, staff rep, dues type, years of membership, and 5 legislative-district levels (U.S. House, state senate, state house, county, city council). The member count updates as filters change; a rewrite of the counting query cut it from 805 ms to 203 ms. Sends go through a queue that sends up to 100 emails per request, records every recipient, retries failures, and produces a failure report and CSV. Unsubscribe links work without signing in, and an unsubscribe always overrides being added to an audience by hand.

  • Staff roles and an audit log

    Viewer, editor, admin and developer tiers, stored apart from the member roster so a roster import can never demote an admin. Changes to staff accounts, email campaigns, audience exports and every page of a member search are written to an audit log that admins can filter and read.

  • The old archive is back, and old links still work

    260 press releases and PD posts from 2008 to 2026, with their 337 images and PDFs, imported as ordinary posts with their real publication dates. Every archived post's old URL has its own permanent redirect.

Our approach

  1. Moved every frozen piece into the database with an admin screen: 294 school listings and their reps, candidates and volunteer shifts, homepage slides and banner, and a shared media library. The membership figure is computed from the live roster at build time, so it cannot drift again.

  2. Keyed the roster on the vendor's own stable ID and made the import validate before it writes: it stops on missing or duplicate IDs, detects shifted columns, previews every change, and marks departed members inactive instead of deleting them. A drop of more than 20% needs an admin to confirm.

  3. Built passwordless sign-in around a 6-digit code, which a mail scanner cannot use up, with a sign-in link as a backup. The roster decides who has access, and it is re-checked on every request.

  4. Wrote one SQL function that defines an audience, so the preview count and the send list can never disagree, and restructured it around a shared base set, cutting the count from 805 ms to 203 ms. Sends go through a database queue that a scheduled job drains in batches of up to 100 emails per request. Every recipient gets a record, failures retry and end up in a downloadable report, and an unsubscribe always wins over a manual include.

  5. Kept staff roles in their own table, separate from the roster, and enforced them twice: in the app and in database row-level security. Changes to staff accounts, email campaigns, audience exports and every page of a member search are audit-logged. 2 security audits reviewed the auth, data and admin surfaces, and a SQL test suite checks the live database's permissions on every merge to main.

  6. Recovered the archive with a one-off import that took each post's date from the dateline printed in its body where the stored date was a migration artifact. It checked every link: 47 dead links were removed, and 45 email-tracking links were rewritten to their real destinations. Every archived post's old URL got its own permanent redirect, with no catch-all to the homepage.

Inside the project

Select a screenshot to view it full size.

The outcome

  • pft.org has run on the new platform since September 2026, replacing the Drupal site. The staff-rep lookup, endorsements and homepage are edited from the admin area, and the public membership figure, once overstated by about 360 in 7 hand-typed places, now comes from the roster at every build.
  • The platform now handles member information work that used to take several full-time staff, and those staff spend the time on other work (owner-reported).
  • Over 250 members have signed in with an emailed 6-digit code since sign-in opened in September 2026, and no one had to create an account for any of them.
  • 3 roster imports have run on the live roster since September 2026: each file was checked and previewed before anything was written, and 158 members who left were marked inactive, not deleted.
  • 260 archived press releases and PD posts (2008-2026) and 337 images and PDFs restored with their original dates, 47 dead links removed, and 286 permanent redirects so links in old coverage still land on the right page.
  • Lighthouse accessibility up from 92-96 to 100 on all 6 key public pages, with best practices and SEO at 100 on all 6, measured on pft.org. The old Drupal homepage scores 86 for accessibility and 85 for SEO.
  • Google PageSpeed Insights scores the live homepage 95 for mobile performance and 100 on desktop (best of 3 and 2 tests, October 2026), and real visitors' Core Web Vitals are all rated good, with the main content showing within 1.4 s on 75% of mobile visits.
  • Audience counts went from 805 ms to 203 ms (75% less time, about 4× faster) after a rewrite of the counting query, which made room for 5 levels of legislative-district filters: with all 10 filters, a count takes 284 ms.
  • 883 automated tests, plus lint, type checks and a production build, run in CI on every pull request. A database authorization suite runs against the live database on every merge, and every pull request went through automated code review, with each finding checked against the code before it was acted on.

Built with

Have a project like this in mind?

Tell us what you're building. We'll show you how we'd approach it and what it would take, the same way we did for Philadelphia Federation of Teachers.