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

Merchandising evar use in Calculated Metric

Avatar

Avatar
Establish
Level 1
ben_at_120Feet
Level 1

Like

1 like

Total Posts

7 posts

Correct Reply

2 solutions
Top badges earned
Establish
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Establish
Level 1
ben_at_120Feet
Level 1

Like

1 like

Total Posts

7 posts

Correct Reply

2 solutions
Top badges earned
Establish
Validate 1
Boost 1
Affirm 1
View profile
ben_at_120Feet
Level 1

27-11-2020

I want to do a report on a particular product sku, but the calculated metric builder uses hit level segments which don't work with merchandising evars.

 

Example:

I want to know what percentage of sales are gift wrapping.  In Workspace I can add a filter on Product, which brings back the correct table. But if I try to make a calculated metric, it automatically creates a hit level segment, which then includes all products in the order that had gift wrapping:

 

2020-11-27_14-19-39.png

 

Is there a way to do a calculated metric which will look at just the units based on the values in the merchandising evar, rather than the hit level?

 

Thanks

 

Ben

View Entire Topic

Avatar

Avatar
Springboard
MVP
yuhuisg
MVP

Likes

146 likes

Total Posts

475 posts

Correct Reply

90 solutions
Top badges earned
Springboard
Bedrock
Validate 1
Establish
Contributor
View profile

Avatar
Springboard
MVP
yuhuisg
MVP

Likes

146 likes

Total Posts

475 posts

Correct Reply

90 solutions
Top badges earned
Springboard
Bedrock
Validate 1
Establish
Contributor
View profile
yuhuisg
MVP

27-11-2020

Some AA practitioners face the same problem as you. Unfortunately, this is a limitation of AA's data schema, so there's nothing that we can do about it.

You could raise this with Adobe Client Care to put in a feature request.