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

New Sub-Hit Segment Container

Avatar

Avatar
Validate 1
MVP
MichaelWon
MVP

Likes

431 likes

Total Posts

91 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
MVP
MichaelWon
MVP

Likes

431 likes

Total Posts

91 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
MichaelWon
MVP

11-05-2018

We sell multiple product categories on our site.  For example: Toys, Baby, Grocery.  A user may place an order that has a product from each category.  For example:

Order Revenue = 500

Toys = 100

Baby = 300

Grocery = 100

If want to see Revenue by Category, I would run a product report against our revenue metric.  Lets say I wanted to create a calculated metric for 'Grocery Revenue'.  My most granular option is this:

Segment Container: Hit

Segment Variable: Products  = Grocery

Metric = Revenue

The problem with this is that the 'hit' container would include all revenue in this order.  So the value would be 500 instead of 100 (unless I broke it down by products).  It would be great to add an additional container that would allow us to 'filter' on the variable in the container depending on the report I am viewing.  This would give us (Visitor, Visit, Hit, Filter) containers and would increase flexibility when creating reports/dashboards etc.

Let me know your thoughts.

Thanks!

28 Comments

Avatar

Avatar
Level 1
AlanSc
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
AlanSc
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile
AlanSc
Level 1

20-10-2020

I second the need for sub hit filtering. Especially for product.

 

This could also allow for better cross selling reporting.

Avatar

Avatar
Give Back
Level 3
luekl
Level 3

Likes

33 likes

Total Posts

30 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Give Back
Level 3
luekl
Level 3

Likes

33 likes

Total Posts

30 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Boost 5
Boost 3
Boost 25
Boost 10
View profile
luekl
Level 3

27-10-2020

@jantzen_belliston-Adobe Archived? Just like that? Not even a comment why!? This is a highly voted feature and imho still a must for e-commerce.

Why archive it?

Avatar

Avatar
Level 1
AlanSc
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
AlanSc
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile
AlanSc
Level 1

28-10-2020

I agree, this would add so much to capabilities. Sad to see it dismissed like this. 

Avatar

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

114 likes

Total Posts

314 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

114 likes

Total Posts

314 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile
jen_lasser
Moderator

28-10-2020

@luekl  @AlanSc  - an auto-archive job was run and this was closed in error. We are correcting some tickets today, please bare with is. This one is moved back to Investigating. Trevor's last comment on the ticket is still the latest.

Avatar

Avatar
Give Back
Level 3
luekl
Level 3

Likes

33 likes

Total Posts

30 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Give Back
Level 3
luekl
Level 3

Likes

33 likes

Total Posts

30 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Boost 5
Boost 3
Boost 25
Boost 10
View profile
luekl
Level 3

28-10-2020

@jen_lasser Thx for the info. I was really angry yesterday due to this.

I think at least the dropzone filters (which are actually hit-based segments) could be easily made to work like sub-hit Filters. There is no additional logic needed. It would be simply the same logic as if I dragged a dimensional Value Filter on top of all tables of the panel.

That would already help save a lot of time and confusion among users (they always wonder why both dropzone and table filters are yellow, but work completely differently).

 

Actual Sub-Hit Segments can come later.

Avatar

Avatar
Level 1
AlanSc
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
AlanSc
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile
AlanSc
Level 1

28-10-2020

The map reduce jobs may need be re-architected @luekl , that would be no small feat. 

 

But yes, the ability to filter at dimension levels other than Visitor/visit/hit would be very valuable indeed. I would expect it would need a custom Panel, similar to why Analytics for Target or Segment Comparison can only be done in a separate Panel.

Avatar

Avatar
Give Back
Level 3
luekl
Level 3

Likes

33 likes

Total Posts

30 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Give Back
Level 3
luekl
Level 3

Likes

33 likes

Total Posts

30 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Boost 5
Boost 3
Boost 25
Boost 10
View profile
luekl
Level 3

28-10-2020

Not sure @AlanSc . What I mean is that the dropzone panel "filter" would be simply the same as adding this filter on top of each table:

So the "Sport & Freizeit" filter on top would mean that it works as if it was actually on top of the table of each of the tables in the screenshot, just like in the example of the "Hauptmetriken..." table on the right.

luekl_1-1603909698816.png

No new query logic is needed for that imho.

From what I have heard it was actually even intended to work like this (because same color should mean same functionality), but then the implementors misunderstood it and implemented the dropzone filters simply as Hit-based Segments.

 

Avatar

Avatar
Springboard
Level 6
jeff_bloomer
Level 6

Likes

139 likes

Total Posts

219 posts

Correct Reply

14 solutions
Top badges earned
Springboard
Validate 10
Validate 1
Contributor
Shape 1
View profile

Avatar
Springboard
Level 6
jeff_bloomer
Level 6

Likes

139 likes

Total Posts

219 posts

Correct Reply

14 solutions
Top badges earned
Springboard
Validate 10
Validate 1
Contributor
Shape 1
View profile
jeff_bloomer
Level 6

17-11-2020

This is definitely a feature we need, especially when you have groups running eComm in a sub-group under a larger organization.   For us to be able to see revenue and units for SPECIFIC PRODUCTS within a purchase rather than seeing all units and revenue from the order is an absolute need.  We shouldn't have to implement our own success metrics just to hack this data.

Avatar

Avatar
Validate 10
Level 5
David-123
Level 5

Likes

111 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile

Avatar
Validate 10
Level 5
David-123
Level 5

Likes

111 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile
David-123
Level 5

02-12-2020

Hi all,

 

100% behind this idea to be voted to be added to the roadmap.

 

At the moment we have to use the data lake to get to this which is fine for myself and the marketing science team for the 90%+ of the business that only ever use workspace this is really something that would be useful.

 

Thanks

 

Dave

Avatar

Avatar
Give Back
Level 3
luekl
Level 3

Likes

33 likes

Total Posts

30 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Give Back
Level 3
luekl
Level 3

Likes

33 likes

Total Posts

30 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Boost 5
Boost 3
Boost 25
Boost 10
View profile
luekl
Level 3

11-01-2021

@jen_lasser 

In the last week alone, I have had 3 more cases where our users are completely confused and make FALSE reports with FALSE conclusions, and I cannot blame them.

Just today I had a guy sending me an email asking why the results are different if he removes the filter from the table because it should be simply a duplicate of what is in the dropzone already. 

When will at least this misleading colouring of the filters be fixed (it looks like a filter in the dropzone, but it is a hit-based segment which makes it work completely differently from the identically looking filter above the table).

@eric_matisoff said you guys supposedly ran a user test for this and the users supposedly said they like it this way. I don't know what kind of test this was, but my users are telling me a different story every week.

Either make the dropzone stuff sub-hit compatible (= this feature idea) OR change the colors of the dropzone so that users are not misled all the time and draw false conclusions or get stuck again and again.

This thing has enough votes for it to be considered. It may be not relevant for those many companies without e-commerce, but for e-commerce where u have mixed baskets all the time, it is crucial!!


"Hi Lukas, I have been trying this now for at least an hour, reloaded etc., but I don't see the error. Why is this

luekl_0-1610391182897.png

not the same as this? I am just removing the duplicate filter after all!"luekl_2-1610391552604.png

luekl_3-1610391575757.png

Thank you for your understanding.

Lukas