topic Re: Performing a coalesce in CI360 in SAS Customer Intelligence

Performing a coalesce in CI360

AaronMartin — Thu, 07 Jul 2022 09:03:16 GMT

Hi - apologies if this has been asked before, I have searched but not found anything related.

I am trying to add email seeds/sleepers (marketing team email addresses that get added to every email campaign) into CI360. There doesn't seem to be an inbuilt function for this so what I've done is created a seed list table containing name/email address/booking details etc and then loaded that into CI360. These records appear fine, and can be added to normal marketing campaigns. The issue is because the email addresses are stored outside the main email table I end up with something like this in the final export:

email	seed_email	title	forename	surname
email2		mr	guest	1
email2		mr	guest	2
	seed1	mr	seed	1

What I'd like to do is a coalesce to put the seed email into the email column. Has anyone managed to do this?

Thanks

Re: Performing a coalesce in CI360

OlafKratzsch — Thu, 07 Jul 2022 12:26:39 GMT

I assume you are using Engage: Direct and you use 2 segments in your Direct Marketing Task. One for the customers to contact and one for your seed list. Correct?

You could add a Post Process to the Direct Marketing Task that will move the values to the right columns and drops the redundant ones.

Re: Performing a coalesce in CI360

AaronMartin — Fri, 08 Jul 2022 15:19:22 GMT

Hi,

Thanks for your reply, that makes sense. I will have a look at how post processing works in CI360 and see if I can make it work