List Converting Keywords
I need a unique list of search keywords that resulted in a sale > $100.
=UNIQUE(FILTER(A2:A10, B2:B10 > 100)) How it works: This formula combines two powerful Excel functions: `FILTER` and `UNIQUE`. The `FILTER` function first sifts through your data, extracting only the keywords (from `A2:A10`) where the corresponding sale amount (in `B2:B10`) is greater than $100. This creates an intermediate list of all converting keywords that meet your criteria, including duplicates. The `UNIQUE` function then takes this filtered list and removes any duplicate entries, providing a clean, distinct list of high-value converting keywords. This allows a PPC Manager to quickly identify top-performing keywords for further analysis and budget allocation.
Data Setup
| Keyword | Sale Amount |
|---|---|
| buy blue widgets | 120 |
| cheap red shoes | 50 |
| buy blue widgets | 150 |
| best green hats | 200 |
| cheap red shoes | 110 |
| buy blue widgets | 80 |
| best green hats | 90 |
| online courses | 300 |
| online courses | 50 |
Step-by-Step Guide
Ensure your keyword data is in one column (e.g., Column A) and corresponding sale amounts are in an adjacent column (e.g., Column B).
Select an empty cell where you want the unique list to appear.
Enter the formula: `=UNIQUE(FILTER(A2:A10, B2:B10 > 100))`
Press Enter. Excel will spill the unique list of keywords that generated sales greater than $100.