{"id":528,"date":"2016-12-11T21:05:20","date_gmt":"2016-12-11T21:05:20","guid":{"rendered":"http:\/\/corraogroup.com\/blog\/?p=528"},"modified":"2021-07-27T21:35:37","modified_gmt":"2021-07-27T21:35:37","slug":"export-salesforce-leads-contacts-import-pardot","status":"publish","type":"post","link":"https:\/\/corraogroup.com\/blog\/2016\/12\/export-salesforce-leads-contacts-import-pardot\/","title":{"rendered":"How to Export your Salesforce Leads & Contacts to Import into Pardot"},"content":{"rendered":"

Once your Salesforce connector is enabled in Pardot<\/a>, the existing Salesforce leads and contacts do <\/span>NOT automatically sync <\/b>to Pardot. You will need to export your existing leads and contacts from Salesforce into a .CSV file.<\/span><\/p>\n

Upon importing Contacts and Leads, Pardot will sync the prospect record with the existing Salesforce lead or contact record. <\/span>If Pardot and Salesforce values differ when a data sync occurs, the value of the field in Salesforce will overwrite the value of the field in Pardot, unless you set field sync to \u201cUse Pardot Value\u201d on the individual field.\u00a0<\/span><\/p>\n

<\/p>\n

Run a Report of All Salesforce Leads and Contacts<\/h2>\n
    \n
  1. Navigate to reports in Salesforce <\/span><\/li>\n
  2. Click the Object you want to run your report on (ex. All Leads) <\/span><\/li>\n
  3. Set your Date Field to \u2018Created Date\u2019 and your Range to \u2018All Time\u2019<\/span><\/li>\n
  4. Makes sure all leads have the fields: Email address and CRM ID* (This field is \u201cLeadID\u201d if you are reporting on Leads, \u00a0and the field is \u201cContactID\u201d if you are reporting on Contacts)<\/span><\/li>\n
  5. Click Run Report, remember to save!<\/span><\/li>\n<\/ol>\n

    *Note<\/strong> – if you have multiple prospects with the same email, you must import CRM ID or else it will create duplicate leads in Pardot.<\/span><\/p>\n

    \"salesforce<\/h2>\n

    Export to CSV once report is run<\/h2>\n

    Once you run the report you can press the Export Details button to export all contacts\/leads to a CSV or Excel file. Open your CSV file and make sure all leads have email address because this is the unique identifier and is required to be able to create a prospect in Pardot. Now you are ready to import your leads and contacts into Pardot! If you need help setting Pardot up, please visit our Salesforce page.<\/a><\/span><\/p>\n

    [pardot-form id=”9912″ title=”Wordpress Form”]<\/p>\n","protected":false},"excerpt":{"rendered":"

    Once your Salesforce connector is enabled in Pardot, the existing Salesforce leads and contacts do NOT automatically sync to Pardot. You will need to export your existing leads and contacts from Salesforce into a .CSV file. Upon importing Contacts and Leads, Pardot will sync the prospect record with the existing Salesforce lead or contact record. … Continue reading “How to Export your Salesforce Leads & Contacts to Import into Pardot”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":535,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[61,5,10],"_links":{"self":[{"href":"https:\/\/corraogroup.com\/blog\/wp-json\/wp\/v2\/posts\/528"}],"collection":[{"href":"https:\/\/corraogroup.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/corraogroup.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/corraogroup.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/corraogroup.com\/blog\/wp-json\/wp\/v2\/comments?post=528"}],"version-history":[{"count":16,"href":"https:\/\/corraogroup.com\/blog\/wp-json\/wp\/v2\/posts\/528\/revisions"}],"predecessor-version":[{"id":3071,"href":"https:\/\/corraogroup.com\/blog\/wp-json\/wp\/v2\/posts\/528\/revisions\/3071"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/corraogroup.com\/blog\/wp-json\/wp\/v2\/media\/535"}],"wp:attachment":[{"href":"https:\/\/corraogroup.com\/blog\/wp-json\/wp\/v2\/media?parent=528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/corraogroup.com\/blog\/wp-json\/wp\/v2\/categories?post=528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/corraogroup.com\/blog\/wp-json\/wp\/v2\/tags?post=528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}