10 business questions your marketing and sales report still doesn't answer

Your report is probably right. The problem is that it answers marketing questions, and the leadership meeting asks business questions. The ten below come up in real meetings, and in almost every operation the honest answer is the same: we can't know with what we have today.

Next to each one is the data that is missing and, more importantly, what that gap costs in practice. If your marketing and sales report already answers three or four of them, your operation is ahead of the average.

Why the report almost always stops at the lead

It is not carelessness on the part of whoever builds it. The report stops at the lead because that is as far as the tool can see. The ad platform knows how much the click cost and how many forms came after it. What happened to that person in the following weeks is in the CRM, in a system that never talked to the ad account.

Whoever bridges the two, in most operations, is a spreadsheet updated by hand at the end of the month. It works while the volume is small and while the person who maintains it is around. When the volume grows, the spreadsheet becomes the bottleneck, and answering the questions below starts costing days of manual work instead of minutes of querying.

That is why the list is organized into three blocks, in the order in which the data gets lost: first in media, then in the handoff to sales, and last in recognizing who the customer is.

What the media actually bought

1. Which campaign generated customers, and not just leads? To answer, the sale needs to come back from the CRM and find the lead that originated it. Without that return trip, you optimize campaigns by form volume. The side effect is well known: the campaign that brought in the quarter's three biggest contracts may have been paused months earlier for looking expensive on cost per lead.

2. How much of the open pipeline came from paid media? You have leads by channel. Reais under negotiation by channel, you don't. The difference shows up when defending budget: whoever brings volume to the meeting discusses cost, whoever brings expected revenue discusses allocation. The missing data is the deal value, which lives in the CRM and rarely reaches the media report.

3. CPL dropped, but did revenue keep up? Cost per lead falling while cost per customer rises is the most common and the most invisible scenario in paid media. It happens when the channel becomes cheap because it started bringing in people who don't buy. As long as the report measures only the top of the funnel, this deterioration passes as good news for two or three months in a row, and the adjustment only comes when the sales team complains about quality.

What happens after the MQL

4. How long does it take from the first click to the sale? The lead's creation date is not the date of first contact. If the person browsed the site for three weeks before filling out the form, your real cycle is longer than the one in the report. The consequence is cash-related: the quarter's budget is being charged before the revenue it bought has time to arrive, and the channel takes the blame for a delay that belongs to the cycle itself.

5. At which stage does the funnel stall? Conversion from top to close says that it dropped. Stage-by-stage conversion says where it dropped. The first becomes a target in the meeting, the second becomes an action for Monday, and only the second changes anything. To have it, the CRM stages need to mean the same thing to the entire sales team, which is less obvious than it seems when each salesperson moves the card by their own criteria.

6. What did the customer see first and what did they see last? They are two different numbers for the same sale, and both are correct. The first touch shows where demand is born, the last shows what was in front of the person when they decided. Without the two side by side, the meeting spends forty minutes arguing about which report is right. It is worth knowing that Google Analytics removed the first-click model from GA4 in November 2023, so this reading needs to come from a base that stores the source per lead.

7. Why did direct traffic grow? Almost never because of brand loyalty. Almost always because of a missing UTM parameter in some campaign that went live last week. Until the hole is closed, the channel that brought that lead simply doesn't exist in the report, and next month's budget is decided without it.

Resource · In PortuguesePrompt Guide for Marketing and Sales70 prompts with questions about marketing, sales and behavior to ask your data.Download the guide

Who the customer who stayed is

8. How many of these leads are the same person? The same customer enters once with a personal email, then with a corporate one, then through WhatsApp. As long as they are three records, the top of the funnel is inflated and the acquisition cost looks better than it is, because the same investment was divided by a number of people that doesn't exist. In Brazil the problem has a well-known aggravating factor, which is the phone number with and without the ninth digit becoming two records.

9. Which channel brings in the customer with the highest ticket? Volume and value rarely come from the same place. The channel that fills the top is usually not the one that sustains the margin, and without the average ticket broken out by source the operation keeps rewarding the first and cutting the second. The data depends on the lead's source surviving the conversion into a deal inside the CRM, which is exactly where it tends to get lost.

10. Which leads are worth today's call? Order of arrival is the default criterion when there is no criterion. The person's behavior, such as returning to the site on consecutive days or opening the latest emails, answers better than the signup date. Without that reading, the sales team spends the best hours of the day on people who haven't decided anything yet, while those who were ready to buy wait in the queue.

How to use this list to improve your marketing and sales report

The temptation, after reading ten gaps at once, is to open a front for each one. It is the fastest path to solving none. Three steps pay off more.

Mark which of these questions have already come up in your last three meetings. Usually it is two or three, always the same ones. They are your real priority, not the whole list.

For each of them, write down where the data is today. Media platform, CRM, the team's spreadsheet or nowhere. This half-page map usually reveals that most answers require joining two sources that nobody has joined yet.

Fix the handoff, not the indicator. Almost all of these questions depend on the same bridge: the lead's source needs to survive until the closed deal. Fixing that handoff once answers several questions at once, while creating a new indicator answers only one.

Frequently asked questions

Do I need all ten answers? No. Most operations make better decisions by answering three of them well than by answering all ten poorly. The criterion for choosing is how often the question comes up in your meetings.

Can this be answered with a spreadsheet? It can, and that is how it starts almost everywhere. The limit shows up when the volume grows: manual updating becomes days of work, and the number starts arriving after the decision it was supposed to inform.

Isn't this a job for a data team? It depends on the path. Building your own structure requires someone who programs and maintains it. When the data model is born with lead, campaign, event and deal as ready-made concepts, the marketing and sales team itself operates it.

What your marketing and sales report is missing

Did you notice that the problem repeats? None of these questions asks for a new metric. All of them ask for the same thing: media, site and CRM reading the same lead. As long as the three live in three places, your report remains correct and incomplete at the same time, and the missing part is precisely the one leadership asks about.

A word of caution before you go reworking everything. A marketing and sales report with ten new indicators and no business answers is worse than the current one, because now nobody knows where to look. Start with one question, the one that comes up most in your meetings, and build the data path only for it.

This is the work Laiki does at the entry point: UTMs are organized automatically, records of the same customer merge into a single profile and the sale returns from the CRM to the lead that originated it. The ten questions become a query, not a project.

Save this list and take it to your next results meeting. To build each indicator, with formula and example, download Laiki's Metrics Guide.