Dataslayer.ai 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 several common options.

Most common options 

• Exclude header row:

Removes the title of each column row, which is useful if you prefer to add your own custom titles.

• Exclude all headers in only metrics queries:

Eliminates all headers from queries that exclusively contain metrics.

• 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.

• Replace blank cells for 0:

Replaces empty data with a 0.

• Replace 0 cells for blank:

Replaces 0 cells for blank.

• 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 with a blank.

• 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 Looker 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.

• Make filters CASE SENSITIVE:

With this option enabled, the filters will verify both uppercase and lowercase letters. Failure to select it will result in no distinction based on how the information is written in the sheet.

• Number of decimals:

This option enables you to specify the number of decimal places for the metrics included in your query. You'll be able to select up to 4 decimals. By adjusting this setting, you can achieve greater flexibility in how your data is presented, ensuring it meets different reporting standards while improving the overall clarity and readability of your results.

 

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

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.

• Skip object if fail due to lack of permission:

If there's a failure due to insufficient permissions to access, the system should gracefully handle the error by skipping the problematic object and continuing with the next one. This ensures that data processing or synchronization tasks can proceed smoothly without interruption.

• Skip if the page does not exist (Facebook Public Data):

If a Facebook page has been deleted or is unavailable, the system skips the missing page and moves on to other available data.

• Report time of actions stats:

Determines the report time of action stats. 

• Return just active accounts:

This option ensures that the output or result of the query specifically focuses on active accounts, omitting any inactive or suspended ones.

• Skip budget division by 100:

This option means that depending on whether the currency you are working with has cents or not, you should select it so that the result returned by the API is not divided by 100.

This feature is useful when dealing with currencies that do not use cents. If your currency uses whole units only, enabling this option ensures that the API returns the correct value without unnecessary division.

With the Facebook connector, you also have available a different advanced option in our Looker Studio destination: 

FB additional options in Looker studio 

• Date Range Mapping:

This filter would use the date selector as a value and allows you to map the selected dimension with the specified date range.
For instance, if you only want to receive data where "created_at" falls within the selected date range, you can map it with "created_at".

 

• Skip the post if it was created before the Business Account

Posts created before linking to a business account (or before the account's setup date) are skipped to avoid irrelevant or inaccessible data.

• Skip if usernames do not exist

When encountering usernames that do not exist or have been removed, the system skips over these entries rather than halting the process.

 

X (Twitter) connector 

 

• Include Twitter Audience Data:

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

• Skip Tweet Cards if fail due to lack of permission:

If there's a failure in displaying or accessing a Tweet Card due to insufficient permissions, the system should bypass that particular card and continue processing others.

• Country

To retrieve data associated with localization dimensions, such as postal codes and regions, it is essential to select the relevant country. Failing to do so will prevent the query from being executed successfully.

 

• Return all products regardless of date (Just for product level):
  

When you enable this option, all products created outside the specified date range in your query configuration will be included in the results.

• Return all customers regardless of date (Just for customers level)

When you enable this option, all customers created outside the specified date range in your query configuration will be included in the results.

 

• Include Undefined Data:

When enabled, it includes data where certain dimensions or metrics are empty or not explicitly defined. If disabled (default), these undefined values are excluded from the report.

• Ignore sites without permissions:

If access to a particular site is restricted or permissions are insufficient, the system avoids that site and continues processing other authorized sites.

• REGEX for match-branded:

If this option is not enabled, the system automatically determines if a query is branded by analyzing the URL, ignoring capitalization and special characters.

• Search Types:

This section offers multiple options for selecting the desired search type: All, Web, Video, Image, Discover, Google News, and News. If no specific option is chosen, the system will automatically generate the query using the Web search type by default.

 

• Replace null for blank:

Information that appears as null will be replaced with a blank cell.

• Permit irregular rows in CSV:

This option permits the inclusion of irregularly formatted rows within the file.

• Trim cells that exceed the character limit:

Google Sheets imposes a limit of 50,000 characters per cell. This option enables you to automatically trim any cells that exceed this character limit, ensuring your data remains within the allowable range and preventing potential errors during processing.

 

As always, please do not hesitate to contact us via our live chat on our website or via e-mail if you still have doubts or questions. We are happy to help!