Total Opens and Clicks not showing correctly when running a report via a workflow | Community
Skip to main content
MColby
MColby
Level 2
October 9, 2020
Solved

Total Opens and Clicks not showing correctly when running a report via a workflow

  • October 9, 2020
  • 2 replies
  • 3246 views

I've created a workflow that uses the delivery resource to export the open and click stats for an email send. The unique open and click stats are showing correctly, but the total opens and clicks are completely wrong. Here are the expressions I'm using -

 

 

They don't match up with what it says in the dynamic report and are actually lower than the unique stats (how can the total amount of opens/clicks be lower than the unique number??).


 

If somebody could tell me where I'm going wrong, that'd be great.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by shelly-goel

Hi @mcolby

I tried total and unique values with both dynamic and Kpis and I find all the results (delivered, total, unique) from kpis matches with those on the delivery dashboard and tracking logs. For me dynamicIndicators are always coming as 0 and the delivered and total open count does not match with the Tracking Indicator reports but the results look more accurate as those matches with the delivery dashboard. Please see below:

 

Report

I think you should be using below fields for accurate results

 

 

2 replies

B
Adobe Employee
bisswangAdobe Employee
Adobe Employee
October 12, 2020

The total opens indeed should not be lower here.

Is it a very recent delivery?

The dynamic indicators are refreshes in very short time periods / real time for a certain period after the delivery is sent.

The KPIs are only calculated in fixed schedules.

 

So if it is very recent, that could explain it.

MColby
MColbyAuthor
Level 2
October 13, 2020

Thanks for getting back to me. This isn't a recent send and isn't the only delivery it is happening with. I'm getting the same result with sends from months ago also.

Is there a way I can reference the dynamic indicator for total recipient open and total recipient click?

Thanks

P
peterd54639079
Level 2
October 30, 2020

which resource table are you pulling the opens and click?

Sukrity_Wadhwa
Community Manager
Sukrity_WadhwaCommunity Manager
Community Manager
November 11, 2020
Hi @shelly-goel, Could you please help @peterd54639079 with this request further? Thanks!
Sukrity Wadhwa
Terms & ConditionsAccessibility statement

Loading footer...