topic data droping on SAS CMS in SAS Customer Intelligence

data droping on SAS CMS

Fdwa-Adwan — Mon, 22 Jul 2019 12:46:58 GMT

Why when I import data to SAs CMS it drops around 3% from it although the " hold out" is disable?

Re: data droping on SAS CMS

JamesAnderson — Tue, 23 Jul 2019 00:00:43 GMT

HI,

Can you please clarify what you mean by import data ?

and how have you determined that records are being dropped ? is it showing "XXXX dropped" on the communication node ?

Regards

James

Re: data droping on SAS CMS

Fdwa-Adwan — Tue, 23 Jul 2019 05:51:49 GMT

using "import external node" node to import data (MSISDNs) form outside SAS, is always dropping X amount of MSISDNs, this not only when importing, when we do any campaign on SAS we fund that some customers who match the criteria were dropped, this when we don't enable the hold out.

Re: data droping on SAS CMS

JamesAnderson — Tue, 23 Jul 2019 08:13:37 GMT

HI,
Sounds like this "import external" node is a custom node developed for your organisation, so you will need to check with your internal support team as to how it works. But in general the way that MA runs its queries against the database is that there is a "primary" table for each subject level, and this table must contain the entire universe of subject_ids (for you it seems that means MSISDNs). Each query from a campaign always joins to this primary table. So if you load a another table with an MSISDN that isn't in the primary table, it will get dropped.
Regards
James