topic Betreff: Finding none-exported cells in CDM schema in SAS Customer Intelligence

Finding none-exported cells in CDM schema

Eitan123 — Sun, 29 Aug 2021 14:20:49 GMT

Hey,

My client wants a simple SQL querry to link cells which were not exported to any communication in a diagram in CIS 6.6, to the campaigns in which they're in (the campaigns were executed).

I read that CDM.CI_MARKETING_CELL is the way to go, but I could only find cells which are connected to a communication.

Is there any table in CDM to find those that aren't being exported?

Re: Finding none-exported cells in CDM schema

JamesAnderson — Sun, 29 Aug 2021 23:29:11 GMT

Hello,
A marketing cell is by definition one that is connected to a communication node, and as a whole the CDM only records cells that are marketed to (not every cell in a diagram of a campaign). If you want to capture this information you would need to create a dummy communication node and connect cells to it.
Regards
James

Betreff: Finding none-exported cells in CDM schema

Soran — Mon, 30 Aug 2021 06:16:55 GMT

A possible solution could be the maextract-functionality https://communities.sas.com/t5/SAS-Communities-Library/How-to-extract-SAS-Customer-Intelligence-Objects-from-your-SAS/ta-p/301245 .

With that functionality you could extract the full metadata information of a campaign, including used nodes, data items, values, etc.

Betreff: Finding none-exported cells in CDM schema

Eitan123 — Mon, 30 Aug 2021 07:43:07 GMT

Thank you, this helps me with a different issue! 🙂