filtering typology condition

Hey At

Since your recipients are in the custom Viewer schema and your delivery logs sit in viewdeliverylog rather than the standard nms:broadLogRcp, the out-of-the-box pressure typology won't work here. It reads from nms:broadLogRcp by default and has no awareness of your custom broadlog. A filtering typology rule with a SQL condition pointing directly at viewdeliverylog  may work.

1. create a Filtering type rule. Set the channel to Email. On the Filter tab, change the default targeting dimension away from nms:recipient to your custom Viewer schema, since that is the population being targeted and the dimension your broadlog is linked to.

   On the Filter tab, switch to the SQL condition input and enter a subquery that counts entries in viewdeliverylog for the current day where the status is sent, grouped by the viewer's primary key, excluding anyone who already has 2 or more.

For example,

<viewer_primary_key> IN (
  SELECT iViewerId
  FROM ViewDeliveryLog
  WHERE TRUNC(tsContact) = TRUNC(SYSDATE)
    AND iStatus = 1
  GROUP BY iViewerId
  HAVING COUNT(*) >= 2
)

If I wanted to target all recipients from native broadlogrcp that have received 2 or more emails in the current day the following would be the correct syntax

iRecipientId IN (
  SELECT iRecipientId
  FROM NmsBroadLogRcp
  WHERE DATE_TRUNC('day', tsEvent) = DATE_TRUNC('day', NOW())
  AND iStatus = 1
  GROUP BY iRecipientId
  HAVING COUNT(*) >= 2
)

Give it a try, maybe there are other methods but this is one of them.