How to connect ProfitMetrics with Google BigQuery using GA4 (Advanced)

Follow the steps below to connect ProfitMetrics with Google BigQuery using GA4

Before you start

• Integrate ProfitMetrics with GA4
• Create a Google BigQuery project

Overview

Part 1: Integrate ProfitMetrics with GA4

Part 2: Link your ProfitMetrics properties in GA4 with BigQuery

Part 3: Add BigQuery as Datasource in Looker Studio

Part 1: Integrate ProfitMetrics with GA4

Follow this guide: link coming soon
back to top

Part 2: How to link GA4 with BigQuery 

1. Log in to https://analytics.google.com/ and make sure you are in the correct account and property you wish to connect. We usually name our properties (PM Revenue) and (PM Gross Profit) during onboarding. 
2. Click Admin
   
3. Navigate to Product links > BigQuery links
   
   
4. Click Link
   
5. Click Choose a BigQuery project
   
6. Select your project from the list
   
7. Click Confirm
   
8. Select "Data location", set it to the correct region for your shop, and click Next
   
9. Select your desired "Export type".
   
10. Select your desired "Export type" for user data.
    
    
11. Click Next
    
    

Part 3: Add BigQuery as a Data source in Looker Studio

1. Navigate to https://lookerstudio.google.com/
2. Click Create
   
3. Click Data source
   
4. Click BigQuery
   
5. If this is the first time connecting to BigQuery, click Authorize and log in using your Google Ads account
   
6. Select the Project, Dataset and Table you wish to import.
   
   
   
7. Click Connect
   
   
8. That's it. Your Order data from ProfitMetrics is now available for reporting in Looker Studio.

back to top