Expand my Community achievements bar.

SOLVED

Fixing Incorrect Revenue Figure in Reports

Avatar

Level 1

Hi everyone.

I would appreciate a favor here. For certain reasons, a transaction has recorded revenue wrongly in my report. To be more specific, the transaction was done in IDR currency and the value should have been converted to MYR in the report. However, that did not happen thus it resulted a ridiculous high revenue figure being captured.

Is there any way I can over-write or remove the incorrect figure?

I was advised earlier to use image request method, by firing a negative value.  For example, if the wrong revenue captured was MYR 91,869, then we should add MYR -91,869 to the Adobe Analytics servers.

  • The timestamp “t” parameter should be on the same date of the actual booking (green font).
  • The red font is the product string in the image request, where I need to update the revenue correction (negative value).
  • The eVar40 (v40) is IBE order id where I need to update with new order id. (blue font)

https://smetric.malaysiaairlines.com/b/ss/masglobaldev,masmasnewisorevampdev/10/JS-1.7.0-D7QN/s44526...t=4%2F0%2F2018%2019%3A36%3A55%204%20-330&d.&nsid=0&jsonv=1&.d&D=D%3D&mid=23057378801009609452142403403360012262&aamlh=3&ce=UTF-8&ns=malaysiaairlines&pageName=ibe%3Apay%3Aconfirmation&g=https%3A%2F%2Fwav.ap5.amadeus.com%2Fplnext%2FMASAirways%2FBookTripPlan.action%3Bjsessionid%3DZsvBe6Nwn8rvDiFtJSFGyKTW4KBdI7TowGAsfJ24DPaSFvRiZ8HZ%21-695377334%21-1572943885%3FLANGUAGE%3DGB%26SITE%3DJ03UJ03U%26OFFICE_ID%3DKULMH08AB%23%2FCONF&r=https%3A%2F%2Fwav.ap5.amadeus.com%2Fplnext%2FMASAirways%2FDisplayViewVBV.action%3Bjsessionid%3DZsvBe6Nwn8rvDiFtJSFGyKTW4KBdI7TowGAsfJ24DPaSFvRiZ8HZ%21-695377334%21-1572943885%3FJSP_NAME_KEY%3DSITE_JSP_VBV_FRAME_BREAK%26IS_MVERI%3Dfalse%26IS_HVERI%3Dfalse%26ACTION%3DBOOK%26LANGUAGE%3DGB%26SITE%3DJ03UJ03U%26OFFICE_ID%3DKULMH08AB&cc=MYR&purchaseID=D%3Dv40&ch=ibe&events=event32%2Cpurchase&products=flight%3Bow%3Akul-sin%3A%3Aadult%3B1%3B-100%2COthers%3BTaxes%20and%20Fee%3B%3B%3Bevent32%3D37.1&aamb=6G1ynYcLPuiQxYZrsz_pkqfLG9yMXBpb2zX5dvJdYQJzPXImdj0y&c1=KUL&v1=D%3Dc1&h1=D%3Dgn&c2=SIN&v2=D%3Dc2&c3=KUL-SIN&v3=D%3Dc3&c4=15%2F03%2F2018&v4=D%3Dc4&v5=D%3Dc5&v6=D%3Dc6&c7=70&v7=D%3Dc7&c8=1&v8=D%3Dc8&c9=ow&v9=D%3Dc9&v11=70&c18=gb&c19=ibe%3Apay%3Aconfirmation&c22=ibe%3Apay%3Aconfirmation&v23=Malaysia&v24=D%3Dc18&c32=MYR&c40=fixed%20date&v40=p79vsd-new&v42=D%3Dc32&c48=new&c49=guest&v52=D%3Dc39&v53=D%3Dc40&v62=D%3Dc48&v63=D%3Dc49&v84=-100&s=1280x720&c=24&j=1.6&v=N&k=Y&bw=1280&bh=156&AQE=1

However, this did not work as the image request reported this data on the day I run the call, instead of the day the revenue was captured wrongly (as per the time stamp).

Any response or suggestion would be appreciated.

Thank you.

1 Accepted Solution

Avatar

Correct answer by
Level 2

I'm not positive of the limitations on this, but it has been my experience that you can't add data to the past, it will be set on date you run the call. I asked in-house and we have a couple of ideas.

First, you can  create an adjustment event an upload it against the same transaction id. Then you create a calculated metric to subtract that event from the price, and then use that metric for price from now on. The adjustment event would be set as positive and your calculated metric will subtract it. 

     s.products = ";;;;eventx=12345.67"; s.events="eventx"

Or it might just be simpler to create a segment that excludes this specific transaction ID and use that for reporting from now on.

View solution in original post

2 Replies

Avatar

Correct answer by
Level 2

I'm not positive of the limitations on this, but it has been my experience that you can't add data to the past, it will be set on date you run the call. I asked in-house and we have a couple of ideas.

First, you can  create an adjustment event an upload it against the same transaction id. Then you create a calculated metric to subtract that event from the price, and then use that metric for price from now on. The adjustment event would be set as positive and your calculated metric will subtract it. 

     s.products = ";;;;eventx=12345.67"; s.events="eventx"

Or it might just be simpler to create a segment that excludes this specific transaction ID and use that for reporting from now on.

Avatar

Level 1

Hi looriex, thank you so much for your response. The suggestions are pretty practical and worth a try. Having said that,  it would be better to find a solution without a need to create a new metric. But yes, I am also not sure if we can add the data from past.

Thank you again.