The number that shows up on the Subscriber Snapshot is the correct number that came from our client's CRM database. But when I export the bounces, that custom field exports a truncated number.
Joe Smith's record ID that we uploaded and that shows in his snapshot is: 1054151204044455107
But when we export the subscriber records, his number gets changed to: 1.05415E+18
How do I get the exported data to be exactly what's in the CM system and shows on the snapshot page?
OK, I figured it out. Export to .txt file and using text wizard in Excel, change that field type to 'text'. THEN open the document. Only took me an hour to figure out that I can't change the fields to 'text' type once the file is already pulled through Excel. The numbers don't go back.
Thanks for the update Julia, that's going to come in handy for people.
From Australia to Zimbabwe, and everywhere in between, companies count on Campaign Monitor for email campaigns that drive real business results.Get started for free