---
title: How to Load Marketing Data into BigQuery with Dataslayer
description: Learn how to load marketing data into BigQuery with Dataslayer. Connect data sources, select accounts, configure transfers, and schedule automated updates.
---
[Skip to content](https://support.dataslayer.ai/getting-started-with-dataslayer-for-bigquery#main-content)
- [English](https://support.dataslayer.ai/getting-started-with-dataslayer-for-bigquery)
- [Español](https://support.dataslayer.ai/es/empezando-con-dataslayer-para-bigquery)
English
Show submenu for translations
[](https://www.dataslayer.ai/)
Open main navigation
Close main navigation
- - [English](https://support.dataslayer.ai/getting-started-with-dataslayer-for-bigquery)
- [Español](https://support.dataslayer.ai/es/empezando-con-dataslayer-para-bigquery)
English
Show submenu for translations
Hello. How can we help you?
- There are no suggestions because the search field is empty.
1. [Knowledge base](https://support.dataslayer.ai/?hsLang=en)
2. [Big Query](https://support.dataslayer.ai/big-query?hsLang=en)
September 24, 2026
# How to Load Marketing Data into BigQuery with Dataslayer
## Learn how to connect marketing data sources, configure a BigQuery transfer, and automate data updates with Dataslayer.
### Before You Start
Dataslayer helps you load advertising, analytics, CRM and ecommerce data into BigQuery. BigQuery is a cloud data warehouse where you can store historical marketing data, keep it available for analysis and use it in reporting tools such as Data Studio.
With Dataslayer, you can connect a data source, select the accounts and fields you need, and transfer the data to BigQuery without building the integration manually.
If you do not have a Dataslayer account yet, [create one here](https://app.dataslayer.ai/) and select BigQuery from the **Destinations** section.
#### What You Need
Before creating a BigQuery transfer, make sure you have:
- A Dataslayer account with BigQuery enabled as a destination.
- Access to the advertising, analytics, CRM or ecommerce platform you want to connect.
- The permissions required to authorize Dataslayer and access the source data.
- Access to the Google account and BigQuery project that will receive the data.
- A clear idea of the accounts, date range, metrics and dimensions you want to transfer.
If you need help preparing your BigQuery project or dataset, review your Google Cloud permissions before starting the transfer.
### How to Load Marketing Data into BigQuery
Follow these steps to create a transfer from a marketing data source to BigQuery.
#### Open the BigQuery Product in Dataslayer
1. Log in to [Dataslayer BigQuery](https://app.dataslayer.ai/transfer-query/bigquery).
-Sep-23-2026-03-29-20-3821-PM.png?width=644&height=236&name=Browser%20template%20(11)-Sep-23-2026-03-29-20-3821-PM.png)
2. Open the BigQuery product dashboard.
3. Review your existing transfers or click **New transfer** to create one.
-Sep-23-2026-03-29-22-9005-PM.png?width=670&height=246&name=Browser%20template%20(12)-Sep-23-2026-03-29-22-9005-PM.png)
#### Create a New Transfer
1. Click **New transfer**.
2. Choose the data source you want to connect.
-3.png?width=670&height=246&name=Browser%20template%20(13)-3.png)
3. Sign in with the account associated with that data source.
4. Authorize Dataslayer if the platform requests permission.
Dataslayer supports integrations with advertising, analytics, CRM and ecommerce platforms. For example, you can use the same workflow to send Google Ads, Facebook Ads or Google Analytics data to BigQuery.
#### Select the Accounts You Want to Transfer
1. Select the accounts, properties, pages or workspaces that contain the data you need.
2. Choose only the accounts you want to include in the transfer.
3. Continue to the data configuration screen.
If an account is missing, check that you authorized the correct user and that the connected platform account is accessible from the same login.
#### Choose the Data to Export
Configure the data that Dataslayer will load into BigQuery:
1. Select the date range.
2. Choose the metrics you want to measure.
-3.png?width=670&height=246&name=Browser%20template%20(15)-3.png)
3. Choose the dimensions you want to use to group the data.
4. Add filters if you only want to transfer specific campaigns, accounts or records.
You can start with one account and a short date range to test the connection. Once the transfer works as expected, expand the configuration to include the rest of your historical or recurring data.
#### Use a Dataslayer Template
If the data source includes a ready-made configuration, you can use a Dataslayer template instead of selecting every field manually.
1. Open the template selector.
2. Choose the template that matches your reporting needs.
3. Review the selected metrics, dimensions and filters.
4. Adjust the configuration if you need different fields or accounts.
For more information, see [How the templates feature works in Dataslayer for BigQuery and API Query Manager](https://support.dataslayer.ai/understanding-the-templates-feature-in-dataslayer-for-bigquery-and-api-query-manager?hsLang=en).
### Configure the BigQuery Destination
After configuring the source data, select the Google account and BigQuery destination where Dataslayer will write the data.
#### Select the BigQuery Account
1. Select the Google account that has access to the BigQuery project.
2. Click **Transfer Data** to continue.
-3.png?width=670&height=246&name=Browser%20template%20(14)-3.png)
3. Complete the BigQuery destination fields shown in the configuration form.
#### Complete the BigQuery Fields
Complete the destination fields shown in the BigQuery configuration screen:
- **Transfer Name:** enter an internal name for the transfer. This name is visible in Dataslayer but is not transferred to BigQuery.
- **Timezone:** select the timezone that should be used for the transfer.
- **Project:** select the Google Cloud project where the data will be stored.
- **Dataset or New Dataset Name:** select an existing dataset or enter the name of a new dataset. These options are mutually exclusive.
- **Database Table:** enter the name of the BigQuery table. You do not need to create the table beforehand.
- **Write Mode:** choose whether to append new rows, replace the existing table data or upsert the data.
-1.png?width=670&height=246&name=Browser%20template%20(17)-1.png)
#### Choose a Write Mode
Select how Dataslayer should write the data to the BigQuery table:
- **Append:** adds new rows to the existing table. This is the most commonly used option.
- **Replace:** deletes the data previously imported into the table and replaces it with the new data.
- **Upsert:** updates existing data and adds new rows. This option can take longer because Dataslayer also updates previously imported data.
#### Preview the Data Before Uploading
After completing the source and destination configuration, use the preview option to check how the table will look before uploading the data to BigQuery. The preview displays up to 200 rows and does not consume your monthly row limit.
### Choose the BigQuery Transfer Frequency
Choose how Dataslayer should send data to BigQuery. The available modes are designed for different reporting workflows.
#### Scheduled Transfers
Use a scheduled transfer when you want Dataslayer to refresh the data automatically. Choose the schedule, time and other available frequency settings shown in the configuration screen.
#### Manual Transfers
Use the manual mode when you want to decide when a transfer runs. After making changes to the configuration, click **Save & refresh** when you want to update the data.
-2.png?width=670&height=246&name=Browser%20template%20(16)-2.png)
#### Manually Split Transfers
Use the manually split mode when you need to upload a large date range or a large amount of data. This option requires a date dimension in your configuration.
Dataslayer divides the transfer into smaller stages so the data can be processed in separate requests. Click **Confirm changes** to save the configuration and start the staged upload.
### Confirm the BigQuery Transfer
1. Review the data source, selected accounts, fields and destination settings.
2. Choose the transfer frequency.
3. Click **Confirm changes**.
4. If you selected the manual frequency mode, click **Save & refresh** when you want to run the transfer.
Once the transfer runs, Dataslayer will send the selected data to your BigQuery destination. You can then query the data in BigQuery or connect it to reporting and visualization tools such as Data Studio.
### How to Upload Historical Data into BigQuery
You can use Dataslayer to transfer historical marketing data to BigQuery when you need to build a longer reporting history or populate a new data warehouse.
1. Open an existing transfer or create a new one.
2. Choose the historical date range you want to import.
3. Select the required accounts, metrics and dimensions.
4. Choose a frequency mode that matches the size of the transfer.
5. Confirm the configuration and monitor the transfer.
For more detailed guidance, see [How to upload historical data into BigQuery](https://support.dataslayer.ai/features-to-upload-historical-data-into-bigquery?hsLang=en).
### Common BigQuery Issues
#### The BigQuery Product Is Not Available
Make sure that you are logged in to the correct Dataslayer account and that BigQuery is enabled in the **Destinations** section. If you still cannot access the product, contact Dataslayer support.
#### A Data Source or Account Is Missing
Reconnect the data source and confirm that you are using the account that owns or can access the required data. If an account is not listed, review the permissions granted during authorization.
#### The BigQuery Project or Dataset Is Missing
Check that the selected Google account has access to the BigQuery project and dataset. If the destination is not available, verify the Google Cloud permissions and the destination fields in the transfer configuration.
#### The Transfer Does Not Start
Review the selected accounts, date range, metrics, dimensions and frequency mode. For manual transfers, click **Save & refresh** after confirming the changes.
#### No Data Appears in BigQuery
Check that the transfer has completed, the selected date range contains data and the destination details are correct. Start with a smaller date range and fewer fields to test the connection.
#### The App Is Blocked
If Google blocks the Dataslayer application during authorization, review the requested permissions and confirm that you are using the correct Google account. If the problem continues, contact Dataslayer support.
### Frequently Asked Questions
#### What Is Dataslayer for BigQuery?
Dataslayer for BigQuery is a data integration tool that transfers data from advertising, analytics, CRM and ecommerce platforms into BigQuery. It helps you build a marketing data warehouse without creating every connection manually.
#### Which Data Sources Can I Load into BigQuery?
You can connect the platforms available in your Dataslayer account, including advertising, analytics, CRM and ecommerce sources. The available connectors depend on your account and plan.
#### Can I Send Google Ads Data to BigQuery?
Yes. Select the Google Ads connector, authorize the required account, choose the data fields and configure BigQuery as the destination. The same process can be used for other supported sources, such as Facebook Ads and Google Analytics.
#### Can I Schedule BigQuery Data Transfers?
Yes. Choose a scheduled frequency when configuring the transfer, then select the available schedule settings. Dataslayer will refresh the data according to that configuration.
#### Can I Upload Historical Data to BigQuery?
Yes. Select the historical date range you want to import and choose a frequency mode that can process the amount of data. You can also use the historical data guide for more detailed instructions.
#### Can I Use the Data in Data Studio?
Yes. After the data is available in BigQuery, you can connect it to Data Studio or another reporting tool that supports BigQuery data.
### Start Loading Marketing Data into BigQuery
You can now connect a marketing data source, configure the BigQuery destination and create your first automated data transfer with Dataslayer.
For more advanced use cases, explore the guides for [the BigQuery platform](https://support.dataslayer.ai/understanding-the-bigquery-platform?hsLang=en), [historical data uploads](https://support.dataslayer.ai/features-to-upload-historical-data-into-bigquery?hsLang=en), [templates](https://support.dataslayer.ai/understanding-the-templates-feature-in-dataslayer-for-bigquery-and-api-query-manager?hsLang=en) and [Upsert writing mode](https://support.dataslayer.ai/understanding-the-upsert-writing-mode-behavior-in-bigquery?hsLang=en).
If you still have questions, contact us through the live chat on our [website](https://dataslayer.ai/) or by [email](mailto:info@dataslayer.ai). We are happy to help.
- [General](https://support.dataslayer.ai/general?hsLang=en)
- [Billing & Pricing](https://support.dataslayer.ai/billing-pricing?hsLang=en)
- [Data Sources](https://support.dataslayer.ai/data-sources?hsLang=en)
- [Blended Connectors](https://support.dataslayer.ai/blended-connectors?hsLang=en)
- [Google Sheets](https://support.dataslayer.ai/google-sheets?hsLang=en)
- [Microsoft Excel](https://support.dataslayer.ai/microsoft-excel?hsLang=en)
- [Spreadsheets](https://support.dataslayer.ai/spreadsheets?hsLang=en)
- [Looker Studio](https://support.dataslayer.ai/looker-studio?hsLang=en)
- [Big Query](https://support.dataslayer.ai/big-query?hsLang=en)
- [API Query Manager](https://support.dataslayer.ai/api-query-manager?hsLang=en)
- [Power BI](https://support.dataslayer.ai/power-bi?hsLang=en)
- [Amazon S3](https://support.dataslayer.ai/amazon-s3?hsLang=en)
- [Amazon Redshift](https://support.dataslayer.ai/amazon-redshift?hsLang=en)
- [Snowflake](https://support.dataslayer.ai/snowflake?hsLang=en#main-content)
- [Marketplace](https://support.dataslayer.ai/snowflake?hsLang=en#marketplace)
- [Google Cloud Storage](https://support.dataslayer.ai/google-cloud-storage?hsLang=en)
- [Database](https://support.dataslayer.ai/database?hsLang=en)
- [Azure SQL](https://support.dataslayer.ai/azure-sql?hsLang=en)
- [Azure Storage](https://support.dataslayer.ai/azure-storage?hsLang=en)
- [Dataslayer Atlas](https://support.dataslayer.ai/dataslayer-atlas?hsLang=en)
- [Morpheus](https://support.dataslayer.ai/morpheus?hsLang=en)
- [AI Looker Studio Analyzer](https://support.dataslayer.ai/ai-looker-studio-analyzer?hsLang=en)
- [Dataslayer MCP](https://support.dataslayer.ai/dataslayer-mcp?hsLang=en)
- [Dataslayer GPT](https://support.dataslayer.ai/dataslayer-gpt?hsLang=en)
- [Dataslayer AI Chat](https://support.dataslayer.ai/dataslayer-ai-chat?hsLang=en)
[](https://dataslayer.ai/)
Dataslayer.ai: Digital Marketing Reporting Made Easy
Copyright © 2026, DATASLAYER SL