Deleted Leads Showing Up in Reporting

Forum|Forum|11 years ago
April 29, 2014
3 replies
1447 views

Hi everyeone,

We've deleted a lead a week ago both from Marketo and our CRM (Salesforce), but the lead still shows up in reporting.
Wondering if you've experienced this issue or if there is a setting somewhere?

Thanks,
Alex

Marketo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

A

Anonymous

Which reports in particular? I'm thinking it's capturing a moment in time, therefore since the lead was once in Marketo and SFDC, it's showing up in the reporting.

I noticed today that my Success Path Analyzer was showing 50k leads 'in flow' for the Lead revenue stage and I know that isn't true. There are only 40k names in our Marketo DB total so it was apparent there was an issue.

What happened is one day last week our SFDC sharing rules went haywire and dumped about 40k leads into Marketo that shouldn't have been there. By default, all new leads end up in the 'Lead' revenue stage once they are deemed 'valid' and enter Marketo. Although they weren't deleted from SFDC (they were deleted in Marketo), they are outside of the Sharing Rule logic so Marketo does not have visibility to these records (anymore).

My guess, as I mentioned earlier, is the reporting is looking at what happened in a specific time period, regardless of what happened to those records moving forward.

A

Anonymous

Kara is correct. If the report is referencing a specific time period when the lead existed in the database, it will show up in the reporting. However, you can use the smart list filters in the reporting to eliminate that lead from the report. For example, you can use "email address is not" filter to remove the lead from the report.

thanks,
Rajesh

A

Anonymous

Thanks for the insight Kara!
That makes sense - only if there was a way to correct the reporting.
After a data cleanse, deleted leads would show up pretty much across the board in count or name.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded