Home Google Analytics and BigQuery How to Connect GA4 with BigQuery

How to Connect GA4 with BigQuery

Services like Prys that need access to a Shopify app's GA4 data may only do so through BigQuery. Before connecting to Prys, you must connect your GA4 property to BigQuery through Google Cloud.

There is no backfill. Data starts flowing only after you connect GA4 and BigQuery. The sooner you connect your GA4 to BigQuery, the more data you'll have in Prys.



See Google help post here

1: Sign up for BigQuery and Create a project for your app store page

Go to your Google Cloud Console. Create a new Google Cloud Console project to cover your Shopify app store page.

2: Name your project GA4 data or something similar. Click “CREATE”.

3: Enable the BigQuery API

A) Open the Navigation menu in the top-left corner (three horizontal lines). Scroll down and click on APIs & Services and then click Library.

B) Search for BigQuery API in the search box on the top. Click on BigQuery API. On the next page, click Enable. Review and agree to the Terms of Service, if required.



4. Connect GA4 and BigQuery

A) Go to your Google Analytics. Select the GA4 property with Shopify app store data. Click on the admin icon on the bottom left. From the Admin panel, click on "BigQuery Links." 

B) Click on "Link" to link to the BigQuery Project. Pick the BigQuery Project covering your app store page. 



Next, pick the data that you want to export. See the image below:



  1. Daily (Event Data) - You must select daily events for Prys to work. This sends the GA4 event data at the end of the day.
  2. Streaming (Event Data) - Prys does not use Streaming data, so you can skip this unless you have another reason. This sends the real-time streaming data to BigQuery. This option is only available if you enter your credit card and enable billing in BigQuery.
  3. Daily (User Data) - You must select daily user data for Prys to work. This sends the user data (both unknown and known users) at the end of the day.

Click, next, review and you are done.

Now, your GA4 data will start flowing to BigQuery. It will take 24-48 hours for you to see the data.