Google Store Sales

⌘K
  2. Home
  4. Docs
  6. Google Store Sales
  8. Step 1 : Set up Store Sal...
  10. Option 4: Set up BigQuery source for Google Store Sales

Option 4: Set up BigQuery source for Google Store Sales

Video Walkthrough

Description  

Google BigQuery is a fully managed, serverless, and highly scalable cloud data warehouse that enables fast SQL queries over large datasets.

By connecting BigQuery as a source in Datahash for Store Sales, you can:

  • Import transactional & offline purchase data
  • Send it to multiple ad platforms for store sales attribution
  • Automate data refreshes from your warehouse


Pre-Requisites  

Ensure you have:

  • Google Cloud Project with BigQuery API enabled
  • Google Service Account with:
    • BigQuery User role
    • BigQuery Data Editor role
  • Service Account JSON Key for authentication

Setup Steps in Datahash  

1. Log in to Datahash  

2. Select BigQuery as Source  

  • In the left navigation → Sources → Warehouse → BigQuery
  • Click on the BigQuery connector tile

3. Choose Data Type  

  • Datahash will ask for File Data Type
  • Select Store Sales
  • Enter a Source Name for the connection
  • Click Next

4. Choose Integration Method  

You can integrate in two ways:

Option A: Table Path  

Use when you already have a table formatted as per Datahash’s Store Sales schema.

  • Download File Format Template from Datahash to ensure correct structure
  • Provide:
    • JSON Key – Google Cloud Service Account JSON file contents
    • Project ID – Your GCP Project ID
    • Dataset ID – Dataset containing the Store Sales table
    • Table Name – Table to extract data from
  • Click Validate Credentials → Finish

Option B: Query Path  

Use when you want Datahash to pull data via a custom SQL query.

  • Provide:
    • JSON Key – Google Cloud Service Account JSON file contents
    • Project ID – Your GCP Project ID
    • Dataset ID – Dataset where your query runs
  • Click Validate Credentials
  • On the next screen, enter your SQL Query to extract Store Sales data
  • Click Preview Results (optional)
  • Click Finish

Where to Find Required Details in GCP  

A. Service Account JSON Key  

  1. Log in to Google Cloud Console
  2. Go to IAM & Admin → Service Accounts

      3. Select an existing service account or Create New

     4. Assign roles: BigQuery User and BigQuery Data Editor

     5. Go to Keys → Add Key → Create New Key → JSON

     6. Download the JSON file (this is your credential)

B. Project ID  

  1. In Google Cloud Console, select your project
  2. In the project dropdown, find Project ID next to the name
  3. Copy and paste into Datahash

__________________________________________________________________________________

C. Dataset ID  

  1. In GCP Console, go to BigQuery → BigQuery Studio
  2. In the Explorer, click on your dataset

       3. The Dataset ID is displayed in the details panel

__________________________________________________________________________________

D. Table Name  

  1. Expand the dataset in the Explorer
  2. Select your table
  3. Copy the Table Name and paste into Datahash

Post-Setup  

  • Once connected, Datahash will automatically begin pulling Store Sales data from BigQuery
  • This data can then be mapped and pushed to advertising destinations such as Google Store Sales CAPI, Meta Store Sales, and others

How can we help?