How do I get more than 200 000 rows in a Data Query export?

Exports in a .csv format from Data Query are limited to 200 000 rows by default.

If you purchased the Data Flow option, this limit is automatically increased to 1 000 000 rows.

A separate option also exists to allow exporting without any row limitation.

The API is also limited to 200 000 rows.

You can, if needed, export more than 200 000 rows by cutting your analysis period into several smaller periods.

However, there are tools dedicated to massive data exports, such as: 

• Data Flow: Introduction & Data Schema

• Data Sharing: Introduction, Data Schema & Access

All options mentioned here are paid options.

Feel free to contact your Account manager or our Support Centre should you need any further information on these options.