'Find and Label duplicate Keywords in a table in Data studio
I have keywords from two google ad accounts displayed in a table in the data studio. I want to find the duplicates and label them as "Common keywords". I want help with finding a function or formula that will help me create this new field.
The table I have currently:
| Ad account | Keywords |
|---|---|
| Client A | clothes women |
| Client B | shirts men |
| Client A | pants boy |
| Client B | warm jeans |
| Client A | winter jacket |
| Client B | pants boy |
| Client A | gloves |
| Client B | clothes women |
The column I want to add - Common or Unique:
| Ad account | Keywords | Common or Unique |
|---|---|---|
| Client A | clothes women | Common |
| Client B | shirts men | Unique |
| Client A | pants boy | Common |
| Client B | warm jeans | Unique |
| Client A | winter jacket | Unique |
| Client B | pants boy | Common |
| Client A | gloves | Unique |
| Client B | clothes women | Common |
*Edited for more clarity
Solution 1:[1]
Add a table with the fields Ad account and Keywords as dimensions.
Then add a field Common with the formula
case when Record Count=1 then "Unique" else "Common" end
and drag this new field to the matrics of the table.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Samuel |