Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

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

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

 

_Shubham_Goyal__0-1667287267969.png

 

Br,

Shubham

 

View solution in original post

2 Replies

Avatar

Employee Advisor

Hi Saurabh,

 

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

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

 

Regards,

Craig

Avatar

Correct answer by
Community Advisor

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.

 

_Shubham_Goyal__0-1667287267969.png

 

Br,

Shubham

 

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now