BigQuery integration
Jump to
Connect your Shopify app listing
Set up Google Analytics
1. Set Up or Access Your Google Analytics Account
Visit analytics.google.com and sign in using your Google account credentials.
2. Navigate to the Admin Section

Click on the gear (cog) icon located at the bottom left to access the Admin panel.
3. Initialize a New Account
If you are starting a fresh account, you can skip the initial setup. Otherwise, click the Create button and select Account.

4. Provide an Account Name
Enter a suitable name for your account and then click Next to proceed.

5. Specify Property Details
Input a name for your property, choose the appropriate timezone and currency, and then click Next.

6. Enter Business Information
Fill in your business category and size, then click Next to continue.
7. Define Business Objectives
Select the relevant business objectives that align with your goals and click Create.
8. Accept Google Analytics Terms of Service
Choose the terms applicable to your region. When ready, accept the terms by clicking the I Accept button.
9. Set Up Data Collection
Add a data stream to collect data from Shopify for your application. Select the Web platform.

10. Create a Web Stream
Enter your Shopify app’s URL, assign a name to the stream, and then click Create and continue.
Please Notice! Make sure the "Website URL" is the full URL of your app listing, including the slug (ex. https://apps.shopify.com/my-demo-app).

11. Record the Measurement ID
Take note of the Measurement ID as this will be necessary for integration with Shopify via the Partner portal.

12. Obtain the API Secret
On the same page, retrieve the API Secret by clicking on Measurement Protocol API secret.

13. Generate the API Secret
You may need to review and accept the terms first.
Next, click the Create button.
Assign a nickname to the API Key, such as “Shopify App Listing,” and click Create.
Ensure you save the secret value (API Secret) for future use.

Connect your Shopify app listing
1. Access the Shopify Portal
Log in at partners.shopify.com.
2. Select Your App
From the left-hand menu, choose Apps.
Select your specific app.

Navigate to Distribution in the left menu.

Click on the Manage Listing button.

Now click Edit on your primary listing.

3. Input Google Analytics Details
Scroll to the Tracking Information section and enter your Measurement ID and API Secret in the designated fields. After entering the information, click Save.

Set up BigQuery
1. Provision BigQuery in Google Cloud
1. Sign in
Visit the Google Cloud Console and log in (or create a new account).
2. Create a GCP project
1. Click Select a project ▸ New Project at the top.
2. Name it something memorable (e.g., myapp-shoffi-integration
).

2. Link GA4 to BigQuery
In GA4 ▸ Admin, choose BigQuery links.

Click "Link" and select the project you just created.
Enable Daily export.

Confirm the link appears in the BigQuery links table.
3. Authorise Shoffi to read your dataset
Open IAM & Admin and ensure the correct project is selected (on the top left dropdown).
Click Grant access.
Enter the Shoffi's service-account e-mail:
[email protected]
Assign these roles, under the "BigQuery" section:
BigQuery Data Viewer – permits read access.
BigQuery Job User – permits query jobs.
4. Plug BigQuery into Shoffi

1. Enter the Property ID
Go to Admin > Property > Property details and copy the property ID from the top right.
2. Enter the BigQuery Project ID
Visible at the top of the Google Cloud dashboard.
3. Submit the details.
Dataset missing? Google can take up to 24 hours to create the first partition. Come back later and pick it up once it appears.
Last updated