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

SOLVED

Numerical Classifications

tcrewes
Level 1
Level 1

Hi team,

Does anyone know if there is a way to upload classifications in a numerical format so it can easily be passed into a metric. For example, if I wanted to upload the number of units returned per order (classifying against order ID), or the revenue value of returns per order? I'd want to be able to see the values at an order level but also roll them up to a total figure.

I've looked at numeric classifications, but it appears that these have been discontinued (Numeric 2 classifications overview). My understanding is that text classifications won't allow for this type of data to be easily passed into metrics.

Does anyone have any ideas / work arounds for this?

Thanks

Toby

1 Accepted Solution
pabloc82923542
Correct answer by
Level 9
Level 9

What I have done in the past relies on a few things.

We treat the Product return as a new purchase Item.

We then capture its name as a product- return. , Units, and $ amounts then apply. Our system then happened to then also need 2 transaction Ids. 1 for the originating one had to match. 1 For the new action of a credit in essence.

It has some challenges but we found it useful. We could then report at a transaction level or by the sum of return products.

regards

View solution in original post

1 Reply
pabloc82923542
Correct answer by
Level 9
Level 9

What I have done in the past relies on a few things.

We treat the Product return as a new purchase Item.

We then capture its name as a product- return. , Units, and $ amounts then apply. Our system then happened to then also need 2 transaction Ids. 1 for the originating one had to match. 1 For the new action of a credit in essence.

It has some challenges but we found it useful. We could then report at a transaction level or by the sum of return products.

regards

View solution in original post