Summary

As an executive preparing for a leadership meeting, you often need a fast, accurate answer to a simple question: are we pacing our ad spend the way we expected? The challenge isn’t access to data – it’s getting a clean, consolidated snapshot without starting a Slack thread, interrupting marketing, or creating unnecessary concern. When ad spend lives across multiple platforms and channel types, even a straightforward pacing check can turn into a time-consuming exercise.

This example shows how combining month-to-date spend across all ad platforms, then breaking it down further by channel type and branded versus non-branded investment, creates immediate clarity. By layering platform, Search versus YouTube, and brand segmentation into one analysis, leaders get a complete picture of where budget is going and how it aligns with growth strategy. With that context, conversations shift from “How are we performing?” to “How do we optimize this?”

Pete’s tips and best practices

“Start with the pacing question, not the platform question.” 

When preparing for leadership discussions, the first priority is whether spend is tracking against expectations. A high-level month-to-date view creates orientation before diving into channel details.

“Break apart aggregated channels to avoid blind spots.”

Platforms often bundle multiple channel types together. Separating search from video, or other sub-channels, prevents hidden spend from distorting your understanding of performance.

“Look at brand and non-brand separately.”

Branded and non-branded spend serve different strategic purposes. Reviewing them independently helps clarify whether budget is reinforcing existing demand or creating new demand.

“Use snapshots to start better conversations.”

A fast, accurate snapshot eliminates the need to ask basic performance questions. When leaders already understand the numbers, conversations can focus on what to improve rather than what happened.

Summary

As an agency leader or strategist, it’s often difficult to quickly understand why performance suddenly changes. KPI spikes or drops can signal opportunity or risk, but identifying the root cause typically requires manual analysis across multiple tools and datasets. That investigation slows decision-making and pulls focus away from strategic work.

In this example, Gary uses MCP to securely connect Claude to Databox and quickly understand what’s driving spikes or drops in key metrics. Instead of manually digging through data, he asks natural-language questions and gets clear explanations of what changed and why. MCP gives Claude the context it needs to analyze performance accurately, so Gary can validate assumptions, pinpoint contributing factors, and decide what to do next, in minutes.

Gary’s tips and best practices

“Look beyond the spike to understand the story behind it.” 

A KPI increase is not automatically a win. Breaking performance down by integration, channel, and content type helps determine whether growth is driven by acquisition, retention, or product usage – each requiring a different strategic response.

“Standardize your metrics before layering on AI.”

When metrics are clearly defined and structured across integrations, analysis becomes exponentially more useful. Clean, curated data creates a foundation that AI can interrogate effectively, reducing noise and misinterpretation.

“Use AI to elevate junior talent, not replace senior thinking.”

When account managers can investigate performancto elevate juniading senior resources.

Summary

If you’re consistently posting on LinkedIn, the challenge isn’t access to data — it’s making sense of it. Native analytics show impressions, reactions, and comments per post, but they don’t make it easy to analyze trends across content or evaluate whether engagement is compounding over time. Manually reviewing posts slows insight and makes strategy reactive instead of intentional.

This example shows how Kamil Rextin, founder of 42 Agency, used the Databox MCP with Claude to run an analysis of his LinkedIn data. In minutes, he was able to evaluate engagement patterns, compare content performance, and identify where to refine his strategy, turning raw metrics into clear direction. 

Kamil’s tips and best practices

“Always evaluate LinkedIn performance across the full funnel, not just engagement.” 

Top-of-funnel metrics can signal interest, but they don’t confirm impact. When engagement is viewed alongside conversions and pipeline metrics, it becomes clear which campaigns are creating real business value.

“Look for mismatches between cost and outcome.”

High spend with low downstream impact often signals a targeting or messaging issue. Comparing cost-per-click and cost-per-conversion side by side helps uncover inefficiencies early.

“Use trend comparisons to guide budget shifts.”

Performance in isolation can mislead. Comparing current results to a previous period highlights improving campaigns worth scaling and declining efforts that need adjustment.

Summary

Many agencies show performance trends. Fewer help clients understand whether those numbers are actually strong for their market. Without competitive context, it’s hard to know if a 3% conversion rate or a rising CAC is acceptable, average, or a warning sign.

In this example, 42 Agency used the Databox MCP with Claude to generate benchmarks based on company size, revenue range, and industry. Instead of relying on broad industry averages, they compared live client metrics against relevant peer groups. The result is clearer priorities, more confident planning, and stronger strategic positioning with clients.

Want to benchmark your own performance against relevant peers?

Kamil’s tips and best practices

“Use benchmarks to guide planning, not just reporting.” 

Benchmarks are most powerful when used during target-setting and quarterly planning. They help answer, “What should we aim for?” instead of just “What happened?”

“Filter benchmarks before you trust them..”

