<div class=”forum-post-wrapper”><div class=”forum-post-panel-main clear-block”>
<div class=”content”>
<p>Hi Brad,</p>
<p>I have the following suggestions for the QS analyzer:</p>
<p>- also include the account column, as I would like to analyze multiple
accounts at once and would like to be able to filter on account in the
downloaded file</p>
<p>- also show the average QS on account level, simply based on impressions</p>
<p>- use the Excel csv format (I think it’s separated by ; instead of ,) for the
downloadable file. When I open the current file, Excel doesn’t recognize the
columns and I have to manually do this.</p>
<p>These enhancements would make the tool even a greater time
saver!</p></div></div></div>

<div class=”forum-post-wrapper”>
<div class=”forum-post-panel-main clear-block”><div class=”content”>
<p>The account and overall QS is a good idea; I’ll add it to the proposed
feature list.</p>
<p>The excel one confuses me. I’ve tested these downloads in Excel,and a few
other spreadsheet programs and they open just fine for me.</p>
<p>As they are .xls files; Excel should open them in the correct columns without
the need for any additional formatting. </p>
<p>I’ve not tested this in Excel 2010 yet; only Excel 2003 and 2007. What
version of Excel are you using and what OS?</p>
<p>Also, what error message (or import message, etc) are you seeing when these
docs are opened in Excel?</p>
<p>Hopefully, we can get the formatting issue solved quickly as that’s not
something you should have to do (that burden should be on our
tool).</p></div></div></div>

<div class=”forum-post-wrapper”><div class=”forum-post-panel-main clear-block”>
<div class=”post-title”>Windows Language setting </div>
<div class=”content”>
<p>Hi Brad,</p>
<p>I found out why the columns weren’t recognized automatically in Excel. As I
live in the Netherlands, I have a Dutch Windows with Dutch language &
notation settings.</p>
<p>When I change these settings to English (US) the file loads perfectly into
Excel. I guess this would be an issue for most European users. Any idea if this
can be fixed to work around the globe ?</p></div></div></div>

<div class=”forum-post-wrapper”>
<div class=”forum-post-panel-main clear-block”><div class=”content”>
<p>Interesting. Two questions:</p>
<p>1. When you run an AdWords report, does it use a comma or period to delineate
currency and numbers?
2. When you use the AdWords editor; do you need to
input currency into 1.xx or 1,xx format?</p>
<p>I’m wondering if there’s a comma separation going on in the file background
and since European languages use a different separator notation than the US if
that’s causing an issue.</p></div></div></div>

<div class=”forum-post-wrapper”>
<div class=”forum-post-panel-main clear-block”><div class=”content”>
<p>Hi Brad,</p>
<p>I set my AdWords interface to US English, so the reports I upload are in US
notation.</p>
<p>However, the columns in the downloadable file Certified Knowledge provides
only get recognized by Excel when I change my Windows to US English.</p>
<p>Maybe you could replicate the problem by testing it on a European Windows
computer? Or maybe changing your system language and notation to a European
language (how’s your French/Spanish? . If you use Windows 7 this can be
easily done by downloading a language pack from Windows
Update.</p></div></div></div>

<div class=”forum-post-wrapper”>
<div class=”forum-post-panel-main clear-block”><div class=”content”>
<p>And just to check, when you open a report you created in AdWords that uses US
currency your Excel file opens normally?</p>
<p>If you use any of the other tools – do you get the same error on the output
(you can use the keyword mixer in just a few seconds to test this)?</p>
<p>Just want to see if this is tool specific or part of our Excel/CSV output
package that needs to be updated everywhere.</p>
<p>I’ll also check this on a different computer next week that has 7 installed
to replicate some errors.</p>
<p>Thanks for the clarification.</p></div></div></div>