Google Sheets
      Back to home
      1. Knowledge base
      2. Google Sheets

      Understanding the Dataslayer Manage Queries view

      We have changed the user interface in our Google Sheets extension. Now managing queries is much easier and faster!

      If you are a bit lost or don't understand well the meaning of each of the icons and their functions, don't worry! Keep reading to find out more about our amazing and super-intuitive Manage Queries menu.

      1. First, in Google Sheets, open the Dataslayer extension.

      lauch-sidebar-2_1i02xx

      2. Once in our extension, you will see all the queries that the document has.

      Learn here how to create a simple query with Dataslayer.


      3. You will be able to manage your queries and create new ones from our extension.

       

      The Dataslayer query icons

      Browser template (9)

      As you can see, this menu has several options. Here is an explanation of what each one does:
      • Refresh: the arrow icon refreshes the query data. This will consume 1 API call.
      • Modify: the pencil icon allows you to modify the query parameters. After making the changes, click on "confirm changes" to apply them.

      Learn more about modifying a query here.

      • Duplicate: the duplicate icon copies the query data to the Dataslayer sidebar. Once this option is clicked, select a blank cell and click on "generate query" to generate an identical query.
      • Report this query: in case of an error or any other problem, the message icon will allow the Dataslayer technical team to review your query code (but not your data) and fix it. Tell us what's happening, submit your report and you will have an answer within the next 24 hours.

      Learn more about reporting a query here.

      • Delete query & data: the paper bin icon deletes the query code and its data.
      • Query information: The arrow next to the paper bin shows all the query information.

       

      In addition to these icons, we have more options in the three dots next to the data source logo:

      Browser template (10)-1

      • Show params: will take you to the query code in the hidden sheet "DataslayerQueries"

      • Go to results: this will take you to the results of the query itself.

      • Delete Query: deletes the query code of the hidden sheet "DataslayerQueries", but not its data.

       

      As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!