Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Query to find Failed imports

  • 1.  Query to find Failed imports

    Posted Jul 02, 2019 11:07 AM
    I am on a roll today! :)
    ok- I am currently working on an import for marketing. Only 200 names were imported as leads as the other 1,100 failed (due to being a duplicate in CRM already). Is there a way to run a query to pull up the failed names so I can add a campaign name to those that already exist? I know they can just keep the current spreadsheet and run their campaigns from the list instead of using CRM but that seems to defeat the purpose. I would like to be able to include those 1,000+ already in CRM with the campaign code so they are also included in future mailings. I just dont know if it is possible? I know I can pull the imports I ran today but that will only give me the 200 that went through.

    any thoughts?

    Heather L
    Academy - Online Interactive Learning from Experts

  • 2.  RE: Query to find Failed imports

    Posted Jul 02, 2019 10:29 PM
    Hi Heather,

    In the Data Imports list, when you open the current import record. On the left side you should be able to see the failed records link. It would open the list of failed records. Let me know if that does not work.

    Sunil Raheja
    Aha Apps
    Glen Allen VA

    Academy - Online Interactive Learning from Experts

If you've found this thread useful, dive deeper into User Group community content by role