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.