Articles on: Google Sheets advanced options

Are you familiar with Dataslayer's advanced options? With them you will be able to customize the way your data will be displayed, which will help you create automated reports much faster. You can find them in the "Options" section at the bottom of the settings.

Each connector has its own advanced options, so they may vary depending on which one you use.

Let's take a look at the most common ones:

Exclude header row: removes the title of each column row. This option can not be used together with the "Combine new with old results" option.

Include empty data: causes empty data responses to be processed (very useful in combination with the "Replace blank cells for 0" option).

Replace blank cells for 0: replaces empty data with a 0

Replace "--" cells for blank: some APIs return "--" characters when they have no data instead of returning a blank or a 0. This option replaces "--" characters by a blank. Very useful in combination with the "Include empty data" and "Replace blank cells for 0" options.

Use format compatible with Looker Studio: Many of our users connect their Google Sheets to Looker Studio, as explained in this tutorial. To make the data sent from Google Sheets compatible with Data Studio, this option must be enabled.

Combine new with old results: allows you to add new rows of data to existing queries without overwriting the previous information. It is very useful for use with data sources, metrics or dimensions that can only display data in a finite time range, or for very large queries that cannot be processed at once. This option cannot be combined with the "Exclude header row" option.

Do you have any questions? Do not hesitate to write to us via our web live chat or via our email.

Updated on: 02/02/2023

Was this article helpful?

Share your feedback


Thank you!