A performance marketing dashboard exists to make one decision well: which paid campaigns get more budget next month, which get less and which get switched off. The catch is timing. A lead from this week's ad may not become a won client for six weeks, so judging a campaign on this month's revenue punishes your newest work. This article answers how to build a cohort view in Reporting on the levelpartner.ai platform that groups results by the month the lead arrived, and how to turn it into clear budget rules.
The timing problem every paid report hides
Most paid reports put this month's spend next to this month's results. That works for clicks and form fills. It fails for revenue, because the deals closing this month started weeks or months ago, often from a different campaign.
The fix is to group outcomes by lead month. Every contact that arrived in March, from a given campaign, stays in the March group however long they take to close. You then watch each group mature. After a few months, you know how long a campaign's leads typically take to convert, and you can judge new campaigns fairly.
What the dashboard shows
For each campaign and each lead month:
- Spend in that month.
- Leads that arrived in that month.
- Booked calls from those leads, to date.
- Opportunities and pipeline value from those leads, to date.
- Won value from those leads, to date.
- Cost per booked call and cost per won client for the group.
Early in a group's life, judge it on cost per booked call. Once it is old enough to have closed, judge it on won value.
Before you start
- Ad accounts connected in Settings, so spend appears in Reporting.
- Campaign and source parameters on every ad link, so each lead carries its campaign.
- Opportunities created from contacts, so won value links back to the original source.
- Your typical time from lead to won client, even as a rough figure.
- A budget owner who will act on the dashboard monthly.
How to set it up
- Check that every live ad uses campaign and source parameters on its link.
- Go to Contacts, open a test lead and read its Activity tab.
- Go to Dashboard, click + Add Dashboard and name it paid campaigns.
- Add Amount Spent from Meta Ads and Total cost from Google Ads.
- Add Contacts Count Over Time with First Attribution under Conditions.
- Add Total Opportunity Value with First Attribution, then switch to Table.
- Open Select Columns and add UTM Campaign.
- Add Won Opportunity Value with the same condition and columns.
- Click Save Changes and set at least six months in the Date Picker.
- Write your budget rules in each widget's Description.
Turn the dashboard into budget rules
A dashboard without rules produces debate. Write three rules before the first monthly review. For example: a campaign whose cost per booked call is below your ceiling for two consecutive lead months gets a budget increase. A campaign above the ceiling for two months gets cut back. A campaign whose oldest mature group has produced no won value gets paused for review.
The thresholds come from your own economics. Your ceiling for cost per booked call is what you can afford given your close rate and average deal value.
Suppose the ceiling is an illustrative £150 per booked valuation. Campaign A runs at £95 and £110 in its last two lead months, so under the rules its budget rises. Campaign B runs at £210 and £190, so it is cut by a third. Campaign C's oldest group, now four months old, shows 14 booked valuations and no instructions won, so it would be paused while the sales lead reviews the calls.
What it replaces in a 10 to 250 person firm
It replaces the monthly meeting where the paid media owner presents platform-reported conversions and the owner asks why revenue has not moved. Both are looking at different time windows. The cohort view puts them on the same one.
It also replaces the instinct to cut a new campaign after one quiet month. If your typical lead takes six weeks to close, a one-month-old group cannot have closed yet, and the dashboard makes that visible.
Time it takes
Setup takes two to three hours if tracking parameters are already in place, and a day if they need fixing. The monthly budget review takes 30 to 45 minutes. A weekly glance at booked calls by campaign takes five minutes.
The mistake most people make
Comparing cost per lead across campaigns. Cheap leads are often cheap because they are poor. A campaign with twice the cost per lead can still produce booked calls at half the cost if its leads are better qualified. Always compare on cost per booked call at minimum, and on won value once groups are mature.
When not to use it
If you spend little on paid media, or run a single campaign, the cohort view is more work than it is worth. Use the simpler advertising dashboard instead. It also fails when sales cycles run longer than a year, because groups take too long to mature. In that case, judge campaigns on pipeline created and revisit annually.
Troubleshooting
Spend shows but leads do not link to campaigns. Landing pages are dropping the tracking parameters, often because a redirect strips them. Test the full link from the ad to the form and back to the contact record.
Won value appears under the wrong campaign. The opportunity took the latest source instead of the original one. Check which source your won value widget uses, and read the ad attribution guide for how first and latest source differ.
Old groups keep changing. Late wins are still arriving, which is expected. Note the age at which each group usually stops changing and use that as your maturity point.
The rules feel too rigid. They should be. Allow one documented exception per month, and record why, so the rules improve rather than erode.
Frequently asked questions
How long should I wait before judging a paid campaign?
Judge it on cost per booked call after one full lead month. Judge it on won value once its oldest group passes your typical time to close.
Can this work across several ad platforms?
Yes, as long as every platform's links carry consistent campaign parameters. The cross-channel attribution article explains how to keep naming consistent.
What if a campaign brings in leads that buy something else?
Won value still counts, because the lead came from that campaign. Note it in the review, as it may point to a better offer to advertise.
Should organic channels be on this dashboard?
No. Keep it to paid campaigns where budget is the decision. Organic channels belong on your main marketing dashboard.