Applied AI Work
Case study · Assessment framework

Team LinkedIn presence assessment

A scored, ranked assessment of how a team shows up on LinkedIn, built from publicly available data using an orchestrated AI toolchain. Turns scattered signals into a single team scoreboard with one priority action per person.

Problem

Most team LinkedIn profiles quietly drift out of sync with the team's brand and the story the org is trying to tell. Inconsistent headlines, outdated employers, and the occasional departure signal — all visible to any buyer who looks before a meeting.

What we built

A four-tool workflow that turns a list of LinkedIn URLs into a ranked team scoreboard with individual assessment tabs. Five criteria, scored one to three, total out of fifteen, with status labels that point to a specific next move.

AI role

Enrichment via Clay, structured staging in Sheets. The model reads the structured record and the live profile, scores across all five criteria, and returns a JSON payload. Apps Script rolls each payload into a named tab and updates the team scoreboard.

Current status

Working framework. Tested on a real team; the methodology can be adapted to other team-based LinkedIn assessments.

Working framework Multi-tool workflow Assessment design Public data only
Wireframe · Toolchain & team scoreboard · Synthetic data
01 · ENRICHMENT
Clay
LinkedIn URLs → structured fields
02 · STAGING
Sheets
Single source of truth, consistent columns
03 · ASSESSMENT
Model
Reads record + live profile · scores · JSON
04 · AUTOMATION
Apps Script
Paste & run · builds individual tabs
05 · OUTPUT
Scoreboard
Ranked team view · priority per person
Team scoreboard Ranked · priority per person
#PersonSegmentTotalStatusPriority action
01Person 01Senior · Practice A14 / 15Gold standardMaintain cadence · post a case study
02Person 02Lead · Practice B12 / 15Good · gapsTighten headline to current role
03Person 03Senior · Practice A10 / 15Reach, no activityStart a monthly post · keep it short
04Person 04Lead · Practice C8 / 15Headline driftRewrite headline · update employer
05Person 05Senior · Practice B6 / 15Possible departureManager conversation · check intent
Criteria · 1 → 3 · low · mid · high 13–15 best in class 9–12 gaps remain 6–8 action needed

Working framework shown with synthetic data, built from public data only. The methodology can be adapted to other team-based LinkedIn assessments.

Start a conversation