Tracking Logs and Delivery Logs

Question

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 Answer

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 · Answer

Method: Using a Workflow with BroadLogRcp and TrackingLogRcpStep-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 NULLortrackingLogRcp.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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded