remove search terms with visits < x from freeform table | Community
Skip to main content
K
KellyCa4
February 6, 2023
Solved

remove search terms with visits < x from freeform table

  • February 6, 2023
  • 1 reply
  • 528 views

Hello-

 

I have a table that shows search terms by visits and conversion. I would like to only show a table with terms that have at least 100 visits and conversion < x I tried the following formula:

https://experienceleague.adobe.com/docs/analytics/components/calculated-metrics/calcmetric-workflow/cm-weighted-metric.html?lang=en

 

But I cannot remove the zeros from the table. The issue is I want to export a table of 400 keywords with low conversion but high visits.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by yuhuisg

As you've discovered, you can't filter by metrics.

This is a common problem with Analysis Workspace. The general workaround is like this:

  1. Create a Calculated Metric using the "IF" function that returns 1 or 0 depending on whether your visits/conversions is more or less than 1,000.
  2. Add that Calculated Metric to your freeform table.
  3. Sort your freeform table by that Calculated Metric.

The end result is that all of the low-value items will be at one end of the table, allowing you to focus on the other data that are high-value. Again, you won't be able to filter by this Calculated Metric.

1 reply

yuhuisg
Community Advisor
yuhuisgCommunity AdvisorAccepted solution
Community Advisor
February 7, 2023

As you've discovered, you can't filter by metrics.

This is a common problem with Analysis Workspace. The general workaround is like this:

  1. Create a Calculated Metric using the "IF" function that returns 1 or 0 depending on whether your visits/conversions is more or less than 1,000.
  2. Add that Calculated Metric to your freeform table.
  3. Sort your freeform table by that Calculated Metric.

The end result is that all of the low-value items will be at one end of the table, allowing you to focus on the other data that are high-value. Again, you won't be able to filter by this Calculated Metric.

Terms & ConditionsAccessibility statement

Loading footer...