I feel like I may have asked this before, but I have a widget that gives me a total count of web orders for a given timeframe. In the past, I thought this had matched the Single Sale Order report for the same time frame, but this quarter it is off by nearly 200.
My formula for # of unique order ids is count([Order ID]).
My date filter is at the dashboard level. I tried turning it off and adding one at the widget level, but that didn't make a difference. My question is -- which is correct? And can anyone explain why they don't match?
Thanks!
Anne
Hi Anne! The Single Sale Order report looks at both the performance date and order date as filters. Have you tried filtering your widget by both of those items in Analytics?
Can you share a screenshot of your parameters on the single sale order listing?
The performance date really isn't relevant to us in this case so I used the same start date for both and the end of March 2024 for the end date on the report (we don't have anything on sale that far out).
Do you sell tickets using the General Public account? (Constituent ID = 0) The single sale order listing by design excludes those orders. The other thing I noticed is your widget is filtered on Mode of Sale Category, but the report has explicit modes of sale and channel selected. While it may be that these should amount to the same thing based on your business practices, I recommend removing the Mode of Sale Category filter from the widget and swapping in the same Modes of Sale and Channel as in your report filter, just to rule out some misalignment there. I know you mentioned the filtering on both order and performance date in the report shouldn't make a difference, but it's still worth - as part of your troubleshooting - making the filters on the widget exactly match the report and see what happens.
Hope that helps!
Given the proximity of your report order date end and the date of the screenshot and assumed date of viewing the dash, is there any chance of a blip in your data warehouse refreshes, assuming you have nightly incremental refreshes scheduled?
I put a range of dates that should cover everything that is on sale, so performance date shouldn't make a difference.
We don't use General Public on web orders -- we don't use guest checkout, so that shouldn't affect the total number of orders. I've played with all of the filters for MOS catgory, MOS, and channel in Analytics and I get the same number of orders no matter what.
It's possible that there is a slight discrepancy, but not this much. We don't get 100+ orders overnight.
For data checking I'd also suggest looking at the detail of this number - so taking this from an indicator widget to a pivot or table where it would list each order id and you could compare it to the single sale order listing order ids. You should be able to pull them out into excel and remove duplicates to find the discrepancies then pop into some of the orders and see what's going on. Hope this helps!