Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

How to Track order cancel orders in Adobe Analytics

Avatar

Avatar
Validate 1
Level 1
balakrishnad705
Level 1

Like

1 like

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
balakrishnad705
Level 1

Like

1 like

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
balakrishnad705
Level 1

28-12-2017

Hi Team,

I've a question in eCommerce site, I user purchased 3 products and the user returned back 1 Product out of 3 Products. How to track the return orders in Adobe Analytics through DTM ?  Are there still any way to track the return orders.

I would  be great help for the suggestion.

Thanks,

Bala

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
Employee
ericmatisoff
Employee

Likes

151 likes

Total Posts

275 posts

Correct Reply

77 solutions
Top badges earned
Coach
Contributor
Shape 10
Shape 1
Ignite 5
View profile

Avatar
Coach
Employee
ericmatisoff
Employee

Likes

151 likes

Total Posts

275 posts

Correct Reply

77 solutions
Top badges earned
Coach
Contributor
Shape 10
Shape 1
Ignite 5
View profile
ericmatisoff
Employee

02-01-2018

I'd imagine that you would be able to track returns in DTM if the return happens online, but obviously this wouldn't capture any actions that occur offline. Returns made online can be tracked in an event with s.products properly set.

However, I know that I've personally made some purchases online, clicked to make a return, then ended up not sending the product back in the mail. Obviously if your site doesn't sell physical products but online services (like paywalled media or education, for example), then using DTM in the above example should be fine.

Now, if you are asking how to track offline returns actions/data, the best option is via transactionID-based data sources, where you can bulk upload returns (and cancellations if interested) in order to course-correct your purchase data. Here are some details on transactionID: transactionID and Transaction ID and https://theblog.adobe.com/transaction-id-inside-omniture-sitecatalyst/

Here's a (potentially incomplete) list of variables you would want to upload via Data Sources:

  • Date – this is the date that the return or cancellation was made
  • Product – this is the SKU of the product that is being returned
  • Evar – This is the Return Transaction Type. Options are Return or Cancellation only.
  • EventX – This is the number of unique products being returned per row. It should always be set to 1.
  • EventY – This is the number of Units being returned per row. It should be set to the number of non-unique products. It will generally be set to 1, but if more than one unit of the same SKU is returned in the same Return ID, it can be more than 1.
  • EventZ – This is total amount of revenue returned per row. Do not include a currency symbol, simply return the integer total for the number of units per row.
  • Transaction ID – This is the original PURCHASING transaction ID. This should be populated for every row.

Hope that helps!

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

337 likes

Total Posts

2,286 posts

Correct Reply

815 solutions
Top badges earned
Validate 1000
Springboard
Validate 500
Validate 250
Validate 100
View profile

Avatar
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

337 likes

Total Posts

2,286 posts

Correct Reply

815 solutions
Top badges earned
Validate 1000
Springboard
Validate 500
Validate 250
Validate 100
View profile
jantzen_belliston-Adobe
Community Manager

02-01-2018

I'm not sure how others are tracking returned orders in Analytics. I'm going to move this question to the Analytics community since it's primarily asking how returned order tracking is done. Once we have a possible solution, I can help you implement it using DTM.