I want to import custom object to test - can someone check my logic?

Question

Hi everyone. As a one-person Marketo "department", I am learning new things about the instance I inherited. One is that our CRM and Marketo do not communicate - there is a daily file transfer that appears to be customer data (name, email, etc) and custom object (type of account, when opened, etc) that captures any new customers and places them into a workflow (existing Onboarding Journey). Our I.T. Department sends me spreadsheets for both as a way to check the data transferred if I want or need.

That said, I have completed a new customer onboarding journey that I'd like to test using fake test data that mirrors the two spreadsheets.

The field that ties both spreadsheets together is called, CIF, and I think I need to exclude this from a list import of the customer data. When I upload the custom object spreadsheet, I will need to include CIF.

Needless to say, I am a bit apprehensive in uploading the spreadsheets and testing the data. On its surface, does this sound like I am on the right track? To be extra careful, I suppose I could create a filter that includes only the email addresses of the test data. I am most worried, however, of inadvertently creating an error to the existing custom object and its data.

Any feedback or advice is most welcome. Thank you in advance for reading my post.

Cheers

SanfordWhiteman · Accepted Answer

there is a daily file transfer that appears to be customer data (name, email, etc) and custom object (type of account, when opened, etc) that captures any new customers and places them into a workflow (existing Onboarding Journey).

Not sure what you mean by “file transfer” as there’s no such thing as a file that gets uploaded directly to Marketo, e.g. via SFTP. Any import must go through the REST API, either Bulk Import or one of the paginated API endpoints.

Overall, you haven’t provided enough information for a meaningful response. We don’t even know the Custom Object schema (dedupe fields, link fields, field types)!

What we can say, though, is there’s no reason at all to use your production Custom Object. You should create a new Custom Object, call it Customer Data Testing, with the same schema as the production one. Then use that for testing as it cannot have side effects, of course assuming you only link the test objects to leads flagged as test leads.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded