3 Replies Latest reply on Apr 29, 2014 1:11 PM by 51282

    Deleted Leads Showing Up in Reporting

      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
        • Re: Deleted Leads Showing Up in Reporting

               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. 

          • Re: Deleted Leads Showing Up in Reporting
            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
            • Re: Deleted Leads Showing Up in Reporting
              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.