Expand my Community achievements bar.

SOLVED

Filter Unspecified from ReportBuilder Metric Totals

Avatar

Level 1

Hello,

I am trying to exclude orders with unspecified products (instead of an actual product ID or SKU) from my orders total. I created a segment to exclude orders with unspecified products:

Hits where

Product does not contain Unspecified

AND Product does not contain ::unspecified::

AND Product does not contain None

AND Product does not contain ::none::

This works at excluding orders with unspecified products in Adobe Analytics Reporting, but when I apply to a Site Metrics > Site Totals Report Builder request, the segment doesn't seem to work at excluding the unspecified orders. 

Any ideas how to move forward with report builder and exclude these orders?

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi Walter,

The correct method would be to use "Product exists" and Hits container. This would work in both, UI and ARB.

-Hyder

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

Hi Walter,

The correct method would be to use "Product exists" and Hits container. This would work in both, UI and ARB.

-Hyder