Articles on: Google Sheets
This article is also available in: 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 in a more personalized way. You can find them in the "Options" section at the bottom of the settings.

Options on Google Sheets

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

All connectors have 6 common options.

Most common options

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). This means that if there are some ad groups, campaigns, or ads that don't have any data, they won't appear in the table since there are some APIs that don't return any results, but If you add to your query a date dimension and this option, this should display all information, even with 0.
Keep in mind you need to add temporal dimensions to be able to see the empty data.

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. This option must be enabled to make the data sent from Google Sheets compatible with Data Studio.

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.

Learn how to use this option here.

Depending on the connector you are using you can find these options in addition to those already mentioned:

Facebook connector

Fb additional options

Attribution settings:

Attribution settings are a limited period of time for which conversions can be attributed to your ads and used to determine how to optimize the campaign.

Learn more about these options in this FAQ.

Google Analytics connector

GA additional options

Avoid GA Sampling:

In data analysis, sampling is the practice of analyzing a subset of all data to uncover meaningful information in the larger data set.

Learn more about these options in this FAQ.

Twitter connector

Include Twitter Audience Data:

Use this option to avoid discrepancies. Without this option selected part of the data is not shown.

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

Updated on: 14/09/2023

Was this article helpful?

Share your feedback


Thank you!