Question
Why am I seeing exactly 10,000 rows written into the destination warehouse? This does not match the Google Analytics Reporting page for unique pageviews.
Environment
Connector: Google Analytics
Answer
Remove the ga:clientId
dimension from your Google Analytics Connector
Cause
From Google Analytics API Support:
The ga:clientId
dimension is currently not documented within the Dimensions & Metrics Explorer page, which serves as the official arbiter of which fields are supported by the Analytics API. Using this dimension in an Analytics report may thus result in unexpected & unexplainable behavior (such as restricting the report to exactly 10,000 or 10,001 rows). There is an ongoing feature request for this on our side; you may follow our changelogs for any future updates on this.