How to export DV360 raw data to BigQuery

[pmnigilraj]

Hi, I'm currently working on some of the Google marketing sources data migration into BigQuery to analyze more. So, BQ offers data transfer services to connect Google Ads, Cloud storage, etc., but I solely need DV360 data to be transferred into BigQuery without integrating it with Campaign Manager 360 or only exporting offline reports to BQ.

Recently, I found that Data Transfer v2.0 will transfer the raw data to Google Cloud Storage,
https://developers.google.com/bid-manager/dtv2/overview
but I can't find any official resources that can assist in configuring it in DV360 settings. Any help regarding this will be a great help for me. Thanks in advance!

[ms4446]

To configure DV360 data to be transferred into BigQuery without integrating it with Campaign Manager 360, you might need to follow these general steps:

1. Access DV360: Log in to your Display & Video 360 account.

2. Navigate to Data Transfer Settings: Typically, there's a section in the settings or integrations area where you can manage data transfers.

3. Select BigQuery as Destination: Choose BigQuery as the destination for your data transfer.

4. Specify Data: Ensure you select only the DV360 data you want to transfer. Avoid selecting data related to Campaign Manager 360 if you don't want it.

5. Set Up Transfer Schedule: Determine how often you want the data to be transferred to BigQuery. This could be daily, weekly, or based on another schedule that suits your needs.

6. Review & Save: Before finalizing the setup, review all settings to ensure everything is as per your requirements. Save the configuration.

7. Monitor the First Transfer: It's a good practice to monitor the first data transfer to ensure everything works as expected.

For detailed steps on configuring DV360 data transfer to BigQuery, I recommend visiting the official Display & Video 360 Help Center and navigating to the relevant sections or using the search functionality to find articles related to data transfer configurations. Additionally, you may want to reach out to Google support or your DV360 account manager for personalized assistance.

[pmnigilraj]

Thank You @ms4446 😊. I'll try this approach.

[Linda475]

Hey.
We are currently looking into get DV360 data into BigQuery. I read this thread and hoped it would be helpful but I can not find Data Transfer Settings anywhere in DV360. I. have tried to created a data transfer through GCP but I get access denied with message: "No permission for attempted operation on PARTNER with ID..."
I am not sure how to move on from here. Any suggestions?

Kind regards

[vernon123usa]

I could not find it too earlier. But you need to select a partner accout. Then on the left hand  nav yo uca nsee Linked Accounts. After clicking, you will be able to link it ot a BQ project. 

[Zorik16]

Hello! I understand that the task is not easy. You can use Data Transfer v2.0 to transfer data from DV360 to Google Cloud Storage. Check out the official Google Cloud documentation and check out the Google Cloud user communities for more help. Good luck!

[Snoshone07]

Hi @pmnigilraj Here are a few suggestions and steps you can take to achieve this data transfer as easy as possible

Using Data Transfer v2.0

1. Configure Data Transfer v2.0:

   • Data Transfer v2.0 indeed allows you to transfer raw data to Google Cloud Storage (GCS). You can then set up a transfer from GCS to BigQuery. Here’s a general outline of the process:
     1. Set Up a Transfer Configuration: Follow the Data Transfer v2.0 documentation to configure the transfer from DV360 to GCS.
     2. Create a BigQuery External Table: Once the data is in GCS, you can create an external table in BigQuery that references the data stored in GCS.
     3. Schedule Data Loads: Use BigQuery scheduled queries to periodically load data from the external table into a regular BigQuery table for analysis.

2. Official Resources:

   • Ensure you have the necessary permissions and follow the setup instructions closely as outlined in the Data Transfer v2.0 documentation. Unfortunately, detailed step-by-step instructions specific to DV360 might be sparse, but the general setup should be similar to other data transfers into GCS.

Alternative Solution

If setting up Data Transfer v2.0 seems complex or time-consuming, you might consider using a third-party service like Windsor.ai to simplify the process. Windsor.ai provides robust connectors for DV360, allowing seamless data transfer to BigQuery. Here’s how Windsor.ai can help:

1. Direct Integration:

   • Windsor.ai offers a direct integration with DV360, ensuring your data is transferred to BigQuery without the need for intermediate steps or complex configurations.

2. Automated Data Sync:

   • The platform handles the synchronization of your DV360 data, automatically updating your BigQuery tables with the latest data, which can save you significant time and effort.

3. Easy Setup:

   • Windsor.ai provides a user-friendly interface and comprehensive support to help you set up the integration quickly and efficiently.

Example Setup with Windsor.ai

To set up the DV360 data transfer using Windsor.ai, follow these steps:

1. Sign Up: Create an account on Windsor.ai.
2. Connect DV360: Use the platform to connect your DV360 account.
3. Configure BigQuery: Set up the destination as BigQuery and configure the data transfer settings.
4. Start Syncing: Initiate the data transfer and monitor the synchronization process through Windsor.ai’s dashboard.

By using this solution, you can streamline your data integration process and focus more on analyzing your DV360 data in BigQuery without worrying about the complexities of manual data transfers.

Hope this helps!