Skip to main content
walter_euyang1
Nov 22, 2016 5:30 PM UTC
Solved

Filter Unspecified from ReportBuilder Metric Totals

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Hyder_Ziaee
Hyder_ZiaeeAccepted solution
Adobe Employee
Nov 26, 2016 7:09 AM UTC

Hi Walter,

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

-Hyder

1 reply

Hyder_Ziaee
Adobe Employee
Hyder_ZiaeeAdobe EmployeeAccepted solution
Adobe Employee
Nov 26, 2016 7:09 AM UTC

Hi Walter,

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

-Hyder

Translate