Marketo Lead ID not Appearing in All Columns Export

[eguard]

Hello all. I'd like to be able to export our Marketo database using the All Columns export option. However, when using this option, the Marketo ID seems to disappear from the resulting file. When choosing Visible Columns, the Marketo ID is correctly displayed in the resulting export file. Does anyone know why this same ID field is not exporting in the All Columns option?

Thanks in advance!

[SanfordWhiteman · Accepted solution]

Lead ID can surprise you by being hidden in some places. We recommend having a Lead ID Mirror field, maintained via daily batch Change Data Value, to ensure it’s always present.

[eguard]

I appreciate the clever solution. Thank you!