In this tutorial, you’ll learn how to set up your Dataslayer query for Database in just a few simple steps. This process will allow you to automate the flow of your marketing data into your database, saving time and keeping your reporting environment
Having your marketing data consolidated in a Database helps eliminate repetitive manual tasks and ensures consistency across reports. Instead of downloading and importing spreadsheets from multiple platforms, Dataslayer allows you to schedule transfers that feed your Database seamlessly and securely. Let’s walk through the process of setting up your first query.
Step-by-step:
-
Sign in to your Dataslayer account to get started.
- Go to the Database Index area and click New transfer to create your first query.
1. Pick the data source you want to pull data from and log in to your Hub Account.
In this guide, you can learn how to connect your Hub Account to our available data sources.
2. Choose the accounts you’d like to extract information from.
3. Next, configure how the query will collect your data:
- Select the date range for your dataset.
- Choose the metrics and dimensions to include.
- Apply any Filters and options that you need.
You can start from one of our pre-built templates or design a fully custom setup! Learn how here.
1. Choose your Database account connection by clicking on the "Connect with Database" button.
This article will guide you on how to understand login fields for a successful connection.
- 2. Fill in all transfer details:
-
Transfer name: internal identifier that only appears in Dataslayer.
-
Timezone: Select your timezone.
-
Table: specify the destination table where the data will be inserted.
-
Table name: define the label that will appear inside your Database.
-
Write mode: Select between append, upsert, or replace (choose depending on your ETL logic).
Learn more about the write modes in this article.
3. Select Sync frequency between Schedule, Manually or Manually splitted options.
Understand all the sync frequency options in this guide.
4. Finally, save your transfer.
- For Schedule, click Save and the query will execute according to your setup.
- For Manually, you can choose Save & Refresh Now to run it immediately or Save to keep it stored for later.
- 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.
That's it! You have inserted your data into Database!
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.
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 Database.
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!