Admin console

Verification queue

Jobs table + manual entry

Verified rows go live on the dashboard; manual entries queue above first.

Referrals pipeline

Content review (16 pending)

Builders from lib/content.ts mapped to content_drafts rows on approval.

• How to read a Local job board like a JW (book numbers, calls, storms) reddit-electricians

  pending

  Post: walkthrough of book 1 vs book 2, what 'calls' actually mean, and when storm work is worth the drive. Ends with one line: 'I keep a free verified-calls list at ElectricianDB — DM me your local and I'll look it up.' No links in the post body (spam filter); link only on request in comments.

  ApproveEditReject

• Davis-Bacon pay: why two JWs on the same site can make different rates reddit-electricians

  pending

  Post: plain-English explainer of prevailing-wage determinations + fringe, with a worked example ($38 base + $12 fringe vs $46 flat). Comment follow-up offers the Davis-Bacon job filter on ElectricianDB.

  ApproveEditReject

• Traveling for work? Checklist before you sign the book in a new local reddit-ibew

  pending

  Post: reciprocity check, per-diem math (GSA tables), housing lead time, and who to call at the hall. Offer: 'I built a free tool that checks your license against the reciprocity matrix — happy to run anyone's state pair in the comments.'

  ApproveEditReject

• Data-center calls are booming — what ticket do they actually want? reddit-ibew

  pending

  Post: roundup of recent data-center calls (JW + instrumentation), what 'fab experience' means on a posting, and realistic per-diem ranges. Invite members to compare notes on halls with the most calls.

  ApproveEditReject

• This week's top-paying union electrical calls (TX/OK/LA) facebook

  pending

  Group post: 3 highest-comp active calls with pay + local + how to apply via the hall. First comment: link to ElectricianDB dashboard. Cadence: weekly Monday 8am CT.

  ApproveEditReject

• Apprentice tip: what to bring on day one of a data-center job facebook

  pending

  Short list post (boots, PPE, basic hand tools, lunch you can eat with gloves nearby). Soft CTA to the apprentice job filter. Targets IBEW apprentice groups.

  ApproveEditReject

• Why verified union job boards beat aggregators for electrical hiring linkedin

  pending

  Founder POV post: aggregators show stale/duplicate postings; halls need verified calls with license-tier + reciprocity attached. 150–250 words, no external link in body (link in comments for reach).

  ApproveEditReject

• Hyperscale builds are reshaping JW demand across TX/AZ linkedin

  pending

  Data-note post: summarize 2–3 project_intelligence rows (project, county, trade demand) + what it means for traveling JWs. Tags: #IBEW #skilledtrades #datacenter.

  ApproveEditReject

• POV: your hall has 200 guys on Book 1 and Texas has 40 open calls tiktok

  pending

  HOOK: Your local has no work. Texas has forty open calls. Here's the math nobody shows you.
  BEAT 1: Show the book number vs open-calls list side by side.
  BEAT 2: Per-diem math: $120/day × 5 = $600/week most travelers forget to add.
  BEAT 3: Reciprocity check takes 30 seconds — most states accept your ticket.
  CTA: Free verified-calls list is in my bio — filter by your license.

  ApproveEditReject

• Davis-Bacon explained in 45 seconds tiktok

  pending

  HOOK: Two electricians, same site, different paychecks. Here's why.
  BEAT 1: Federal money = prevailing wage, posted on a determination.
  BEAT 2: Base + fringe beats a higher 'flat rate' more often than you think.
  BEAT 3: Always ask: is this call Davis-Bacon? Then check the rate.
  CTA: I tag every Davis-Bacon call on ElectricianDB — link in bio.

  ApproveEditReject

• Things I wish I knew before traveling for a data-center job tiktok

  pending

  HOOK: Drove 9 hours for a data-center call. Wish someone told me these three things.
  BEAT 1: Fab/data-center onboarding takes days — bring money for week one.
  BEAT 2: Per diem starts when you arrive, not when you leave home.
  BEAT 3: Verify your license transfers BEFORE you drive, not after.
  CTA: Run your state pair free — reciprocity checker in my bio.

  ApproveEditReject

• Monday intro — top calls ranked by real annual comp newsletter

  pending

  Intro: 'Hourly rate lies. A $34/hr call with $150/day per diem beats a $40/hr local call by ~$25k a year. Below are this week's top calls ranked by estimated annual comp — per diem and sign-on included.' Pairs with buildMondayEdition.

  ApproveEditReject

• Thursday intro — federal work + hyperscale + shops hiring in volume newsletter

  pending

  Intro: 'Thursday is the money edition: Davis-Bacon prevailing-wage calls, hyperscale/data-center builds, and the shops hiring five-plus hands at once.' Pairs with buildThursdayEdition.

  ApproveEditReject

• Referral invite (SMS) sms

  pending

  ⚡ {referrer} says you're a good hand. Verified IBEW calls + license help, free: {link}

  ApproveEditReject

• Weekly top-call nudge (SMS) sms

  pending

  ⚡ {count} new {state} calls this week, top pay ${pay}/hr. See them: {link}

  ApproveEditReject

• License-expiry nudge (SMS) sms

  pending

  ⚡ {name}, your {state} license renews in {days} days. Renewal checklist: {link}

  ApproveEditReject

Ingestion Control

Manual scraper triggers via /api/admin/scrape (Bearer CRON_SECRET / ADMIN_API_TOKEN / SCRAPE_HEALTHCHECK_TOKEN). Without Supabase every run is stubbed: rows return in-sample only, nothing is inserted, and the summary below is the artifact.

Automation-health monitor

Loading integration status…

Newsletter preview

Subject: Top 3 union electrical calls this week

3 jobs referenced. Publishing via Beehiiv is stubbed until keys are set.