Total count difference between list & report

Marketing & Content Hub Lists, Lead Scoring & Workflows
,
1

I’ve come across an issue I can’t seem to wrap my head around. I created a report that with 2 filters: Marketing Contact Status is any of Marketing Contact & excluded GDPR countries using ‘is not equal to any of’. Now when I recreated this in an active list I got a very different number. Report = 17k vs List = 13k.

Which one is accurate, am I missing something?

2

Hi @SmartListGhost,

Can you please share screenshots of

  • list filters
  • report filters
  • data sources selected in the report

Best regards

3

Report Filter View.png
Report Filter View.png1897×790 148 KB

Report
List Filters.png
List Filters.png378×735 74 KB

List

Here they are, thanks!

4

@SmartListGhost first thing I’d try is to adjust the list filters so that the country filter checkbox for “or is empty” is checked, this might (unintuitively) be implicit in the report filters. The rest of the filters do seem to be identical.

5

That did it, thanks a ton @karstenkoehler!!

6

I am also facing a similar issue. I am maintaining a dashboard where I am maintaining a dashboard to check the lead status and opportunity status on a daily basis , but when i check the contacts object with the same filter there is always a difference of 1 or 2 figures , why is this

7

Hi @SK1 and welcome, we are so glad to have you here! :raising_hands:

Thanks for sharing your experience with the HubSpot Community!

To help us look into this, could you share what specific filters you’re using on both the dashboard and the contacts object? Which data source is used on the report?

Are there any properties or lifecycle stages you’re comparing between the two?

Also, have you refreshed the report when comparing the two data?
New data takes 10-15 minutes to appear in reports. For example, if you create a new contact that meets a report’s criteria, the contact will not appear in the report for 10-15 minutes.

Now, I’d love to hear from our Top Experts: Hi @karstenkoehler and @danmoyle do you have suggestions that could help @SK1, please?

Thanks so much and I hope that you’ll have a nice day!
Bérangère

9

Thank you for tagging, @Berangere.

@SK1 happy to assist - I would have to see the exact full list of segment filters (screenshot) and the same for the report filter criteria (another screenshot) and the selected data sources for the report (another screenshot).

Once you share these, I’m happy to identify the cause.