Broad industry averages can distort strategy. Narrow benchmarks by revenue band, company size, or business model so comparisons reflect your client’s reality. Relevance determines usefulness.

“Shift the conversation from results to position.”

Monthly trends show direction. Daily engagement reveals timing. When you understand when comments and interactions spike, you can align outreach to moments when prospects are already active.

“Always be ready to answer: What are the next steps?

When you show clients where they stand in the market, discussions become more focused and less reactive. Instead of debating numbers, you align on what needs to improve to stay competitive.

Summary

As a sales leader, it’s difficult to recommend clear next steps when pipeline performance appears steady. Looking back four months at deal creation and total pipeline value shows trends hovering at similar levels, with no meaningful upward movement. When performance is flat, leadership conversations shift from reporting results to justifying what should change – and without broader context, decisions often default to more cold outreach.

This example connects pipeline trends with LinkedIn engagement data – total likes, total comments, and daily activity patterns – to evaluate whether there is untapped opportunity within an already active audience. By analyzing both revenue signals and ecosystem activity together, the leader can confidently propose supplementing cold prospecting with outreach to people already interacting with the brand, organizing team effort around real engagement signals instead of assumptions.

Prompt

Look into HubSpot CRM data for these months: [Insert Months]

For each month, return:

Pipeline value (total deal amount for deals created in that month)

Number of deals created in that month

Compare the months and report the month-over-month differences for both metrics, and clearly state which months are trending upward vs downward.

Then look into the LinkedIn Company Page data source for the same months [Insert Months]

For each month, return:

Total likes on posts published in that month

Total comments on posts published in that month

Compare the months and report the month-over-month differences for likes and comments, and clearly state which months are trending upward vs downward.

Finally, build a dashboard with:

Bar chart 1: monthly HubSpot pipeline value [Insert Months]

Bar chart 2: monthly HubSpot deals created [Insert Months]

Bar chart 3: monthly LinkedIn total likes [Insert Months]

Bar chart 4: monthly LinkedIn total comments [Insert Months]

Use the months in chronological order and label each chart clearly. Set the bar-chart to show weekly changes, not daily.

Andrej’s tips and best practices

“When performance is flat, that’s your signal to supplement.” 

If pipeline volume and value are hovering at the same level month after month, growth won’t happen by repeating the same activities. Flat trends are not neutral – they’re a cue to test a complementary motion.

“Validate new ideas against multiple signals.”

Before expanding prospecting, compare core revenue metrics with audience engagement. If engagement is strong but pipeline is stagnant, the issue may not be awareness – it may be activation.

“Organize your team’s time around daily activity patterns”

Monthly trends show direction. Daily engagement reveals timing. When you understand when comments and interactions spike, you can align outreach to moments when prospects are already active.

“Always be ready to answer: What are the next steps?

Analysis should lead to action. Leaders should be able to explain not only what is happening, but what will change because of it.

Summary

Teams managing the post-sales side of the business often struggle to understand where they’re losing upgrade opportunities. The data exists in the CRM, but it’s split between deal and company properties, making it hard to spot patterns or explain why certain upgrades end up closed-lost.

In this example, Emil explains how you can create a merged dataset to analyze deals alongside company properties like customer lifecycle stage, channel, and others. 

With this context, post-sales teams can quickly see which types of customers are most associated with lost upgrade opportunities, and can prioritize follow-ups and focus effort where it’s most likely to improve expansion.

Prompt

I need to analyze the success of new customers onboarding. I’m interested in month to date progress with a comparison to the same period last month. The metrics I need to analyze are on the [Insert Dashboard name].

Here are the most important metrics:

• [Insert Metric Name]

• [Insert Metric Name]

• [Insert Metric Name]

• [Insert Metric Name]

• [Insert Metric Name]

Pull the data, do the comparison calculations, and create a simple comparison table. Add a few bullets below it summarizing the data.

Emil’s tips and best practices

“Always analyze upgrades in the context of the account, not just the deal.” 

Upgrade outcomes are rarely explained by deal data alone. Company attributes like lifecycle stage or acquisition channel often reveal why certain opportunities are more likely to stall or be closed lost.

“Use filters to quickly understand performance across segments.”

Instead of building separate views for each segment, filters let you explore performance across customer stages, channels, and account types as questions come up. This makes it easier to see which segments matter most and where your team should focus next.

“Row-level data provides the context behind a closed-lost deal.”

High-level trends show volume, but decisions come from detail. Drilling into row-level data makes it possible to inspect the specific deals behind a number, including deal size, stage, company attributes, and other factors tied to lost upgrade opportunities.

Summary

Marketing leaders are constantly asked how leads and marketing-generated pipeline are pacing. The data exists, but answering those questions often requires digging through multiple dashboards, identifying the right custom metrics, comparing time periods, and manually summarizing the findings. What should be a quick executive update can easily turn into 30 to 60 minutes of work just to explain whether performance is up or down and why.

