Solved

Updating Revenue Property Mapping for Events Tracked via Segment

  • 25 May 2023
  • 2 replies
  • 117 views

We use Segment's SDK to track our events, specifically the purchase and refund actions.

Here's a brief overview of our setup:

  1. We track a "Package Purchased" event when a user makes a purchase.
  2. We also track a "Package Refunded" event when a refund is issued to a user.

We originally used a property named 'revenue' to track the monetary value of these events. However, we recently fixed an issue where this value was being reported in various currencies without standardisation. We have now standardised this to use USD and have renamed the property 'revenueUSD'. The 'revenue' property is no longer being sent as part of these events.

With this change in our event setup, I have two questions:

  1. How can we inform Amplitude that the 'revenueUSD' property in our "Package Purchased" event should now be considered as Revenue for use in revenue-related reports like LTV?

  2. Is there a way to communicate to Amplitude that the 'revenueUSD' field in the "Package Refunded" event represents negative revenue?

icon

Best answer by Yuanyuan Zhang 8 June 2023, 16:35

View original

2 replies

Userlevel 5
Badge +8

@Diego Leal Togni welcome! Apologies for the late reply. 😓 This is something that we can usually handle through our Govern add-on but I don’t think it’s possible on the free plan. @Saish Redkar or @JennRu do either of you know? 🙏

Userlevel 5
Badge +5

Had the discussion with @Diego Leal Togni via ticket. Sharing the updates here: 

How can we inform Amplitude that the 'revenueUSD' property in our "Package Purchased" event should now be considered as Revenue for use in revenue-related reports like LTV?

 
Revenue LTV chart only looks at "$revenue" as a property. I assume 'revenueUSD' property is a custom property sent from Segment to Amplitude. In that case, this property will not be used in the LTV chart. For other chart types, you can use 'revenueUSD' property for query. 
 

Is there a way to communicate to Amplitude that the 'revenueUSD' field in the "Package Refunded" event represents negative revenue?

 
There is no way to communicate to Amplitude that the 'revenueUSD' field in the "Package Refunded" event represents negative revenue if you are sending it as a positive value currently. But it is possible to send the revenue and price properties on the event as a negative: https://help.amplitude.com/hc/en-us/articles/115003116888#h_7a841611-ad4f-459a-98ce-073a4a1fe8e5
 
This is the complete doc for how Amplitude track revenue: https://help.amplitude.com/hc/en-us/articles/115003116888
 

Reply