By Timur Kuchushev, 27 April 2016

Refunds in Google Analytics

If you have order transactions on your website — you need to be able to include returns in all statistics in Google Analytics.
In Enhanced Ecommerce there is no functionality to submit returns manually. Each company develops its own solution to solve this data problem. And then new problems arise. How to avoid duplication of refunds? What to do if the refund has been sent and the client has re-submitted this order?

Based on Google Sheets, we have created a universal solution which is suitable for sites with Enhanced Ecommerce Google Analytics.
Using this interactive table https://goo.gl/Eqc9nf you can send refunds directly to GA.
1
Start working
Open the spreadsheet https://goo.gl/Eqc9nf and make a copy. Now this copy is your working tool.
2
Insert data
GA ID, order number, Client ID.
In the "Send data?" column, indicate whether or not the data should be sent to GA (Yes or No).

If you have configured the Client ID to upload to Google Analytics — it's even easier. Just insert the order number and the Client ID will be loaded automatically.
3
Sent data
Click the "Send refund" button and the refund data is loaded into Google Analytics. Each order gets the status "Sent". When reloading refunds, orders with this status will not be re-sent to GA.
4
Preview
You can see sent data in Google Analytics. It can be seen in the "Real Time" section in the "Events" report. Complete order data will be loaded into Analytics during the day.
Advanced settings:
Client ID will be entered automatically if you have already set up its transfer to Google Analytics
1
Connect Google Analytics with Google Sheets
Open the spreadsheet https://goo.gl/Eqc9nf and make a copy. Go to "Extras" → "Add-ons" and select Google Analytics.
2
Insert Data
Insert GA View ID and Client Id CF (Custom Field) #, both of which can be found in GA.
3
Upload data into spreadsheet
Click on "Add-ons" → "Google Analytics"→ "Run reports". Order data (order number and Client ID) are loaded in the "cid" tab of your sheet.

Back to the list