| | | | | | | |
. | # | Products | Returned Revenue | Returned Orders | Returned Units | Cost of Returns | Purchase ID |
. | Date | Product | Event 54 | Event 70 | Event 71 | Event 55 | transactionID |
. | 7/1/2008 | ABC1234 | $200 | 1 | 2 | $110 | 29384027 |
. | 7/1/2008 | ABC7689 | $100 | 1 | 2 | $50 | 66930165 |
. | 7/1/2008 | DEF8596 | $600 | 0 | 2 | $300 | 66930165 |
. | | | | | | | |
. | | | | | | | |
. | | | | | | | |
. | Extended Revenue (product revenue * number of units in order) | | Just the number of units of the product purchsed. | | The new Transaction ID you're setting on your site. Only goes back 90 days, only starts when turned on. | | |
. | | | | | | | |
. | Returned Orders (place a 1 here ONLY ONCE for each unique Transaction ID, to not overcount returns) | | Extended cost of all of the units of the product in the order | | | | |
