Re: Broad Match Modified Keywords And Google Sheets Are No Fun

[Vincent Racaza (AdWords Scripts Team)]

Hi Ethan,

The Criteria column would output #NAME? in the broad match modified criteria values since the '+' sign is considered as operator in spreadsheet. To fix this issue, you can convert the values of the Criteria column to pure string by adding quote symbol (') before the value. You can update the code snippet below in your script:

 while (report_iter.hasNext()) {
    var row = report_iter.next();
    var row_array = [];
    for (var i in columns) {
      row_array.push(row[columns[i]]);
    }
    row_array[3] = "'" + row_array[3];
    sheet.appendRow(row_array);
}

Let me know if this helps. If you'll encounter any issues on this script, please provide your CID and the name of the script (Reply privately to author) so I can further investigate.

Note: I deleted your post as it contains your private information. 

Thanks,

Vincent Racaza

AdWords Scripts Team

[Ethan]

Thanks Vincent.   That did the trick.   

[Eric Paquet]

For those who want to resolve this issue without using a script :

1. Select the Keyword column

2. Ctrl+F (Find and Replace)

3. Find : =   Replace : (hit the space bar)

4. Make sure you check the box that allows to search in a formula

5. Hit "Replace All" 

 Ta-Dam! :)

Eric

[Ethan]

Thanks for sharing Eric.   We are in the Google Scripts forum though, so I imagine most folks here looking for a script solution.  

[Eric Paquet]

Oh, sorry about that! Maybe a moderator could move my post to the proper forum?

[Ethan]

I don't think it's really a big deal.   Someone might end up just needing a one off solution like you provided.   I'm not sure where you'd end up moving it to help someone.   I'm guessing you managed to find this post via searching so I'm guessing it may pop up for someone else in the future as well.

Appreciate you sharing your solution, as I personally might end up using it for one offs that I don't pull with this script.

[Eric Paquet]

Yeah, I landed on this thread after searching "broad match modified keywords issue in google sheets". Didn't realized this was a forum for AdWords scripts. 

Glad it may help you or anyone else. :)

[Diego Flórez-Estrada]

Hi Vincent,

While making a Keywords Performance Report import to an Spreadsheet I found the same problem. I tried to implement your function, but don´t know how to set the var column. How would you do it for a current Keywords Performance Report Script?

Thanks

[Vincent Racaza (AdWords Scripts Team)]

Hi Diego,

The code snippet that I provided is tailored from the original user's script. So in regards to your issue, are you creating a customized script for Keywords Performance Report? If so, then you can check what column is the Criteria field, and based on that, you can add the quote symbol (') before the actual value when you iterate the row values.

If you have further clarifications/issues, kindly create a new forum thread so we can better track your concern.

Thanks,

Vincent

AdWords Scripts Team