. This formula will identify the duplicates as they will have ‘Same’ within the ‘email status’ column.
Posted: Mon Dec 23, 2024 10:25 am
Tip: To avoid having to manually remove duplicates, always use ‘CRM ID’ when importing data!
You can find every single one of your export and import requests by heading to Pardot Settings > Export or Pardot Setting > Import.
This will show you whether they are in progress or have been finished. You will also be able to see how many prospects have been created, updated and how many errors have been found (which is great for sync error updates!).
Screenshot of CSV imports
You can utilise both the import and export feature when updating duplicated prospects. This will often pop up in sync errors but is easily fixed.
1. Follow the export prospects steps above
2. Once the CSV has downloaded, open the CSV file then insert the ecuador phone number example following formula in a new column called ‘email status’ next to the email column:
=IF(A2=A3,”Same”,”Different”)
Ensure the formula above references the email column in the CSV. (e.g. A2=Email column).
4. You will also need to merge the CRM Contact ID and CRM Lead ID into one column.
5. Then import the prospects following the steps outlined above!
Note: this formula and process works in Google Sheets, in Microsoft Excel you will be able to highlight the duplicates.
If you have any questions about the processes above or need help with auditing the health of your Pardot, feel free to get in touch with the team here at MarCloud Consulting.
Share
Hollie Fitzpatrick
Hollie Fitzpatrick
Hollie joined the MarCloud team with extensive B2B marketing experience. With a keen interest in marketing technologies, they strive to find the best solution to increase the efficiency and quality of marketing campaigns through rigorous testing and data analysis. A certified Pardot consultant, Hollie spends her days at MarCloud being fully solutions-focused.
More by Hollie Fitzpatrick
Featured resource
You can find every single one of your export and import requests by heading to Pardot Settings > Export or Pardot Setting > Import.
This will show you whether they are in progress or have been finished. You will also be able to see how many prospects have been created, updated and how many errors have been found (which is great for sync error updates!).
Screenshot of CSV imports
You can utilise both the import and export feature when updating duplicated prospects. This will often pop up in sync errors but is easily fixed.
1. Follow the export prospects steps above
2. Once the CSV has downloaded, open the CSV file then insert the ecuador phone number example following formula in a new column called ‘email status’ next to the email column:
=IF(A2=A3,”Same”,”Different”)
Ensure the formula above references the email column in the CSV. (e.g. A2=Email column).
4. You will also need to merge the CRM Contact ID and CRM Lead ID into one column.
5. Then import the prospects following the steps outlined above!
Note: this formula and process works in Google Sheets, in Microsoft Excel you will be able to highlight the duplicates.
If you have any questions about the processes above or need help with auditing the health of your Pardot, feel free to get in touch with the team here at MarCloud Consulting.
Share
Hollie Fitzpatrick
Hollie Fitzpatrick
Hollie joined the MarCloud team with extensive B2B marketing experience. With a keen interest in marketing technologies, they strive to find the best solution to increase the efficiency and quality of marketing campaigns through rigorous testing and data analysis. A certified Pardot consultant, Hollie spends her days at MarCloud being fully solutions-focused.
More by Hollie Fitzpatrick
Featured resource