title: Script does not export TopImpressionPercentage and AbsoluteTopImpressionPercentage as digits in Google Sheets
body: <p>I’ve created a script that exports campaign results to a Google Sheets file. When I implemented the script on September 29th, the data was exported perfectly. See example below (notice that the last four numbers are right-aligned because they're digits).</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Month</th>
  <th>AccountDescriptiveName</th>
  <th>CampaignName</th>
  <th style="text-align: right;">Impressions</th>
  <th style="text-align: right;">SearchImpressionShare</th>
  <th style="text-align: right;"><strong>TopImpressionPercentage</strong></th>
  <th style="text-align: right;"><strong>AbsoluteTopImpressionPercentage</strong></th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2019-03-01</td>
  <td>Account name</td>
  <td>Campaign name</td>
  <td style="text-align: right;">2800</td>
  <td style="text-align: right;">90.82%</td>
  <td style="text-align: right;"><strong>0.73</strong></td>
  <td style="text-align: right;"><strong>0.73</strong></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>However, something changed in the output two weeks ago. The columns TopImpressionPercentage and AbsoluteTopImpressionPercentage were exported differently.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Month</th>
  <th>AccountDescriptiveName</th>
  <th>CampaignName</th>
  <th style="text-align: right;">Impressions</th>
  <th style="text-align: right;">SearchImpressionShare</th>
  <th><strong>TopImpressionPercentage</strong></th>
  <th><strong>AbsoluteTopImpressionPercentage</strong></th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2019-03-01</td>
  <td>Account name</td>
  <td>Campaign name</td>
  <td style="text-align: right;">2800</td>
  <td style="text-align: right;">90.82%</td>
  <td><strong>0.73</strong></td>
  <td><strong>0.73</strong></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The issue here is that TopImpressionPercentage and AbsoluteTopImpressionPercentage have <em>different cell properties</em>. Google Sheets doesn’t see these cells as <em>digits</em> but as <em>text</em> (I guess). Now the goal of this export is that we automatically make calculations in a different sheet based on these number. These automatic calculations fail now because these two columns don’t work anymore. Manually changing the cell properties in Google Sheets is not a solution.</p>
  <p>I have no idea how this has changed. I haven’t made any changes to the script. I’ve tried to run the script to a different Google Sheets file but without any difference.</p>
  <p>Here's the script. My apologies for the incorrect indenting, but the focus here is on the elements that the script contains.</p>
  <pre><code>function main(){
  var sheetURL = 'URL';
  var tabName = 'Tabname';
  
  var QUERIES = [{'query' : 'SELECT Month, AccountDescriptiveName, CampaignName, Labels, '
              + 'Impressions, Clicks, Cost, Conversions, SearchImpressionShare, TopImpressionPercentage, AbsoluteTopImpressionPercentage '
              + 'FROM CAMPAIGN_PERFORMANCE_REPORT '
              + 'WHERE Impressions &gt; 0 '
              + 'DURING 20190101,20220101', 
                'spreadsheetUrl' : sheetURL,
                'tabName' : tabName,
                'reportVersion' : 'v201809'
         }            
        ];
  
    var query;
    var spreadsheetUrl;
    var tabName;
    var reportVersion;
  
   for(var i in QUERIES) {
    var queryObject = QUERIES[i];
    query = queryObject.query;
    spreadsheetUrl = queryObject.spreadsheetUrl;
    tabName = queryObject.tabName;
    reportVersion = queryObject.reportVersion;
   }
  
    var spreadsheet = SpreadsheetApp.openByUrl(spreadsheetUrl);
    var sheet = spreadsheet.getSheetByName(tabName);
    var report = AdWordsApp.report(query, {apiVersion: reportVersion});
    report.exportToSheet(sheet);
  }
  </code></pre>
  <p>I was forwarded from the Google Ads Scrips Direct Support as everything works as it should in the <a href="https://developers.google.com/adwords/api/docs/appendix/reports/campaign-performance-report#topimpressionpercentage" rel="nofollow noreferrer">Campaign Performance Report</a>. Because &quot;the <a href="https://developers.google.com/apps-script" rel="nofollow noreferrer">Google Ads Scripts</a> utilizes Google Apps Script's Spreadsheet to actually extract the report to your spreadsheet&quot;, they recommended me reaching out to <a href="https://developers.google.com/apps-script/support" rel="nofollow noreferrer">Apps Script team</a>.</p>
  <p>I hope that you are able to help me out.</p>
  <p>Thank you in advance.</p>