Querying Recipient Delivery Logs based on eventDate | Community
Skip to main content
S
SkylerQu1
Level 2
January 2, 2025
Solved

Querying Recipient Delivery Logs based on eventDate

  • January 2, 2025
  • 1 reply
  • 1005 views

Hello,

 

I have a workflow that runs every 30min and collects the total # of recipients for a delivery. Currently, it queries the broadLogRcp table for recipients with an eventDate on or after the last time the workflow ran, with the purpose of not counting recipients for a delivery twice.

 

However, whenever a recipients' status changes from 'Pending' to 'Sent', etc., their eventDate timestamp updates. This can result in double counting, as the workflow will count the recipient once when their status is 'Pending' and then again if their status changes to 'Sent' some time after the workflow has run.

 

To fix this, I've changed the query to exclude recipients with a 'Pending' status. My question is - are there any other recipient statuses I need to exclude to prevent counting more than once? Or is 'Pending' the only status where the eventDate is not final?

 

Thanks,

Tyler

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

Hi @skylerqu1 ,

For this case you can use an Incremental Query.

An incremental query lets you periodically select a target based on a criterion, while excluding the people already targeted for this criterion.

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
January 3, 2025

Hi @skylerqu1 ,

For this case you can use an Incremental Query.

An incremental query lets you periodically select a target based on a criterion, while excluding the people already targeted for this criterion.

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    S
    SkylerQu1Author
    Level 2
    January 3, 2025

    Hi @parthasarathy  is there any estimates regarding the data this will require? E.g., if we are processing millions records daily with a 30d incremental query history.

     

    Can we expect all broadlogRCP entries eventDate values to be final for a delivery after the 'delivery duration' validity period ends?

    S
    SkylerQu1Author
    Level 2
    January 3, 2025

    also, what is the name of the default history SQL table?

    Terms & ConditionsAccessibility statement

    Loading footer...