Why Qualified Leads in Ads Manager Does Not Match Your PMA Report

Why Qualified Leads in Ads Manager Does Not Match Your PMA Report

Info
If Meta's Ads Manager shows a Qualified leads number that you cannot find or reproduce in your report, this article explains where that number comes from, how to rebuild it with a calculated field, and how to stop your lead columns from splitting apart in the first place. Applies to the Facebook Ads connector on all plans.

What Is Actually Happening

Meta lets you connect your CRM to a Meta dataset and then group the lead statuses it sends back into sales funnel stages: some count as "positive" stages, some do not. Ads Manager adds up the positive ones for you and shows a single tidy column, commonly called Qualified leads.

Your PMA report receives the raw ingredients rather than that finished total. Each lead status arrives as its own column, named with the exact text your CRM sent (custom events you configure in Facebook are included in the Facebook Ads connector automatically). So you might see five columns with "Qualified" in the name where Ads Manager shows one, and none of your five is the total.

Here is the part that surprises most people: if your CRM sends back slightly different spellings, each spelling becomes its own column. "Qualified", "qualified", and "Qualified Lead" look like the same thing to you, and like three separate things to your report.

Rebuild the Total with a Calculated Field

  1. Open Ads Manager and go to Configure sales funnel stages.
  2. Write down every lead status you put in a positive stage. This is the list Ads Manager is adding up.
  3. In your report, add the columns matching those statuses.
  4. Create a calculated field that adds those columns together. Wrap each field in IFNULL(field, 0) so blank rows do not empty the total.
  5. Name it something clear, like Qualified Leads (total).
  6. Compare it to Ads Manager. It should land within a lead or two of the Ads Manager figure.
Notes
Meta counts each lead once in its roll-up, even when that lead passes through more than one positive stage (for example, a lead marked Interested and later Converted). A calculated field that sums the stage columns counts that lead once per stage, so your total can sit slightly above Ads Manager. That small gap is expected; it means a few of your leads advanced through several positive stages.

If the Numbers Still Do Not Match

Check your date range and attribution window against the Ads Manager view first. Ads Manager and your report can use different attribution settings by default, and that alone produces a gap that looks exactly like this one.

Then check for a status you missed. A column named something like SQL - Qualified is easy to skip when you are scanning for the word "Qualified" on its own.

If a status you grouped into a positive stage does not appear as a column in your PMA field list at all, confirm the event is visible in Meta Events Manager and has fired within your report's date range. Custom events configured in Facebook are included in the connector automatically. If the column still does not appear, contact our support team.

The Permanent Fix: Clean Up Your CRM Statuses

The calculated field solves your report. It does not stop new spellings appearing next month and quietly falling outside your formula.

If you can, standardize the lead status values your CRM sends to Meta so that one real stage means one exact string. Everything downstream (Ads Manager, your report, your formula) then agrees automatically, and you stop maintaining a list.

One thing to keep in mind: if a new status spelling appears later, Meta's roll-up updates itself once you assign the new status to a positive stage, but your calculated field will not. You would need to add the new column to your formula.

What You Will See in Your Report

You will see one column per distinct lead status your CRM returned, with the status name in the column label. You will not see a Qualified leads column, because that total is calculated inside Meta rather than sent to reporting tools as a field.

The individual numbers are accurate. It is the grouping that has to be recreated on your side.

Need a hand building the calculated field? contact our support team.

    • Related Articles

    • LinkedIn Business Manager July 30, 2025 Migration to LinkedIn Ads

      This guide will help you migrate your Revenue Attribution Report (RAR) data access from the LinkedIn Business Manager connector to the LinkedIn Ads connector. This migration is required to maintain access to your RAR data after July 30, 2025. ...

    • Google Ads Data Connector User Guide

      Google Ads is a powerful online advertising platform that allows businesses to reach potential customers across Google's vast network. This guide will walk you through how to connect your Google Ads data to Power My Analytics, create reports in Data ...

    • LinkedIn Ads Data Connector User Guide

      LinkedIn Ads is a powerful platform for B2B marketing, lead generation, brand awareness campaigns, and revenue attribution. This guide will help you connect your LinkedIn Ads account to Power My Analytics, enabling you to create comprehensive reports ...

    • Connector Error: Can’t Mix and Match Fields from Different Tables

      This article will help you to solve the following Data Studio error: "Community Connector Error: PMA Error | Can't mix and match fields from different tables" "Invalid configuration: Invalid combination of metrics and dimensions" Cause You will ...

    • Facebook Ads Data Connector Limitations

      This article covers the limitations, considerations, and workarounds for working with Facebook Ads data in Power My Analytics. For instructions on connecting your Facebook Ads account and creating reports, see the Facebook Ads Data Connector User ...