How can I import price data so I can use it as a metric in reporting?

[nancyduley]

We have purchase order numbers in an eVar and have been uploading classifications such as:
Order Type, Order Date, Item Number, Promo Code, List Price, Selling Price

The List Price and Selling Price are coming through as dimensions instead of metrics, so we can’t use them to determine revenue from an order, tactic, channel, etc. - is there a way to import those differently so they can be used as metrics? I have never set up a data source, but it looks like that might be a good option. Thanks.

[Jennifer_Dungan · Accepted solution]

You can set up "currency" events, and pass those as part of your purchase call, either in the s.products (so you have values per each product in the order), or as a whole on the purchase request...

AppMeasurement Sample:

s.events="event1,event2=15.00";
s.products="cat1;product1;1;5.00;event1=5.00;eVar1=something|eVar2=other,cat2;product2;2;10.00;event1=5.00;eVar1=else|eVar2=another";

I set up event1 as a per product value, you can choose if you need the unit price, or the total price when buying multiple items; or you can pass the total value on the entire tracking calls as seen using event2.

You can use both as in my example, or chose what works best for your needs.

[nancyduley]

Jennifer, thank you, this is very helpful and not something we have tried. Good to know how the events work. I can see if this is something we can implement.

It's a long complicated story about this classification data (that is based on data from multiple shopping carts and derived from an Oracle export based on business rules). Some of the data for a purchase is not readily available for shopping cart purchase analytics.

For a plan B, would data sources be an option? I confess I have just started reading about them.

[Jennifer_Dungan]

Ahhh, that does pose some issues.

Data Sources should be an option for stitching in data after the fact... I haven't used Data Sources myself, but I know that you can import both dimension and metric information. If it needs to be stitched to individual products, I am not sure if that would work, since the way product notation is designed is that all the data is stored in a single field with a specific formatting in order for the information to be properly read/processed. 

That said, I would still investigate all options on a QA or Dev suite to be absolutely sure before giving up.

If you just need events mapped based on the row level, this should be possible... Your events will still need to be configured to allow the specific currency format (that is the easy part).

Good Luck!

[nancyduley]

Thank you!