Weekly champion job change tracker for Salesforce

Every Monday at 8am, run a champion job change tracker across my Salesforce closed-won contacts and tell the right rep when one of their champions has moved to a new company.

Trigger: a weekly cron, Mondays at 8am in my local timezone.

Step 1. Use Salesforce Get Many Contacts (SOQL) to pull every Contact whose AccountId belongs to an Account with at least one Closed Won Opportunity and that has a LinkedIn URL on file. For each contact return the Contact Id, Name, LinkedIn URL, Email, the Account Id, the Account Name, and the Owner (OwnerId, Owner Name, Owner Email). If LinkedIn URL lives on a custom field in my org, use that custom field.

Step 2. Feed those LinkedIn URLs into Crustdata Enrich Person, batched up to 25 URLs per request. Only use the canonical /in/<slug> form, never the URN form. Pace the calls sequentially because Crustdata person enrich is 15 requests per minute. For each profile, read back current_employer (name and linkedin_company_url where available) and current title. Skip Crustdata PE01 and PE03 errors silently and keep going.

Step 3. For each champion, decide whether they have changed jobs. Compare the Crustdata current employer to the Salesforce Account Name on the contact. Prefer matching on the LinkedIn company URL or company domain when either is available, and fall back to a fuzzy name match for the rest. If the enriched employer still matches the stored Account, skip the contact entirely. Otherwise treat it as a probable job change.

Step 4. For every flagged contact, use Salesforce Create Task to file a task on the contact. Set WhoId to the Contact Id, OwnerId to the existing account owner, ActivityDate to 3 days from today, Priority to High, Status to Not Started, and Subject to something like "Champion job change: <Contact Name> now at <New Company>". In the task description, include the old company, the new company, the new title, the LinkedIn URL, and a one-line note that this was auto-detected from a LinkedIn profile change.

Step 5. Group the flagged contacts by owner and use Slack Send a Message to notify each owner. If the owner has a Slack DM available, DM them. Also post a consolidated summary to a #champion-moves channel if one exists. Keep each message concise: one block per champion containing their name, the old company (which was their Salesforce Account), the new company, the new title, a link to the Salesforce contact, the LinkedIn URL, and a 2 to 3 sentence draft re-introduction that the rep can paste straight into Gmail or LinkedIn. The draft should be warm, congratulatory, reference the prior working relationship, and end with a soft ask to reconnect.

Rules to enforce. Never message an owner if none of their champions changed jobs. Never create a Salesforce task for a contact whose enriched employer still matches the stored Account. Skip anyone without a LinkedIn URL on the Salesforce contact. Do not retry on Crustdata PE01 or PE03 errors. Group the Slack message by owner so each rep sees their own list, not the whole company's.