View orders associated with a coupon code

[richpirate]

After a coupon code is created, there's no way to see the actual orders that used the specific coupon code, revenue generated from it etc...Only the number of times it was used. Kind of useless to generate a coupon code with no way of knowing the value of that marketing campaign.

[oliverands]

I haven't moved over to using the new Miva coupon module for exactly this reason. If you really want this level of reporting, it is available with the older (and inexpensive!) Emporium Plus Coupon Redemption module. I'm still using this and it works fine with the current version of Miva and gives me all the reporting information I need on each campaign.

http://apps.miva.com/coupon-redemption.html

[Brennan]

We do have plans to add a bunch more reporting related to discounts and coupons. For the time being, it can be done with a batch report. I'll post a sample here that can be used as a starting point and modified.

[Brennan]

Below is a simple batch report which will give you some high level data on coupon usage.

http://docs.miva.com/code-samples/coupon-batch-report

[richpirate]

Thanks Brennan!!

[oliverands]

Brennan I have just started the process of migrating to the Miva coupon module. I've found the batch report has everything I need to do my ROI reporting for promotions except for one thing. I would like to get able to get the order subtotal included in the report as well so that I can see the total product value (excluding shipping, tax, and the value of the coupon) of all orders that made use of the coupon. This is something included in the old Emporium Plus report (screen shot attached).

Is there a formula I could add to the batch report as another column in the table to provide this?

Capture.JPG

[Brennan]

It does not appear the order subtotal is a native variable on the batch reports. You could easily add the item subtotals together to create it and then output your own custom variable for that value.

[jsdva]

Below is a simple batch report which will give you some high level data on coupon usage.

http://docs.miva.com/code-samples/coupon-batch-report

Me again dragging up an old post with a question:

Is this still the best way to get a report on coupon usage by order, revenue, etc.

Thanks,

Jamie

[Brennan]

Coupon reporting is now part of Miva 10:

https://docs.miva.com/miva10/referen...s#coupon-usage

[jsdva]

Coupon reporting is now part of Miva 10:

https://docs.miva.com/miva10/referen...s#coupon-usage

HI Brennan,

Yes, I was there. Didn't give much on specifics. Can that report give usage by order, revenue, whatever I want?

Thanks,

Jamie

[jsdva]

Would be nice to see coupon usage by orders and other factors in the coupon utility. Two months worth of orders/coupons on the batch report and it choked. At least it gets us a little somewhere though....

[dreamingdigital]

I think what is slowing down that public coupon report is the additional call to get the order info during the final display of the order. I have tired to get around it but could not figure out how to make the data available for "later" when I needed it again. That might help with the "choke" parts Jamie . At least that was a red flag when I was programming it into a site.

[jsdva]

I think what is slowing down that public coupon report is the additional call to get the order info during the final display of the order. I have tired to get around it but could not figure out how to make the data available for "later" when I needed it again. That might help with the "choke" parts Jamie . At least that was a red flag when I was programming it into a site.

I see. Thank you for the reply Colin.