Rename all ad groups using REGEXREPLACE()
Once again, the marketing director has put you in charge of complying with the social media marketing team's naming convention. This time, you are tasked with changing the ad group names to be more descriptive, so that the ad group names are a bit more informative.
To achieve this, you will need to add the word 'Buyers' to the end of the ad group name, while removing the s from the end of the word (e.g. Mugs will become Mug Buyers). Recall that using a $ can match the end of a string.
- For example, ing$ will match the ing in flying.
Much as in the previous exercise, your formula will need to make use of IF(), REGEXMATCH(), and REGEXREPLACE().
本练习是课程的一部分
在 Google Sheets 中进行营销分析
练习说明
- Write a regular expression in cell
I2that will match the trailingsin words likeMugsandSweaters. Use the 'flying' example above as a starting point for your pattern! - In cell
F2, add anIF()statement:- Test if cell
C2contains your trailingspattern$I$2. - When the argument is
TRUE, replace thes(identified using your pattern) with " Buyers" (don't forget the space!) - When it is
FALSE, return the string "No Match".
- Test if cell
- Apply the formula to the remainder of the cells,
F3:F29.
