Take a look at the Contact Washing Machine. There is an action named "Propercase". This will capitalize the first letter of each word and lowercase all other characters. Works great for most contact fields like First Name, Last Name, and Company Name.
Let me know if you need some help setting this help.
I actually have never used that before! I see it on our instance though. Do I just need to create a mass segment of all of our contacts, create a multi-step campaign, and run them through there?
Thanks for your help.
Well first time for everything!
Yep, you pretty much have the right idea. Instead of the campaign canvas, I would opt to use the program canvas so that contacts can be checked and reformatted daily. If you require the check and reformatting to happen more than once daily, you can use a Program Builder feeder and Campaign Canvas to accomplish.
Also, be sure to run a few tests within the Contact Washing Machine to ensure that the "Propercase" action is giving you the appropriate formatting.
As an added note:
While the Program Canvas is fast, if you have a lot of contacts (say 100.000+) you may not want to cram all your contacts through it every day.
Run it once across your entire database initially, then after that, add a criterion to your segment of Contact Field Last Modified = today, to lessen the burden on the program a little. Or you could use Form processing steps to send form submissions to the program canvas. Depending on how many (or little) forms you have, this may be faster.
Yes it is there. But I don't know how to run it or set up the configuration data cleansing questions that are required in the box. Is there a tutorial or something that I can look at?
You'll want it to look something like this:
1. Drop the Contact Washing Machine on your canvas, open it and click the pencil icon to edit its configuration.
2. You can add multiple steps in the Washing Program, basically. If you want to cleanse first and last name, that's 2 steps, one for each field.
3. You can name the step for clarity if you want. In the Source field, select the First Name field.
4. You can leave Condition empty.
5. In the Action field, select Propercase. This will capitalize the first letter of the field value, and lower-case the rest. i.e. QUINCEY will become Quincey.
6. For Destination, select the First Name field again, because we want the outcome value to populate the first name field again.
7. Add another step for Last Name, and repeat 3-6.
As for the canvas, it'd basically look like this:
For the first time you run the program, you can set the segment to something like First Name and Last Name is not blank. Then, once it's gone through all of your contacts (you'll see the number of added contacts next to the segment once it runs), modify the segment to add "Last Modified Date is within the last 1 day" or something along those lines. This will make it so only the records who have been modified in the last day will go through the program on every following cycle.
Or, like I said before, you could add "Add to Program Canvas" steps on each form that feeds data into your Eloqua, to make sure the data is properly cleansed. This may take some time to set up depending on the amount of forms you have, though.