Skip to main content
SaurabhJoshi
October 27, 2022
Solved

On which date delivery (Delivery Code-XYZ) got maximum number of unique open count.

Reporting Delivery - How to find -- On which date delivery (Delivery Code-XYZ) got maximum number of unique open count.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Shubham_Goyal__
Shubham_Goyal__Accepted solution
Level 6
November 1, 2022

Hi @saurabhjoshi ,

 

Do you want to find this information via workflow? or via a Global report?
Global Report > I don't think there is any such OOTB report available to provide day-by-day Unique open data for delivery.
Workflow > If workflow here is my suggestion, take a Query and select the schema as nms:trackingLogRcp and in Filtering condition add your desired delivery for which you want to find this info and then add a Tracking type "Open" in additional data. Post this and go to the Additional data column and add dates only for @LogDate and Sum aggregate for Type of tracking Url. (screenshot) Then you can GroupBy this data on basis of 'Dates' of Log.

 

 

Br,

Shubham

 

~Thanks - Shubham Goyal (Enterprise Architect)
View in thread

2 replies

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe Employee
Adobe Employee
October 27, 2022

Hi Saurabh,

 

I'd recommend checking out https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/generating-counts-of-dates/td-p/356639

which does into how to do a count to calculate your opens and distribute them by date.

 

Regards,

Craig

Translate
Shubham_Goyal__
Shubham_Goyal__Accepted solution
Level 6
November 1, 2022

Hi @saurabhjoshi ,

 

Do you want to find this information via workflow? or via a Global report?
Global Report > I don't think there is any such OOTB report available to provide day-by-day Unique open data for delivery.
Workflow > If workflow here is my suggestion, take a Query and select the schema as nms:trackingLogRcp and in Filtering condition add your desired delivery for which you want to find this info and then add a Tracking type "Open" in additional data. Post this and go to the Additional data column and add dates only for @LogDate and Sum aggregate for Type of tracking Url. (screenshot) Then you can GroupBy this data on basis of 'Dates' of Log.

 

 

Br,

Shubham

 

Translate
~Thanks - Shubham Goyal (Enterprise Architect)
    Terms & ConditionsAccessibility statement

    Loading footer...