topic Re: Find active treatments assigned to Decision Treatment Campaign in SAS Customer Intelligence

Find active treatments assigned to Decision Treatment Campaign

dsadsad — Tue, 06 Aug 2019 06:56:14 GMT

Hi All,

I would like to know only THE active treatments(currently assigned) assigned to any particular decision treatment campaign . Is it possible through CDM data base ?

I am using the below code but it gives all the treatment codes (Current + History).

SELECT

DISTINCT TREATMENT_CD

FROM

CI_PACKAGE_X_TREATMENT CPXT

INNER JOIN CI_CELL_PACKAGE CP ON

CPXT.CONTRIBUTING_CELL_PACKAGE_SK = CP.CELL_PACKAGE_SK

INNER JOIN CI_TREATMENT CIT

ON CPXT.TREATMENT_SK=CIT.TREATMENT_SK

INNER JOIN CI_TREATMENT_EXT CITE

ON CIT.TREATMENT_SK = CITE.TREATMENT_SK WHERE CP.CAMPAIGN_CD='CAMP506094'

Thanks in Advance.

Re: Find active treatments assigned to Decision Treatment Campaign

Kurt_Bremser — Tue, 06 Aug 2019 07:13:22 GMT

What's the condition for an active treatment? Add that to the where clause.

Re: Find active treatments assigned to Decision Treatment Campaign

dsadsad — Wed, 07 Aug 2019 00:31:24 GMT

Hi Kurt ,

Thanks for you response. i am not aware of any filter in CDM data base to use to get the currently assigned treatments to decision treatment campaign.

Re: Find active treatments assigned to Decision Treatment Campaign

JamesAnderson — Wed, 07 Aug 2019 10:40:43 GMT

Hi,
I don't believe what you want (which to see an accurate reflection of what you can see in CI Studio for Treatments used in each Decision Treatment Campaign) is available in the CDM. Its important to distinguish that the CDM is a historical database that captures the outcomes of decision requests for RTDM, not a reflection of what is currently in metadata. This is evidenced by the fact that you only get a record in CI_PACKAGE_X_TREATMENT after a decision has been made, and the record will only represent the treatments in the outcome of the decision rather than the input treatments (i.e. the entire scope of all treatments used in the campaigns in the decision).
To get what you want you need to extract the information directly from metadata using the CI Integration Utilities.
Regards
James

Re: Find active treatments assigned to Decision Treatment Campaign

dsadsad — Thu, 08 Aug 2019 07:43:42 GMT

Ok , Thanks James. Will Explore CI Utilities to achieve this.