title: Google Analytics Core Reporting API - Result is always limited to one million rows
body: <p>I'm using Core Reporting API to get some reports from GA and save them locally to DB. I have a website that has quite a lot of data since 2007 and I try to create some query that returns huge amount of rows, for example:</p>
  
  <p>start-date = 2007-01-01</p>
  
  <p>end-date = 2015-12-31</p>
  
  <p>metrics = ga:pageviews</p>
  
  <p>dimensions = ga:pagePath, ga:date, ga:hour, ga:cityId</p>
  
  <p>sort = -ga:date</p>
  
  <p>samplingLevel = HIGHER_PRECISION</p>
  
  <p>Then the script in automatically pages through results using max allowed limit (max-results = 10000). The problem is that total number of results is one million exactly.</p>
  
  <p>When I change end-date to 2014-12-31, the result still has one million rows. As I use dimension ga:date, there must be more rows in the first example, right? The first date in both result sets is the same (starting date). The date in last row in both results is equal to ending date. So it seems, both result sets were not cut/limited/reduced (can't figure right word in english).</p>
  
  <p>Also I didn't find anything about one million limit in <a href="https://developers.google.com/analytics/devguides/reporting/core/v2/limits-quotas" rel="nofollow">the documentation</a>.</p>