SOLVED

Re: Is it possible to retrieve a CSV File that Was Used In an Import

Go to solution
Anonymous
Not applicable

Is it possible to retrieve a CSV File that Was Used In an Import

I would like to be able to retrieve original CSV files that were used in an upload to Marketo (in this instance in particular it was a Member List Import).

Is this list cached and can it be accessed? If this is possible, from where can these files be retrieved?

1 ACCEPTED SOLUTION

Accepted Solutions
Grégoire_Miche2
Level 10

Re: Is it possible to retrieve a CSV File that Was Used In an Import

Hi Rob,

No, this is not possible, at least not by yourself. May be the Support can help.

What are you trying to achieve ?

-Greg

View solution in original post

5 REPLIES 5
Grégoire_Miche2
Level 10

Re: Is it possible to retrieve a CSV File that Was Used In an Import

Hi Rob,

No, this is not possible, at least not by yourself. May be the Support can help.

What are you trying to achieve ?

-Greg

Anonymous
Not applicable

Re: Is it possible to retrieve a CSV File that Was Used In an Import

Thanks Greg.

This need was raised because we imported a csv file with values transposed into incorrect columns (likely because of how the csv was opened in Excel, etc.). This updated our records with information from the wrong fields.

The easiest way I could think of to correct the issue would be to get access to the original csv as read in by Marketo to find the transposition error, reverse it and re-upload it.

I know that Pardot had the ability to view an import log at least of import results but couldn't find the same functionality in Marketo.

Do you have any other tricks for reversing a list import / record update (without re-uploading the corrected csv)?

Jenn_DiMaria2
Level 10

Re: Is it possible to retrieve a CSV File that Was Used In an Import

You could pull a Smart List of "Data Value Changed" using date constraints, then export the resulting list, transpose, and re-upload. You'd have to use two "Data Value Changed" filters and select ALL filters. See below:

Screen Shot 2016-04-08 at 10.00.11 AM.png

Jenn_DiMaria2
Level 10

Re: Is it possible to retrieve a CSV File that Was Used In an Import

You might be able to rig a Smart List to get you a downloadable file resembling the original CSV. Something like:

  • Original Source Type = List Import
  • Created Date = When the original list was uploaded (if you know this)

However, this assumes the names weren't originally in your database. You could also use:

  • Was Added to List = Date added to list

Neither of these solutions may be 100% accurate, but can get you fairly close.

Grégoire_Miche2
Level 10

Re: Is it possible to retrieve a CSV File that Was Used In an Import

Hi Rob,

There are various ways of doing this.

One is to use the data value changed, as proposed by Jenn, but adding source and reason constraints to limit to those DVC that were due to your import.

The other is to use the API and export all the DVC. The interest of this is that it will give you the new and previous values for each, so the reverse will be quite easy. You will just have to reimport the previous values to override the new ones.

-Greg