Created multiple Responsive Search Ads (RSAs) for a client in the law vertical.
Law firms in the US have specific advertising rules that they need to follow — this makes utilizing RSAs challenging, as specific information needs to be shown in each ad (law firm name and principal location).
Using the formula below, I was able to quickly highlight in a column for each RSA whether the name or principal location was present, making it super easy for them to see that the ad copy I wrote complied with the advertising rules.
=SUMPRODUCT(--ISNUMBER(SEARCH($B$1,E10:P10)))>0