Salesforce Dashboard for Campaign Performance and Client Reporting

Leads represent individuals or businesses that have expressed interest in your client’s product or service. These prospects are a critical metric for tracking how effectively a campaign is driving interest and attracting potential new business.

A high number of leads often indicates that targeting strategies are working. However, note that it’s also important to evaluate quality and avoid flooding sales teams with unqualified prospects. Conversely, a low number of leads may mean improvements are needed (e.g., more specific messaging or increasing ad spend).

MQLs are potential customers who have come through the pipeline via your client’s marketing efforts. At this stage, they’ve shown enough interest or engagement to be considered for further nurturing by the marketing team, but are not quite ready for sales outreach.

Monitoring MQLs helps agencies assess the quality of leads being generated. A high number suggests that your client’s marketing campaigns are reaching the right audience and resonating with potential buyers. Conversely, a low number of MQLs signals a need to refine messaging, adjust targeting, or revisit the offers being promoted.

SQLs are potential customers who have been vetted and deemed as serious prospects by the sales team. Unlike MQLs (who show initial interest), SQLs have taken actions that suggest they’re closer to completing a purchasing decision. Therefore, they’re high-priority targets for conversion by sales reps.

Tracking SQLs helps agencies fine-tune campaigns, ensuring the right prospects are moving through the pipeline efficiently. A high number of SQLs reflects successful lead nurturing between marketing and sales, which demonstrates clear value to clients.

On the flip side, low SQL numbers may reveal gaps in lead qualification or misalignment in the funnel. To fix this, focus on optimizing the lead handoff process, refining qualification criteria, and enhancing communication between teams.

Opportunities refer to potential deals that are actively being pursued by the sales team. These qualified prospects have moved past the initial interest stage and are now seriously considering a purchase. Therefore, this metric is a key indicator of future revenue.

Reporting on opportunities allows your agency to demonstrate the progress of client campaigns. A high number means your client’s marketing efforts are driving prospects deeper into the sales funnel, creating more chances for conversion. To address a low number, consider refining the lead nurturing process. Also, focus on addressing any pain points that prevent these serious prospects from converting.

Expected revenue refers to the projected income from deals that are in the pipeline but not yet closed. It’s calculated by multiplying the potential deal value by the probability of closing, giving agencies a clear forecast of future revenue streams.

A high expected revenue is an ideal scenario–it shows that your client’s sales funnel is packed with valuable opportunities. It’s also useful to create accurate financial projections and plan ahead.

That said, a low number suggests that the total pipeline may need more attention. It could also mean placing more focus on attracting qualified leads.

Closed deals represent successful sales that have been finalized, which results in generated revenue. These deals reflect the culmination of all marketing and sales efforts, and by extension, your agency’s ability to drive tangible results.

A significant number of closed deals indicates that your client’s campaigns are driving high-value conversions. However, a low number of closed deals may indicate a disconnect between the opportunities generated and the sales team’s ability to drive conversions.

This could suggest an ineffective sales follow-up, poor lead qualification, or a mismatch between prospects’ needs and the solutions being offered.

Amount won refers to the total revenue generated from deals that have been successfully closed. This metric reflects the financial outcome of all completed sales efforts, which is a tangible measure of your client’s growth.

If your client generates a significant amount of revenue, it means that their opportunities actually convert into substantial outcomes. It also reaffirms that there’s a healthy interest in their product or service. However, a low number may suggest that leads are entering the pipeline without converting. It could point to a few things, like friction in the sales process that prevents leads from moving forward.

Amount lost refers to the total value of deals that were not successfully closed, representing missed revenue. In other words, this metric highlights potential income that didn’t materialize, making it a valuable learning opportunity for both clients and agencies.

Use this data to analyze where deals are slipping through the cracks. It may help your agency identify patterns, potential causes (e.g., a slow follow-up process), and reduce future losses.

Closed deals naturally leads to new customers, which refers to individuals or businesses that have successfully completed the buying process (i.e., they’ve transitioned from prospects to paying clients). They’re often an end goal of any marketing and sales funnel, providing a direct measure of revenue.

This metric is a clear indicator of how well your client’s efforts convert leads into actual customers. A high number means the sales funnel is functioning smoothly, effectively turning SQLs into buyers. A low number suggests issues further down the funnel, possibly with sales follow-ups or misalignment in targeting. Use this data to pinpoint bottlenecks and optimize existing processes.

Conversion rate measures the percentage of prospects who take a desired action out of the total number of potential leads. It’s a direct indicator of whether a campaign or sales efforts are effective at turning interest into tangible results.

Tracking this metric helps agencies ensure that clients consistently hit sales targets. A high conversion rate signals that strategies are well-aligned with audience intent and drive meaningful engagement. To fix a low conversion rate, focus on optimizing follow-ups and offering a clear value proposition.

To present a visual representation of progress towards sales and marketing targets, try the goal tracking feature. It gives a clear, measurable view of performance, allowing both you and your clients to stay aligned on milestones.

By consistently highlighting goal progress to dashboard viewers, you’ll provide valuable context to client data, which helps demonstrate the true value of your services. It also helps Sales Managers make informed decisions (e.g., ensuring adequate resource allocation to nurture high-value prospects). This efficiency fosters trust, ensuring your clients feel confident in their sales strategy and your ability to drive results.