Tracking Logs and Delivery Logs

[derekw42533281]

Hey Everyone. 

I have an email that goes out monthly, and I can pull the tracking data, but it's only showing the profiles that opened and clicked. I'm looking to include the profile that received the email but didn't engage.

I feel like this is simple, but it's not clicking in my head how to do it.

[ParthaSarathy · Accepted solution]

Hi @derekw42533281 ,

You can have the query as below, by having Recipient (profile table) as targeting and filtering dimension and Filtering rule as

   Recipient delivery log (broadLog) exist such as

   Delivery- internal-name equals to 'abc' AND status equals to 'Sent'

AND

   Recipient tracking log do no exist such as

   Delivery- internal-name equals to 'abc'

So, The person who received the email 'abc' and have no engagement will be resulted

[Thanongdach]

Method: Using a Workflow with BroadLogRcp and TrackingLogRcp

Step-by-step:

1. Create a Workflow in Adobe Campaign Standard.

2.  Add a Query Activity:

2.1  Targeting Dimension: broadLogRcp (this is the delivery log — it shows who received the email).

2.2  Filtering Dimension: trackingLogRcp (this is the tracking log — it shows who opened or clicked).

3.  Set the Filtering Condition:

3.1 Filter for recipients where no tracking log exists (i.e., no open or click).

3.2  You can do this by setting a condition like:

trackingLogRcp.url IS NULL

or

trackingLogRcp.type NOT IN ('open', 'click')

4.(Optional) Use a Deduplication Activity:

4.1  If you're checking across multiple deliveries, deduplicate based on email address.

4.2  You can also use the Complement option to get the inverse (non-engagers).

5.  Output the Result:

Send the result to a list or use it in a downstream delivery or report.