Google Cloud Storage
      Back to home
      1. Knowledge base
      2. Google Cloud Storage

      How to create a query in Dataslayer for Google Cloud Storage

      In this guide, you'll learn how to set up your Dataslayer query for Google Cloud Storage (GCS) in just a few steps. It'll help you automate your marketing data transfers, save time, and keep all your reports centralized.

      Centralizing marketing data is critical for accurate reporting and analysis. Instead of downloading reports from each platform manually, Dataslayer for Google Cloud Storage (GCS) allows you to automate data transfers securely and efficiently. This guide walks you through the exact steps to create your first Dataslayer query and move your data into GCS without hassle.

      Step-by-step:

      • Log in to your Dataslayer account.

        1

      • Navigate to the GCS Index area and click New transfer to create your first query.

        2-Sep-25-2025-02-47-00-7802-PM
        Query in GCS

      1. Select the data source you want and log in to your Hub Account.

      4-Sep-25-2025-02-48-56-6643-PM

      In this guide, you can learn how to connect your Hub Account to our available data sources.


      2. Choose the data source's accounts you want to get data from.

      5-Sep-25-2025-02-51-15-6460-PM

      3. Select the configuration of your query, such as:

      • You will need to select a date range.
      • The metrics and dimensions you want to add.
      • Filters and options, if needed.

      6-Sep-25-2025-02-51-34-4423-PM

      Optionally use one of our pre-built templates, or create a custom one! Learn how here.

      1. Choose GCS account/service account: authenticate with the Service Account by clicking on the "Connect with Service Accounts" button.

      This article will guide you on how to understand login fields for a successful connection.

        2. Fill in all transfer details:

        1. Transfer name: This name will only be visible on Dataslayer.

        2. Timezone: Select your timezone. 

        3. File name: Select the name of the transfer that will be visible on GCS.

        4. Upload path: optional.

        5. Write mode: Select between append, upsert or replace (choose depending on your ETL logic).

      GCS - Schedule Sync-1

      Learn more about the write modes in this article.

      3. Select Sync frequency between Schedule, Manually or Manually splitted options.

      GCS - Schedule Sync (1)-1

      Understand all the sync frequency options in this guide.


      4. Finally, save your transfer.

        • For Schedule sync frequency, click on Save and the query will start executing at the time selected.
        • For Manually, click on Save & Refresh Now to save the transfer and run the transfer right away. Or click on Save and will only save the query in Dataslayer.
        • For Manually Splitted, click on Save and it will start in a few minutes. Go to your historical transfers in the index to see the status of your transfer.
           

      GCS - Schedule Sync (2)

      That's it! You have inserted your data into Google Cloud Storage!

      Preview data

      If you want to see what the table you have created will look like, you can click on the Preview button to see it.

      Note that this preview is limited to 200 rows.

      GCS - Schedule Sync (3)

      This way, you can make modifications if you have detected any errors or if you want to change the order of the columns, before uploading the table into Google Cloud Storage.

      The preview won't consume your monthly row limit.

       

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