The problem this solves
LinkedIn reporting has a missing column. Spend is known to the cent, leads are counted precisely, and revenue - the thing both exist for - is a shrug deferred to "attribution is hard." So monthly reports optimize their narrative around cost per lead, the metric available rather than the metric meaningful, and every reader silently applies their own guess about what the leads were worth.
Once conversion events stream with values, the missing column exists in your own ad account: revenue attributed per campaign by LinkedIn's own attribution, from events your CRM certified. The report that joins spend to leads to streamed value per campaign is suddenly assemblable - but it still spans three reporting surfaces, and manual assembly is exactly the monthly chore that slides.
This mission assembles it into the deck the channel always deserved: per campaign, what was spent, what was captured, what value came back - every number a designed chart, the true-return ranking explicit, delivered monthly without anyone opening three dashboards.
How the mission runs
- Gather the three ledgers. Campaign spend from the ad account, the captured leads with their quality scores, and the streamed conversion events with their attributed values - the full journey from budget to revenue in one gather, pulled live from the connections rather than pasted together from three exports of three different vintages.
- Join per campaign. The three ledgers join on campaign: spend beside leads beside streamed value, with the join's honesty stated - events carry LinkedIn's own attribution, and unattributed revenue is reported as such rather than smeared.
- Chart every number. Spend versus return as paired columns per campaign, the funnel from impressions to value as a flow, quality mix alongside - each figure in the platform's designed theme, identical month over month.
- Rank on true return. Campaigns rank by streamed value per dollar - with volume-honest flags on thin evidence - and the narrative names what the ranking changes about next month's budget.
- Assemble and deliver. Charts and narrative land as a Gamma deck with a one-line takeaway per figure, delivered on the monthly schedule ready for the review meeting.
The prompt
This is the exact objective the agent receives. Swap the obvious placeholders for your own domain, segment or channel and run it as-is from the console, Slack, or the API.
What comes back
The closed-loop monthly deck: spend, captured leads, and streamed revenue joined per campaign, every number charted in a consistent designed theme, campaigns ranked by true return with honest attribution caveats - cost per lead finally demoted to a supporting metric.
Make it yours
- Add quarter-to-date and trailing-three-month lanes once three monthly decks exist, so that single-month noise stops driving quarterly conclusions and the trend gets a fair vote.
- Build the agency edition per client workspace with the same engine and client-facing framing.
- Pair with kill-or-scale: this deck is the meeting artifact, that playbook is the per-campaign decision engine.
Frequently asked questions
How true is "true" ROAS here?
As true as the loop you run: events carry the values your CRM certified and LinkedIn's own campaign attribution. The deck states its caveats - attribution windows, unattributed revenue, thin cells - because a return metric is only useful when its honesty is legible.
What if we have not streamed any conversions yet?
Run the backfill playbook first and this deck gets months of history in its first edition. Without any events the mission degrades honestly to a spend-and-quality report and says the revenue lane is waiting on the loop.
Why a deck instead of a dashboard?
Because the monthly review is a narrative moment: a ranked story with takeaways, read top to bottom by people deciding budget. Dashboards answer ad-hoc questions; this artifact settles the monthly one - where did the money work.