"Name" custom field (probably a very daft question!)

Please forgive me for what is more than likely a very daft question - but I've read through a few of the pages in "Help & FAQs" and I'm still stumped.

Whenever I import a new list of subscribers (via CSV file), one of the field mapping options is name. I never really understand what to pull into it - should it just be the first name? If so, why didn't Campaign Monitor call it "First Name" and set one up for "Last Name"?

I noticed that in one of the examples on personalisation / custom fields in the help section it showed First Name and Last Name as being pulled in separately, in addition to just Name... and now I'm even more confused.

How do you use it? How should we use it?

HELP. Please!

Thanks :)

Diana Diana, 5 years ago

Hi! You want to put in whatever name data you have. So if you have first and last names, put them in 1 column and import them as the Name field. Then when you're personalizing you can split them out as [firstname] (the first word of the record), [lastname] (the last word) and [fullname] (the whole record).

Hope that helps, but if it's still super confusing just let us know.


~*~~*~~*~~*~
D. Potter
Campaign Monitor
anndonnelly, 5 years ago

I've got thousands of records, it'd be a big job to combine first and last name into one column -- it's exported from our customer database. I was going to put no name, but it'd be a shame to lose this info.  Should I just add first and last as custom fields?

roshodgekiss roshodgekiss, 5 years ago

Hi Ann, you may, then reference the custom fields for personalization. Depending on how big your list is, the Excel-savvy folks in our support team could potentially help you combine the names into one column - email your list and details to support [at] campaignmonitor.com and we'll happily take a look.

All the best!


Get in touch with us on Twitter: http://twitter.com/campaignmonitor
We're also on Facebook: http://facebook.com/campaignmonitor
jeffthechef, 5 years ago
anndonnelly :

I've got thousands of records, it'd be a big job to combine first and last name into one column -- it's exported from our customer database. I was going to put no name, but it'd be a shame to lose this info.  Should I just add first and last as custom fields?

Combining Excel columns:  http://office.microsoft.com/en-us/excel-help/merge-and-unmerge-cells-HP005251021.aspx#BMmergecellcontents

In my little less Excel-savvy days, I came up with this DIY method:
1. Make a copy of the spreadsheet and delete everything but the two columns to combine
2. Export to a CSV file (Comma Separated Values)
3. Open CSV in Word
4. Use Find/Replace to search for commas and replace with nothing
5. Select all and copy from Word into new column in original Excel doc

Join 200,000 companies around the world that use Campaign Monitor to run email marketing campaigns that deliver results for their business.

Get started for free
1-888-533-8098