BookmarkSubscribeRSS Feed
Fdwa-Adwan
Fluorite | Level 6

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

3 REPLIES 3
JamesAnderson
SAS Employee

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

Fdwa-Adwan
Fluorite | Level 6

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. 

JamesAnderson
SAS Employee
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
How to improve email deliverability

SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 573 views
  • 0 likes
  • 2 in conversation