AdWords
3.7K members online now
3.7K members online now
Use AdWords conversion tracking and reporting to measure your results. Have a question about Google Analytics? Post it here, on the Google Analytics Community!
Guide Me
star_border
Reply

Easy Fix for Keyword match types in Google Sheets

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all, 

 

I am exporting search queries into Google Sheets and am not able to see the correct data in the "Keyword" column.

The Broad Modified match type triggers a formula which display keywords as a NONAME or ERROR.
Phrase match keywords are displayed without the " ", which makes it unable to tell the difference between broad and phrase match types.
Only exact is displayed correctly.

I am sure one of you has a work around for this, I have just not been able to find it.

Thanks!

Easy Fix for Keyword match types in Google Sheets

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I should add that Google Sheets automatically replaced/removed the leading space that automatically triggers when exporting into Excel, and the usual fixes of changing the format to Plain Text or Find/Replace for '=' do not work in Google Sheets.