https://communities.sas.com/t5/SAS-Customer-Intelligence/CELL-Code-Information-and-Counts-Information/m-p/500838#M1025 <P>Hi,</P><P>&nbsp;</P><P>We are currently using SAS Customer Intelligence studio 6.5. We are trying to build a report based on counts for a couple of Cells.&nbsp;These are cells that are available for linking please find attached screen shots. I tried to find the information of these cells in sas common data model schema in tables&nbsp;ci_marketing_cell based on marketing_cell_cd and marketing_cell_nm and found no records related to these cells. Can you please suggest where I can find the counts that are stored related to these cells. I don't find anything in execution history tab for this campaign, this campaign is executing daily but it contains no communication nodes.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2018-10-02 at 12.40.06 PM.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/23722iFFDF84C6D5A3A817/image-size/large?v=v2&amp;px=999" role="button" title="Screen Shot 2018-10-02 at 12.40.06 PM.png" alt="Screen Shot 2018-10-02 at 12.40.06 PM.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2018-10-02 at 12.32.55 PM.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/23720iDE8241BA7F170FF2/image-size/large?v=v2&amp;px=999" role="button" title="Screen Shot 2018-10-02 at 12.32.55 PM.png" alt="Screen Shot 2018-10-02 at 12.32.55 PM.png" /></span></P> Tue, 02 Oct 2018 16:49:30 GMT vgp2 2018-10-02T16:49:30Z https://communities.sas.com/t5/SAS-Customer-Intelligence/CELL-Code-Information-and-Counts-Information/m-p/500838#M1025 <P>Hi,</P><P>&nbsp;</P><P>We are currently using SAS Customer Intelligence studio 6.5. We are trying to build a report based on counts for a couple of Cells.&nbsp;These are cells that are available for linking please find attached screen shots. I tried to find the information of these cells in sas common data model schema in tables&nbsp;ci_marketing_cell based on marketing_cell_cd and marketing_cell_nm and found no records related to these cells. Can you please suggest where I can find the counts that are stored related to these cells. I don't find anything in execution history tab for this campaign, this campaign is executing daily but it contains no communication nodes.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2018-10-02 at 12.40.06 PM.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/23722iFFDF84C6D5A3A817/image-size/large?v=v2&amp;px=999" role="button" title="Screen Shot 2018-10-02 at 12.40.06 PM.png" alt="Screen Shot 2018-10-02 at 12.40.06 PM.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2018-10-02 at 12.32.55 PM.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/23720iDE8241BA7F170FF2/image-size/large?v=v2&amp;px=999" role="button" title="Screen Shot 2018-10-02 at 12.32.55 PM.png" alt="Screen Shot 2018-10-02 at 12.32.55 PM.png" /></span></P> Tue, 02 Oct 2018 16:49:30 GMT https://communities.sas.com/t5/SAS-Customer-Intelligence/CELL-Code-Information-and-Counts-Information/m-p/500838#M1025 vgp2 2018-10-02T16:49:30Z https://communities.sas.com/t5/SAS-Customer-Intelligence/CELL-Code-Information-and-Counts-Information/m-p/501057#M1027 Hi,<BR />The table in the Common Data Model only holds "Marketing Cells", which are defined as: "A marketing cell is a Cell, Link, or Report node that directly precedes the Communication node". So you will not find upstream cells in this table.<BR />Regards<BR />James<BR /> Wed, 03 Oct 2018 09:34:13 GMT https://communities.sas.com/t5/SAS-Customer-Intelligence/CELL-Code-Information-and-Counts-Information/m-p/501057#M1027 JamesAnderson 2018-10-03T09:34:13Z