When using tiered bidding strategies, it is necessary to make sure keywords with different match types are identical in order to vlookup against each other. However, when exporting from AdWords, you may receive a bulk sheet looking like this:
The formula provided below will transform the match-specific keywords into generic ones:
- Assume B2 is match type and A2 is the keyword
=IF(B2="Broad",SUBSTITUTE(SUBSTITUTE(A2,"'+",""),"+",""),IF(OR(B2="Phrase",B2="Exact"),MID(A2,2,LEN(A2)-2),"Not Proper Match Type"))If placed in Column D, it will result in the following:
+act naturally -> act naturally
"act naturally" -> act naturally
[act naturally] -> act naturally
Essentially, the formula is saying: If the match type is broad, then substitute the + sign for nothing, if it not broad, but is phrase or exact, then chop off the first and last character of the keyword. If it is not broad phrase or exact, display - Not Proper Match Type.
=IF(B2="Broad",SUBSTITUTE(SUBSTITUTE(A2,"'+",""),"+",""),IF(OR(B2="Phrase",B2="Exact"),MID(A2,2,LEN(A2)-2),"Not Proper Match Type"))
Have any questions? Drop a comment below.
No comments:
Post a Comment