Beta

How to use

Getting started

The first step is to install the Dataslayer.ai add-on for Google Sheets via Google Marketplace. The following link will download and install it:

https://gsuite.google.com/u/0/marketplace/search/Dataslayer

Once installed, open a new Google Sheet, click on the Add-ons menu tab and select Dataslayer => Launch sidebar.

Select your mail account and click Continue and then Allow to give permissions between Dataslayer.ai and Google Sheets.

how to use it figure 1
how to use it figure 2
how to use it figure 3

If the email is not registered, then please fill in a form as per the below:

how to use it figure 4

A message will confirm the registration is done. An email will also confirm your account is activated.

how to use it figure 5

When these steps are complete, Dataslayer.ai will be launched and ready for use. Dataslayer.ai will now be placed on the right of the sheet (much like with Supermetrics and other similar tools)

how to use it figure 6

Watch this video to learn more

How to use it

This section will guide you through using Dataslayer.ai step by step:

  1. First step is selecting a Data source in the Data sources tab, once Dataslayer.ai is launched at the end of the ‘Getting started’ section. You will need to choose the account with the data you want to query, and give Dataslayer.ai permission to access and query the data linked with the account.
  2. Once a Data source is selected, a group of selectors will be displayed as shown below:
how to use it figure 7

Red box are common selectors among every Data source and blue box is a

specific selector (from Google Analytics in this example)

  1. Next step is to fill every selector regarding the data wanted to query about (only common will be explained):
    1. Accounts: Select account associated with the email account
  1. Date range: Select a date range for querying the data. It is possible to choose a predefined date range:
how to use it figure 8
how to use it figure 9
  1. Metrics: Select the metrics and formulas from where you want to extract data. They are splitted by groups.
  1. Dimensions: Select the dimensions you want to use to break the data. They can be selected by rows or by cols.
how to use it figure 10
  1. Filters: Optionally, it is possible to choose some filters. In some Data sources it is possible to filter not only by Dimensions but also by Metrics.
how to use it figure 11
Watch this video to learn more

Reports

Now you are ready to generate a report after choosing the desired options in each selector. Select a Google Sheet cell to indicate where you want to create the report, and then click the Generate Table button at the top of the plugin.

how to use it figure 12

How to Manage existing queries

Once you have a query created you can duplicate it, refresh the data, compare date ranges, delete queries, etc.

Watch this video to learn more