This example shows how you can use Genie, our AI analyst, to answer “Are we on track?” and “What’s causing this shift?” in minutes. That way, you can respond faster to executive updates and make more confident decisions.

Prompt 

We are going to pull a weekly Marketing Pipeline performance report. The custom metrics you should look at, from my Marketing Pipeline Overview Dashboard, are:

• [Insert Metric Name]
• [Insert Metric Name]

• [Insert Metric Name]

• [Insert Metric Name]

I would like to know the following:

The numbers for this month (through yesterday) for the above metrics.

How am I pacing this month versus the previous period in the month prior

How the last 7 days (through yesterday) compare to the 7 days prior

Pull the data, do all calculations for me, and provide a simple comparison chart for each metric + a few-bullet summary.

Ali’s tips and best practices

“Start with the outcome you need, not the metric name.”

When you frame your question around business intent – such as pacing, comparison period, or performance by source – you focus the analysis on decisions, not just data retrieval. That clarity leads to faster, more useful answers.

“Compare periods automatically to filter attention.”

Looking at current performance without historical context creates noise. Comparing against the previous month immediately shows whether the change is meaningful and where to focus.

“Always follow volume with source.”

Total leads or pipeline only tell you what happened. Breaking performance down by original source explains why it happened and where to double down or course correct.

Summary

Month-over-month sales results rarely explain themselves. Revenue can drop while bookings rise. Activity can increase while closed-won performance declines. Without comparing pipeline, stage progression, deal amount, and deal volume together, sales leaders are left guessing whether the issue is pricing, qualification, execution, or simple volume. That uncertainty slows down decisions and leads to broad, unfocused coaching.

This example shows how you can use Genie, our AI Analyst, to quickly analyze revenue, pipeline, and deal stage, so your coaching becomes specific and actionable.

Prompt 

I need to analyze last month’s results compared to the previous month, [Insert Month] vs. [Insert Month], February vs January. 

The metrics I care about are: [Metric 1], [Metric 2], [Metric 3], etc..

For each metric, tell me last month’s value, the value for the previous month, and the percentage change. 

Summarize results in a comparison table and highlight which direction performance moved.

Pull the data, do all calculations for me, and provide a simple comparison chart for each metric + a few-bullet summary.

Zorana’s tips and best practices

“Always separate volume problems from pricing problems.”

A revenue drop can come from smaller deals, fewer deals, or both. Comparing deal amount and deal count side by side removes ambiguity and prevents misdirected coaching.

“Drill into pipeline before you drill into people.”

Start with pipeline-level changes to see where the shift occurred. Only after identifying the segment should you move into stage-level or rep-level conversations.

“Use month-over-month comparison as your first filter.”

Period comparisons highlight meaningful change. Once you see what moved, you can investigate why it moved. Without that comparison, analysis becomes guesswork.

“Every metric change should lead to a specific conversation.”

If closed-won volume declines while average deal size increases, the coaching conversation should focus on progression and close rates, not discounting or pricing strategy.

Summary

Sales forecasting often turns into a confidence exercise built on incomplete context. When pipeline data lives across a CRM, spreadsheets, and scattered notes, leaders are forced to piece together a number that sounds solid but is largely driven by instinct. Without understanding how much pipeline is truly qualified, and whether sales activity is keeping pace with demand, it’s difficult to produce a forecast that executives can trust or use for meaningful planning.

This example shows how combining new signups, call activity, active pipeline value, and lead quality scores creates a forecast grounded in probability instead of optimism. By segmenting pipeline by qualification level and applying conversion assumptions, the projection becomes explainable and defensible. Just as importantly, the analysis surfaces operational gaps, such as outreach not keeping up with top-of-funnel growth, turning forecasting into a forward-looking planning tool rather than a backward-looking guess.

Prompt 

I need to analyze the total number of new signups to our platform, and call activity this month. I want to get the next month’s forecast based on the PQL and MQL score of active deals.

Here are the most important Metrics:

– New signups

– Sales Calls logged

– Sales deals created

– Deal value

Pull the data and add a few bullets below it summarizing the data.

At the end visualize the Active deals value on a Table.

Gino’s tips and best practices

“Don’t forecast total pipeline, forecast qualified pipeline.”

Not all open deals convert at the same rate. Segmenting pipeline by lead quality and applying different conversion assumptions produces a forecast rooted in probability, not optimism.

“Use activity-to-funnel ratios as an early warning signal.”

When calls per signup decline, outreach isn’t keeping up with demand. That gap often shows up later in conversion or revenue. Monitoring these ratios helps teams correct course before it impacts results.

“A good forecast should change your behavior.”

The value of forecasting isn’t just accuracy. It’s clarity on what to do next. When leaders can connect pipeline quality and activity levels to revenue expectations, they can set realistic goals and identify performance gaps early.