topic Re: Exclude the Client in a campaign once it already received communication 5x. in SAS Programming

Exclude the Client in a campaign once it already received communication 5x.

otepalborida — Wed, 08 Apr 2020 07:19:32 GMT

Hi SAS Community,

Good day!

I have some logical scenario needed, i want to count then exclude the clients in the sms campaigns once they already received sms communication five times already (x5) within the span of their offer validity.

Here are the tables and columns where the communication is being saved, just in case

CI_CONTACT_HISTORY

- CUID

- CONTACT_DT

- CONTACT_HISTORY_STATUS

SMS_OUTPUT_LOAD

- CUID

- PROCESSED_DT

Thank you.

Regards,

Otep

Re: Exclude the Client in a campaign once it already received communication 5x.

Kurt_Bremser — Wed, 08 Apr 2020 07:53:05 GMT

Counting item can easily be done in SQL:

proc sql;
create table exclude as
  select
    cuid,
    count(*) as count
  from ci_contact_history
  group by cuid
  having calculated count > 4
;
quit;

For more detailed code, supply example data in usable form (data steps with datalines), and the expected result from that.

Re: Exclude the Client in a campaign once it already received communication 5x.

otepalborida — Wed, 08 Apr 2020 11:29:25 GMT

Hi @Kurt_Bremser , do you have an example wherein the logic can be used in the campaign diagram in SAS Customer Intelligence Studio.

Re: Exclude the Client in a campaign once it already received communication 5x.

Kurt_Bremser — Wed, 08 Apr 2020 11:33:45 GMT

No, we don't use that. I am a pure coder.