We are completing full integration of Google Analytics in our e- commerce software, and we were wondering how e-commerce transactions can be adjusted for returns (full and partial) and cancellations.
Clearly, any ROI calculation becomes misleading unless returned and cancelled orders are taken into account. So far, all we could find is this article:
Our application will have a way for the store manager to easily post a negative transaction, as this article suggests.
But... is this really all the system provides? How about partial returns (e.g. order contains 5 products, two are returned)? It seems rather simplistic in an otherwise great solution to track statistics on an e-commerce store.
Thats it. Because there is no way to edit databases associated with each account the best you can do is ad negative values to negate the charge over time. You negate a product by adding the value of those products as a negative value to the form field. So if someone bought 5 items for $100 each ($500 total) and they return two of them then you need to create a utm form with the order id (utmid) and the negative monetary values. In this example -200 would go into order total field. You can include the order total, tax, and shipping all as negative values.
It's important to understand that the negative values will only be applied from the date the negative values were submitted. So if the original order goes through on the 1st of the month and is then returned on the 15th and thats when your submit a utmform with negative values, the transaction will always remain in your order totals until the 15th. So if on the 16th of the month, you look at the first two weeks of data (1st through the 14th) it will still include the transaction value in the totals until the 15th is added to the date range. So you can see that it doesn't truly cancel or remove the order it negates it and only from the date that you put in the negative transaction value.
> We are completing full integration of Google Analytics in our e- > commerce software, and we were wondering how e-commerce transactions > can be adjusted for returns (full and partial) and cancellations.
> Clearly, any ROI calculation becomes misleading unless returned and > cancelled orders are taken into account. So far, all we could find is > this article:
> Our application will have a way for the store manager to easily post a > negative transaction, as this article suggests.
> But... is this really all the system provides? How about partial > returns (e.g. order contains 5 products, two are returned)? It seems > rather simplistic in an otherwise great solution to track statistics > on an e-commerce store.
Thanks for the message. Just to clarify: you are recommending that when we post back, we post:
- Transaction info, with the negative values corresponding to the full or partial return - Item info, with the negative values for the items that were returned
So, if there was an order where the total was $100 and that contained 3 products whose prices were $50, $30, and $20: If the customer ONLY returns the first product:
- ProductCart (our shopping cart software) will allow the store manager to select which items to post back to Google Analytics - Based on the selections (in this case the store manager would select the one product returned by the customer), the system would create:
(1) Transaction line with negative -$50, using the same order ID (2) Item line (just one line, not 3) with negative $50 for that item ID
If the order were returned fully...
(1) The transaction line would include a negative $100 (2) There would be 3 item lines, just like in the original posting, all with negative product prices
Is this the right approach?
Thanks again,
massimo
P.S. This will be completed soon and will be available to ProductCart users. We will issue an official press release once the code is ready.
> Thats it. Because there is no way to edit databases associated with > each account the best you can do is ad negative values to negate the > charge over time. You negate a product by adding the value of those > products as a negative value to the form field. So if someone bought 5 > items for $100 each ($500 total) and they return two of them then you > need to create a utm form with the order id (utmid) and the negative > monetary values. In this example -200 would go into order total field. > You can include the order total, tax, and shipping all as negative > values.
> It's important to understand that the negative values will only be > applied from the date the negative values were submitted. So if the > original order goes through on the 1st of the month and is then > returned on the 15th and thats when your submit a utmform with > negative values, the transaction will always remain in your order > totals until the 15th. So if on the 16th of the month, you look at the > first two weeks of data (1st through the 14th) it will still include > the transaction value in the totals until the 15th is added to the > date range. So you can see that it doesn't truly cancel or remove the > order it negates it and only from the date that you put in the > negative transaction value.
> -Charles
> On May 7, 10:19 pm, EarlyImpact wrote:
> > We are completing full integration of Google Analytics in our e- > > commerce software, and we were wondering how e-commerce transactions > > can be adjusted for returns (full and partial) and cancellations.
> > Clearly, any ROI calculation becomes misleading unless returned and > > cancelled orders are taken into account. So far, all we could find is > > this article:
> > Our application will have a way for the store manager to easily post a > > negative transaction, as this article suggests.
> > But... is this really all the system provides? How about partial > > returns (e.g. order contains 5 products, two are returned)? It seems > > rather simplistic in an otherwise great solution to track statistics > > on an e-commerce store.
> > Has anyone found any other information on this?
Did the sending of the negative item values solve your problem? We have a similar problem where we submitted an order again with a negative amount for removed items but we submitted the now new item list with it. And so we have the situation, when from an order where 4 items were the original situation and you remove one, the order shows up to have 7 items in Google Analytics.
Can I send a negative amount for an item? Or negative value? Or both? Testing this is extremely annoying as the results show normally up the next day ...
> Thanks for the message. Just to clarify: you are recommending that > when we post back, we post:
> - Transaction info, with the negative values corresponding to the full > or partial return > - Item info, with the negative values for the items that were returned
> So, if there was an order where the total was $100 and that contained > 3 products whose prices were $50, $30, and $20: If the customer ONLY > returns the first product:
> - ProductCart (our shopping cart software) will allow the store > manager to select which items to post back to Google Analytics > - Based on the selections (in this case the store manager would select > the one product returned by the customer), the system would create:
> (1) Transaction line with negative -$50, using the same order ID > (2) Item line (just one line, not 3) with negative $50 for that item > ID
> If the order were returned fully...
> (1) The transaction line would include a negative $100 > (2) There would be 3 item lines, just like in the original posting, > all with negative product prices
> Is this the right approach?
> Thanks again,
> massimo
> P.S. This will be completed soon and will be available to ProductCart > users. We will issue an official press release once the code is ready.
> On May 8, 3:56 am, Epik Charles wrote:
> > Hi Massimo,
> > Thats it. Because there is no way to edit databases associated with > > each account the best you can do is ad negative values to negate the > > charge over time. You negate a product by adding the value of those > > products as a negative value to the form field. So if someone bought 5 > > items for $100 each ($500 total) and they return two of them then you > > need to create a utm form with the order id (utmid) and the negative > > monetary values. In this example -200 would go into order total field. > > You can include the order total, tax, and shipping all as negative > > values.
> > It's important to understand that the negative values will only be > > applied from the date the negative values were submitted. So if the > > original order goes through on the 1st of the month and is then > > returned on the 15th and thats when your submit a utmform with > > negative values, the transaction will always remain in your order > > totals until the 15th. So if on the 16th of the month, you look at the > > first two weeks of data (1st through the 14th) it will still include > > the transaction value in the totals until the 15th is added to the > > date range. So you can see that it doesn't truly cancel or remove the > > order it negates it and only from the date that you put in the > > negative transaction value.
> > -Charles
> > On May 7, 10:19 pm, EarlyImpact wrote:
> > > We are completing full integration of Google Analytics in our e- > > > commerce software, and we were wondering how e-commerce transactions > > > can be adjusted for returns (full and partial) and cancellations.
> > > Clearly, any ROI calculation becomes misleading unless returned and > > > cancelled orders are taken into account. So far, all we could find is > > > this article:
> > > Our application will have a way for the store manager to easily post a > > > negative transaction, as this article suggests.
> > > But... is this really all the system provides? How about partial > > > returns (e.g. order contains 5 products, two are returned)? It seems > > > rather simplistic in an otherwise great solution to track statistics > > > on an e-commerce store.
> > > Has anyone found any other information on this?
> > > Any feedback would be greatly appreciated.
> > > Massimo > > > Early Impact- Hide quoted text -
I'm not sure you can. We haven't tested it yet as we were finishing up on something else. Maybe we should follow the GA article strictly and simply post a negative amount for the main transaction, not the items.
It would be great if someone from the Google Analytics team could weigh in on this since it is very important for the accuracy of the e- commerce reports.
I will send them a message with a link to this forum thread.
> Did the sending of the negative item values solve your problem? We > have a similar problem where we submitted an order again with a > negative amount for removed items but we submitted the now new item > list with it. And so we have the situation, when from an order where 4 > items were the original situation and you remove one, the order shows > up to have 7 items in Google Analytics.
> Can I send a negative amount for an item? Or negative value? Or both? > Testing this is extremely annoying as the results show normally up the > next day ...
> cug
> On 8 Mai, 19:00, EarlyImpact wrote:
> > Hi Charles,
> > Thanks for the message. Just to clarify: you are recommending that > > when we post back, we post:
> > - Transaction info, with the negative values corresponding to the full > > or partial return > > - Item info, with the negative values for the items that were returned
> > So, if there was an order where the total was $100 and that contained > > 3 products whose prices were $50, $30, and $20: If the customer ONLY > > returns the first product:
> > - ProductCart (our shopping cart software) will allow the store > > manager to select which items to post back to Google Analytics > > - Based on the selections (in this case the store manager would select > > the one product returned by the customer), the system would create:
> > (1) Transaction line with negative -$50, using the same order ID > > (2) Item line (just one line, not 3) with negative $50 for that item > > ID
> > If the order were returned fully...
> > (1) The transaction line would include a negative $100 > > (2) There would be 3 item lines, just like in the original posting, > > all with negative product prices
> > Is this the right approach?
> > Thanks again,
> > massimo
> > P.S. This will be completed soon and will be available to ProductCart > > users. We will issue an official press release once the code is ready.
> > On May 8, 3:56 am, Epik Charles wrote:
> > > Hi Massimo,
> > > Thats it. Because there is no way to edit databases associated with > > > each account the best you can do is ad negative values to negate the > > > charge over time. You negate a product by adding the value of those > > > products as a negative value to the form field. So if someone bought 5 > > > items for $100 each ($500 total) and they return two of them then you > > > need to create a utm form with the order id (utmid) and the negative > > > monetary values. In this example -200 would go into order total field. > > > You can include the order total, tax, and shipping all as negative > > > values.
> > > It's important to understand that the negative values will only be > > > applied from the date the negative values were submitted. So if the > > > original order goes through on the 1st of the month and is then > > > returned on the 15th and thats when your submit a utmform with > > > negative values, the transaction will always remain in your order > > > totals until the 15th. So if on the 16th of the month, you look at the > > > first two weeks of data (1st through the 14th) it will still include > > > the transaction value in the totals until the 15th is added to the > > > date range. So you can see that it doesn't truly cancel or remove the > > > order it negates it and only from the date that you put in the > > > negative transaction value.
> > > -Charles
> > > On May 7, 10:19 pm, EarlyImpact wrote:
> > > > We are completing full integration of Google Analytics in our e- > > > > commerce software, and we were wondering how e-commerce transactions > > > > can be adjusted for returns (full and partial) and cancellations.
> > > > Clearly, any ROI calculation becomes misleading unless returned and > > > > cancelled orders are taken into account. So far, all we could find is > > > > this article:
> > > > Our application will have a way for the store manager to easily post a > > > > negative transaction, as this article suggests.
> > > > But... is this really all the system provides? How about partial > > > > returns (e.g. order contains 5 products, two are returned)? It seems > > > > rather simplistic in an otherwise great solution to track statistics > > > > on an e-commerce store.
> > > > Has anyone found any other information on this?
> > > > Any feedback would be greatly appreciated.
> > > > Massimo > > > > Early Impact- Hide quoted text -
I contacted the Google Analytics team via the support form and ask them to please weigh in on this issue. I will post again here when and if they reply back.
> I'm not sure you can. We haven't tested it yet as we were finishing up > on something else. Maybe we should follow the GA article strictly and > simply post a negative amount for the main transaction, not the items.
> It would be great if someone from the Google Analytics team could > weigh in on this since it is very important for the accuracy of the e- > commerce reports.
> I will send them a message with a link to this forum thread.
> massimo > Early Impact
> On May 10, 1:33 pm, cug wrote:
> > Hi.
> > Did the sending of the negative item values solve your problem? We > > have a similar problem where we submitted an order again with a > > negative amount for removed items but we submitted the now new item > > list with it. And so we have the situation, when from an order where 4 > > items were the original situation and you remove one, the order shows > > up to have 7 items in Google Analytics.
> > Can I send a negative amount for an item? Or negative value? Or both? > > Testing this is extremely annoying as the results show normally up the > > next day ...
> > cug
> > On 8 Mai, 19:00, EarlyImpact wrote:
> > > Hi Charles,
> > > Thanks for the message. Just to clarify: you are recommending that > > > when we post back, we post:
> > > - Transaction info, with the negative values corresponding to the full > > > or partial return > > > - Item info, with the negative values for the items that were returned
> > > So, if there was an order where the total was $100 and that contained > > > 3 products whose prices were $50, $30, and $20: If the customer ONLY > > > returns the first product:
> > > - ProductCart (our shopping cart software) will allow the store > > > manager to select which items to post back to Google Analytics > > > - Based on the selections (in this case the store manager would select > > > the one product returned by the customer), the system would create:
> > > (1) Transaction line with negative -$50, using the same order ID > > > (2) Item line (just one line, not 3) with negative $50 for that item > > > ID
> > > If the order were returned fully...
> > > (1) The transaction line would include a negative $100 > > > (2) There would be 3 item lines, just like in the original posting, > > > all with negative product prices
> > > Is this the right approach?
> > > Thanks again,
> > > massimo
> > > P.S. This will be completed soon and will be available to ProductCart > > > users. We will issue an official press release once the code is ready.
> > > On May 8, 3:56 am, Epik Charles wrote:
> > > > Hi Massimo,
> > > > Thats it. Because there is no way to edit databases associated with > > > > each account the best you can do is ad negative values to negate the > > > > charge over time. You negate a product by adding the value of those > > > > products as a negative value to the form field. So if someone bought 5 > > > > items for $100 each ($500 total) and they return two of them then you > > > > need to create a utm form with the order id (utmid) and the negative > > > > monetary values. In this example -200 would go into order total field. > > > > You can include the order total, tax, and shipping all as negative > > > > values.
> > > > It's important to understand that the negative values will only be > > > > applied from the date the negative values were submitted. So if the > > > > original order goes through on the 1st of the month and is then > > > > returned on the 15th and thats when your submit a utmform with > > > > negative values, the transaction will always remain in your order > > > > totals until the 15th. So if on the 16th of the month, you look at the > > > > first two weeks of data (1st through the 14th) it will still include > > > > the transaction value in the totals until the 15th is added to the > > > > date range. So you can see that it doesn't truly cancel or remove the > > > > order it negates it and only from the date that you put in the > > > > negative transaction value.
> > > > -Charles
> > > > On May 7, 10:19 pm, EarlyImpact wrote:
> > > > > We are completing full integration of Google Analytics in our e- > > > > > commerce software, and we were wondering how e-commerce transactions > > > > > can be adjusted for returns (full and partial) and cancellations.
> > > > > Clearly, any ROI calculation becomes misleading unless returned and > > > > > cancelled orders are taken into account. So far, all we could find is > > > > > this article:
> > > > > Our application will have a way for the store manager to easily post a > > > > > negative transaction, as this article suggests.
> > > > > But... is this really all the system provides? How about partial > > > > > returns (e.g. order contains 5 products, two are returned)? It seems > > > > > rather simplistic in an otherwise great solution to track statistics > > > > > on an e-commerce store.
> > > > > Has anyone found any other information on this?
> > > > > Any feedback would be greatly appreciated.
> > > > > Massimo > > > > > Early Impact- Hide quoted text -
This describes how to negate the revenue generated by a transaction. You will only need to remove the items and the revenue associated with those items.
Please note that this will not remove the transaction(or time) from the list but create another transaction(or item) with the same ID that has some negative revenue. This is provided just to balance out the total revenue shown in the reports.
====== END =======
So I guess they are confirming that we should post a negative amount both for the transaction and for the items (all or some) included in the transactions. So a partial refund would consist of a transaction were the negative amount is lower than the initial posted amount and the item list does not contain all of the items.
This is the way we are going to do it in our application (http:// www.earlyimpact.com): the store manager will log into the store administration area and then go to a special page where they can:
(1) Select an order (2) Pick products that have been returned (3) Post the transaction to Google Analytics
If this is an order cancellation or a full return, then (2) includes all products that were initially purchased. If this is a partial return, then (2) includes only the products that are being returned.
I believe this is as close as you can get to properly adjusting the sales reports to account for refunds and cancellations. If anyone has a better idea, please pitch in.
> I contacted the Google Analytics team via the support form and ask > them to please weigh in on this issue. I will post again here when and > if they reply back.
> massimo > Early Impact
> On May 10, 3:08 pm, EarlyImpact wrote:
> > I'm not sure you can. We haven't tested it yet as we were finishing up > > on something else. Maybe we should follow the GA article strictly and > > simply post a negative amount for the main transaction, not the items.
> > It would be great if someone from the Google Analytics team could > > weigh in on this since it is very important for the accuracy of the e- > > commerce reports.
> > I will send them a message with a link to this forum thread.
> > massimo > > Early Impact
> > On May 10, 1:33 pm, cug wrote:
> > > Hi.
> > > Did the sending of the negative item values solve your problem? We > > > have a similar problem where we submitted an order again with a > > > negative amount for removed items but we submitted the now new item > > > list with it. And so we have the situation, when from an order where 4 > > > items were the original situation and you remove one, the order shows > > > up to have 7 items in Google Analytics.
> > > Can I send a negative amount for an item? Or negative value? Or both? > > > Testing this is extremely annoying as the results show normally up the > > > next day ...
> > > cug
> > > On 8 Mai, 19:00, EarlyImpact wrote:
> > > > Hi Charles,
> > > > Thanks for the message. Just to clarify: you are recommending that > > > > when we post back, we post:
> > > > - Transaction info, with the negative values corresponding to the full > > > > or partial return > > > > - Item info, with the negative values for the items that were returned
> > > > So, if there was an order where the total was $100 and that contained > > > > 3 products whose prices were $50, $30, and $20: If the customer ONLY > > > > returns the first product:
> > > > - ProductCart (our shopping cart software) will allow the store > > > > manager to select which items to post back to Google Analytics > > > > - Based on the selections (in this case the store manager would select > > > > the one product returned by the customer), the system would create:
> > > > (1) Transaction line with negative -$50, using the same order ID > > > > (2) Item line (just one line, not 3) with negative $50 for that item > > > > ID
> > > > If the order were returned fully...
> > > > (1) The transaction line would include a negative $100 > > > > (2) There would be 3 item lines, just like in the original posting, > > > > all with negative product prices
> > > > Is this the right approach?
> > > > Thanks again,
> > > > massimo
> > > > P.S. This will be completed soon and will be available to ProductCart > > > > users. We will issue an official press release once the code is ready.
> > > > On May 8, 3:56 am, Epik Charles wrote:
> > > > > Hi Massimo,
> > > > > Thats it. Because there is no way to edit databases associated with > > > > > each account the best you can do is ad negative values to negate the > > > > > charge over time. You negate a product by adding the value of those > > > > > products as a negative value to the form field. So if someone bought 5 > > > > > items for $100 each ($500 total) and they return two of them then you > > > > > need to create a utm form with the order id (utmid) and the negative > > > > > monetary values. In this example -200 would go into order total field. > > > > > You can include the order total, tax, and shipping all as negative > > > > > values.
> > > > > It's important to understand that the negative values will only be > > > > > applied from the date the negative values were submitted. So if the > > > > > original order goes through on the 1st of the month and is then > > > > > returned on the 15th and thats when your submit a utmform with > > > > > negative values, the transaction will always remain in your order > > > > > totals until the 15th. So if on the 16th of the month, you look at the > > > > > first two weeks of data (1st through the 14th) it will still include > > > > > the transaction value in the totals until the 15th is added to the > > > > > date range. So you can see that it doesn't truly cancel or remove the > > > > > order it negates it and only from the date that you put in the > > > > > negative transaction value.
> > > > > -Charles
> > > > > On May 7, 10:19 pm, EarlyImpact wrote:
> > > > > > We are completing full integration of Google Analytics in our e- > > > > > > commerce software, and we were wondering how e-commerce transactions > > > > > > can be adjusted for returns (full and partial) and cancellations.
> > > > > > Clearly, any ROI calculation becomes misleading unless returned and > > > > > > cancelled orders are taken into account. So far, all we could find is > > > > > > this article:
> > > > > > Our application will have a way for the store manager to easily post a > > > > > > negative transaction, as this article suggests.
> > > > > > But... is this really all the system provides? How about partial > > > > > > returns (e.g. order contains 5 products, two are returned)? It seems > > > > > > rather simplistic in an otherwise great solution to track statistics > > > > > > on an e-commerce store.
> > > > > > Has anyone found any other information on this?
> > > > > > Any feedback would be greatly appreciated.
> > > > > > Massimo > > > > > > Early Impact- Hide quoted text -
> > > > > - Show quoted text -- Hide quoted text -
We completed the development on this feature (Ability to easily post refunds and cancellations to Google Analytics, including partial refunds). Here is a link to a screen shot that shows the interface in the ProductCart Control Panel.
> This describes how to negate the revenue generated by a transaction. > You > will only need to remove the items and the revenue associated with > those > items.
> Please note that this will not remove the transaction(or time) from > the > list but create another transaction(or item) with the same ID that has > some negative revenue. This is provided just to balance out the total > revenue shown in the reports.
> ====== END =======
> So I guess they are confirming that we should post a negative amount > both for the transaction and for the items (all or some) included in > the transactions. So a partial refund would consist of a transaction > were the negative amount is lower than the initial posted amount and > the item list does not contain all of the items.
> This is the way we are going to do it in our application (http://www.earlyimpact.com):the store manager will log into the store > administration area and then go to a special page where they can:
> (1) Select an order > (2) Pick products that have been returned > (3) Post the transaction to Google Analytics
> If this is an order cancellation or a full return, then (2) includes > all products that were initially purchased. If this is a partial > return, then (2) includes only the products that are being returned.
> I believe this is as close as you can get to properly adjusting the > sales reports to account for refunds and cancellations. If anyone has > a better idea, please pitch in.
> massimo > Early Impact
> On May 10, 5:20 pm, EarlyImpact wrote:
> > I contacted the Google Analytics team via the support form and ask > > them to please weigh in on this issue. I will post again here when and > > if they reply back.
> > massimo > > Early Impact
> > On May 10, 3:08 pm, EarlyImpact wrote:
> > > I'm not sure you can. We haven't tested it yet as we were finishing up > > > on something else. Maybe we should follow the GA article strictly and > > > simply post a negative amount for the main transaction, not the items.
> > > It would be great if someone from the Google Analytics team could > > > weigh in on this since it is very important for the accuracy of the e- > > > commerce reports.
> > > I will send them a message with a link to this forum thread.
> > > massimo > > > Early Impact
> > > On May 10, 1:33 pm, cug wrote:
> > > > Hi.
> > > > Did the sending of the negative item values solve your problem? We > > > > have a similar problem where we submitted an order again with a > > > > negative amount for removed items but we submitted the now new item > > > > list with it. And so we have the situation, when from an order where 4 > > > > items were the original situation and you remove one, the order shows > > > > up to have 7 items in Google Analytics.
> > > > Can I send a negative amount for an item? Or negative value? Or both? > > > > Testing this is extremely annoying as the results show normally up the > > > > next day ...
> > > > cug
> > > > On 8 Mai, 19:00, EarlyImpact wrote:
> > > > > Hi Charles,
> > > > > Thanks for the message. Just to clarify: you are recommending that > > > > > when we post back, we post:
> > > > > - Transaction info, with the negative values corresponding to the full > > > > > or partial return > > > > > - Item info, with the negative values for the items that were returned
> > > > > So, if there was an order where the total was $100 and that contained > > > > > 3 products whose prices were $50, $30, and $20: If the customer ONLY > > > > > returns the first product:
> > > > > - ProductCart (our shopping cart software) will allow the store > > > > > manager to select which items to post back to Google Analytics > > > > > - Based on the selections (in this case the store manager would select > > > > > the one product returned by the customer), the system would create:
> > > > > (1) Transaction line with negative -$50, using the same order ID > > > > > (2) Item line (just one line, not 3) with negative $50 for that item > > > > > ID
> > > > > If the order were returned fully...
> > > > > (1) The transaction line would include a negative $100 > > > > > (2) There would be 3 item lines, just like in the original posting, > > > > > all with negative product prices
> > > > > Is this the right approach?
> > > > > Thanks again,
> > > > > massimo
> > > > > P.S. This will be completed soon and will be available to ProductCart > > > > > users. We will issue an official press release once the code is ready.
> > > > > On May 8, 3:56 am, Epik Charles wrote:
> > > > > > Hi Massimo,
> > > > > > Thats it. Because there is no way to edit databases associated with > > > > > > each account the best you can do is ad negative values to negate the > > > > > > charge over time. You negate a product by adding the value of those > > > > > > products as a negative value to the form field. So if someone bought 5 > > > > > > items for $100 each ($500 total) and they return two of them then you > > > > > > need to create a utm form with the order id (utmid) and the negative > > > > > > monetary values. In this example -200 would go into order total field. > > > > > > You can include the order total, tax, and shipping all as negative > > > > > > values.
> > > > > > It's important to understand that the negative values will only be > > > > > > applied from the date the negative values were submitted. So if the > > > > > > original order goes through on the 1st of the month and is then > > > > > > returned on the 15th and thats when your submit a utmform with > > > > > > negative values, the transaction will always remain in your order > > > > > > totals until the 15th. So if on the 16th of the month, you look at the > > > > > > first two weeks of data (1st through the 14th) it will still include > > > > > > the transaction value in the totals until the 15th is added to the > > > > > > date range. So you can see that it doesn't truly cancel or remove the > > > > > > order it negates it and only from the date that you put in the > > > > > > negative transaction value.
> > > > > > -Charles
> > > > > > On May 7, 10:19 pm, EarlyImpact wrote:
> > > > > > > We are completing full integration of Google Analytics in our e- > > > > > > > commerce software, and we were wondering how e-commerce transactions > > > > > > > can be adjusted for returns (full and partial) and cancellations.
> > > > > > > Clearly, any ROI calculation becomes misleading unless returned and > > > > > > > cancelled orders are taken into account. So far, all we could find is > > > > > > > this article:
> > > > > > > Our application will have a way for the store manager to easily post a > > > > > > > negative transaction, as this article suggests.
> > > > > > > But... is this really all the system provides? How about partial > > > > > > > returns (e.g. order contains 5 products, two are returned)? It seems > > > > > > > rather simplistic in an otherwise great solution to track statistics > > > > > > > on an e-commerce store.
> > > > > > > Has anyone found any other information on this?
> > > > > > > Any feedback would be greatly appreciated.
