What is the campaign pipeline ranking app?
Rank campaigns by the pipeline created at accounts that engaged with them before the deal existed. Count each deal once, and say that coming before does not mean causing. This shows which campaigns deserve credit and budget. The campaign pipeline ranking app does this for deals created in the last 90 days.
Opens the live app on demo data. No sign-up needed. On your own N.Rich account, it reads accounts and deals from HubSpot or Salesforce.
- A headline figure The value of pipeline with campaign engagement, with its share of all pipeline and the part that came before the deal was created.
- A flow from campaigns to deals Campaigns are stacked bars, joined by ribbons to deals sized by value and coloured by status. Glowing dots show each week of touches, and a replay button plays them.
- Rankings and detail Four summary cards, a campaign ranking with CSV export, a breakdown by engagement type and timing group, and a detail panel for each campaign.
- Built for
- Marketing, Leadership
- Category
- Reporting
- Reads from
- N.Rich and your CRM (HubSpot or Salesforce)
- Built by
- N.Rich
- Cost
- Free on demo data. No credit card.
Prompt to build it
Prompt
I'm the CMO, and I need to decide which ad campaigns deserve credit, and budget, for the pipeline we create. Build me a 'Campaign Influence Pipeline Ranking' app. Look at deals created in the last 90 days, switchable to 30, 60 or 180, and default to net-new business only. A touch is an ad click, an article read or a video view by the deal's account. Impressions never count. A touch counts as before the deal when it falls within 90 days up to the creation date, switchable to 30, 60, 180 or 365. Influence is yes or no for each deal and campaign. Count each deal's value once, so campaign rows won't add up to the total. Say plainly that came before does not mean caused. Show cost per touched account from each campaign's spend. Say what is missing in words, never as 0. Lead with a large figure for pipeline with campaign engagement, then an animated flow of campaigns on the left joined by ribbons to deals on the right, sized by value and coloured by status. Add four summary cards, a ranking of campaigns by pipeline preceded with CSV export, a breakdown by engagement type and by timing group, and a detail panel for each campaign. Add a replay button and a presenter mode.
Results may vary. N.Rich AI can build a different version of the app from the same prompt.
Change the prompt to fit your team, then build your own in the N.Rich AI playground. Build your own
What questions does the campaign pipeline ranking app answer?
Which ad campaigns influence pipeline?
Link each deal to the campaigns that its account engaged with before the deal was created. A touch is an ad click, an article read or a video view, never an impression. Ranking campaigns this way shows where credit and budget may belong. The campaign pipeline ranking app lists campaigns by the pipeline they came before, with touched accounts and cost per touched account.
In the app: Campaign rankingHow do I give campaigns credit without multi-touch attribution?
Use a yes or no for each deal and campaign: did the account engage before the deal existed. Skip weights and models. Count each deal's value once, so campaign rows will not add up to the total. A simple rule is easy to explain to a CFO. The campaign pipeline ranking app uses yes or no influence and says so on the page.
In the app: How these numbers are builtWhat is the difference between touches before and after a deal?
A before touch falls in a set window up to the deal's creation date. An after touch comes later. Deals touched only before are pre-influenced, before and after are full funnel, and after only are post-influenced. The split shows whether campaigns lead deals or follow them. The campaign pipeline ranking app groups deals this way and always shows not influenced beside them.
In the app: Deals by influence timingHow do I work out cost per touched account for each campaign?
Divide a campaign's spend by the accounts it touched. Compare only campaigns with enough touched accounts and spend, so a tiny campaign does not rank first by chance. Fair cost ranking protects budget from small samples. The campaign pipeline ranking app ranks cost only for campaigns with at least 3 touched accounts and spend of at least a tenth of the median.
In the app: Campaign rankingWhich engagement type comes before the most pipeline?
Compare ad clicks, article reads and video views by the pipeline they came before, and name a winner only with enough deals. This shows which format to build more of. The campaign pipeline ranking app shows a Largest pipeline preceded card for the campaign and one for the engagement type, each needing at least 3 deals, plus a table by engagement type with CSV export.
In the app: Largest pipeline preceded cardsHow can I show which campaigns fed new pipeline?
Draw campaigns on one side and deals on the other, joined by ribbons, so people see the paths at a glance. A picture of the flow is easier to discuss than a table. The campaign pipeline ranking app does this in a flow called Watch pipeline being created, with glowing dots for touches, a Replay button and a Presenter mode.
In the app: Flow
What data does the campaign pipeline ranking app use?
From N.Rich
| Source | What the app reads | Where you see it |
|---|---|---|
| Ad engagement | Ad clicks, article reads and video views, by account and campaign | Which campaigns came before each deal |
| Campaigns | Names, status and spend | The ranking and cost per touched account |
From your CRM HubSpot or Salesforce
| Source | What the app reads | Where you see it |
|---|---|---|
| CRM deals | Created date, value, pipeline, stage, status and net-new flag | Pipeline value, deal scope and the flow |
| Exchange rates | Rate from USD to your reporting currency | The currency label next to every figure |
In the playground, every source holds demo data.
How does it work?
- You write one prompt, shown below. The app takes deals created in the last 90 days, which you can switch to 30, 60 or 180. It defaults to net-new business only.
- A touch is an ad click, an article read or a video view by the deal's account. Impressions never count. A before touch falls within 90 days up to the creation date, which you can switch to 30, 60, 180 or 365.
- Influence is yes or no for each deal and campaign. The app counts each deal's value once, so campaign rows do not add up to the total.
- Deals fall into four timing groups: pre-influenced, full funnel, post-influenced and not influenced. Not influenced always shows beside the others.
- Cost per touched account comes from each campaign's spend. The app ranks cost only for campaigns with at least 3 touched accounts. Missing data shows in words, never as 0.
Before you start
Is it free?
Yes. Every app runs free in the N.Rich AI playground on demo data. You do not need a credit card.
Do I need my own data?
No. The playground runs on a demo dataset, so you can try the app before you connect your own data.
Which CRMs does it work with?
On your own N.Rich account, apps read accounts and deals from HubSpot or Salesforce.
Can I change it?
Yes. Ask N.Rich AI to add a column, change a filter or focus on one segment, and it rebuilds the app.