BigQuery integration

Please Note! This is a comprehensive guide to setting up a Google Analytics account for your Shopify app listing and connecting it with Shoffi. If you’ve already set up Google Analytics for the app listing, proceed to the next step Set up BigQuery.

Jump to

Set up Google Analytics

Connect your Shopify app listing

Set up BigQuery

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

1. In GA4 ▸ Admin, choose BigQuery links.

1. Click "Link" and select the project you just created.

2. Enable Daily export.

1. Confirm the link appears in the BigQuery links table.

3. Authorise Shoffi to read your dataset

1. Open IAM & Admin and ensure the correct project is selected (on the top left dropdown).

2. Click Grant access.

3. Enter the Shoffi's service-account e-mail: [email protected]

4. Assign these roles, under the "BigQuery" section:

   • BigQuery Data Viewer – permits read access.

   • BigQuery Job User – permits query jobs.

   

Tip: If you hit a policy error, the simplest fix is: • Go to Cloud Organization Policies. • Locate constraints/iam.allowedPolicyMemberDomains. • Click Manage Policy ▸ Add Rule ▸ Allow All.

4. Plug BigQuery into Shoffi

1. Enter the GA 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 or in the "BigQuery links" page in Google Analytics.

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.