Below are the reasons why we recommend Google sheets.
- Data is updated automatically in real-time.
- This is mostly helpful in Coupon Attribution campaigns (which donot involve tracking), if the orders generated via Codes are shared with publishers on daily basis, the publishers are motivated to promote the code effectively.
- Share sheets at campaigns-noreply@dcm-inc.com
In case of Link Attribution, the sheet should have the following data:
- Date
- Transaction ID/Order_id
- utm_content
- Country
- If CPS – Revenue
In case of Coupon Attribution, the sheet should have the following data:
- Date
- Transaction ID
- Code_Name
- Country
- If CPS – Revenue
You can setup a google sheet report simply by importing the transactions data to the google sheet from any data source. If your data source for transactions is GA, you may refer to this guide, given that the GA tracks transaction data along with the code name.