What does "Incorrect Data" mean for Named Account Import?

Forum|Forum|3 years ago
December 23, 2022
1 reply
3918 views

Hi Community Experts!

I'm playing around in our Target Account Management for better understanding before we set it up in our new instance, and when importing Named Accounts (downloaded them from our CRM), only 65 of my 202 accounts get imported. When I download the failures/errors, they are all listed with "Incorrect Data".

Does anyone know WHAT data is incorrect? There were no issues with mapping data, and all the fields I imported look fine to me! However, I'm open to the fact that something might have been mis-added, so I'd love to make sure I'm aware of that for the future.

Any help is appreciated 😀

Michelle

Marketo

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

Darshil_Shah1

Community Advisor and Adobe Champion

This most likely means that one or more field values in the list import sheet for the failed records have data present in the wrong format (e.g., string in a boolean field) i.e., the data/format in the spreadsheet does not agree with the mapped field's data type. Are you able to provide one example of each of the rows that were successfully imported and the ones that failed? Of course, please update the data in the rows with sample values (of the same data type and format) before adding them here. Thanks!

michellechopin

Author

Community Advisor

That makes sense - just not sure why the error report is so vague, when others are much more specific i.e. lead exists in another partition, invalid email address. It would be much more helpful to know what specifically is wrong, especially in larger lists like this (what if they're all different?!).

Here are two samples of data for you - the first line is a failure, the second is a success:

name	employees	industrycode	city	stateorprovince	country	websiteurl	revenue
Name	XX,XXX	Retail	Austin	TX	US	www.name.com	$X,XXX.00
Name			Oak Brook	IL	US

Looking at these side-by-side, I wonder if it's the numerical values for Employees and/or revenue having commas in them? Those Named Accounts that got imported all seem to be missing that data in our system, but those that failed all have one or both of those data points. Should they go in as just numbers? i.e. no commas, no dollar signs etc.? (the extra decimals on the revenue data are added by Marketo I believe).

If that's the case, I can make that fix easy and re-import these failures. And of course, any additional insight is always appreciated 😀

Michelle

Darshil_Shah1

Community Advisor and Adobe Champion

I'm with you on the suggestion that the error doc should include what specifically went wrong during the LI process, just like the lead import error doc does. Probably, since not a lot of users add/create named accounts by importing a list that Marketo hasn't yet updated the account list import process to include the more specific failure reasons (something to be included in one of the future releases soon).

Looking at these side-by-side, I wonder if it's the numerical values for Employees and/or revenue having commas in them? Those Named Accounts that got imported all seem to be missing that data in our system, but those that failed all have one or both of those data points. Should they go in as just numbers? i.e. no commas, no dollar signs etc.? (the extra decimals on the revenue data are added by Marketo I believe).

Thanks so much for providing the examples! You're the best. I too think that the comma (,) and the dollar ($) characters are putting the list import off. You'd want to format the Revenue and Employees columns so that (,) is not added to the values (un-check the (,) separator option in the format cells option in excel). Hope this is helpful. Let us know how it goes!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded