Dataset query examples | Adobe Journey Optimizer

Quoted on this wiki

Every place a page here uses this source, in the order the words come in it.

1. Email sends on daily basis: “Find if a particular email id received an email or not and if not, then what was the error, bounce category, code:” Find the list of all individual email ids which had a particular error, bounce category or code in the last x hours/days or associated with a particular message delivery:

   In Bounce handling

2. Find if a particular email id received an email or not and if not, then what was the error, bounce category, code: “Find the list of all individual email ids which had a particular error, bounce category or code in the last x hours/days or associated with a particular message delivery:” Hard Bounce Rate at aggregate level:

   In Bounce handling

3. Identify quarantined addresses after an ISP outage isp-outage-query “In case of an Internet Service Provider (ISP) outage, you need to idenfity email addresses wrongly maked as bounces (quarantined) for specific domains, during a timeframe.” where the format of dates is: YYYY-MM-DD HH:MM:SS.

   In Bounce handling

4. This query shows the counts of different email feedback status (sent, bounce, etc) for a given message: “This query shows the breakdown of counts of different email feedback status (sent, bounce, etc) by message for a given journey:” At aggregate level, domain level report (sorted by top domains): Domain Name, Message Sent, Bounces

   In Email sequence performance analysis

5. NOTE “Therefore, to accurately track or attribute events at the individual send level, combine the journeyVersionID, journeyActionID, and batchInstanceID (for batch journeys) or identityMap fields for more precise uniqueness.” Identify quarantined addresses after an ISP outage isp-outage-query

   In Outbound source and campaign tracking