How to Link BigQuery to Google Analytics

Overview

Google Analytics is a powerful tool for collecting info on who is visiting your website and Etsy shop. BigQuery is another tool from Google that you can use along with GA to get granular data on each user who visits a page. It stores all the information you collect from GA. When you pair these with IndiePixel, you are able to easily and accurately track individual user page views, add to carts, and purchases to leverage with paid social media advertising platforms.

In this article we'll go over the steps required to. Once this is complete, the best follow-up is How to Use IndiePixel After You Finish Onboarding, because that article explains how this setup fits into the full IndiePixel workflow.

In this article we'll go over the steps required to:

• Set up a BigQuery project
• Link BigQuery to Google Analytics
• Export data from Google Analytics to BigQuery
• Connect BigQuery to IndiePixel

Creating Google Cloud Project

BigQuery is the database that will hold all your analytics, so you can think of the Google Cloud Project as the folder that it all lives in. Let's start by making a new Cloud Project.

Step 2: Click Select a Project

Step 3: Click New Project

Step 4: Name the Project and Click Create

Linking BigQuery to Google Analytics

Now that you have Google Cloud set up, the next step is linking BigQuery to your Google Analytics property. This way we can take the user data of anyone visiting your Etsy listings to track conversions.

Step 2: Click on Admin Settings

Step 3: Click BigQuery Links

Step 4: Click on Link

Step 5: Choose a BigQuery Project

Step 6: Select the Project you Made Earlier and Confirm

Step 7: Verify it is Correct and Click Next

Step 8: Select the Following Options

Step 9: Success!

Return to IndiePixel

You have now successfully completed setting up BigQuery and Google Analytics for tracking with IndiePixel. You can now return to the IndiePixel tab and finish setting up your store. After that, read How to Use UTM Parameters for Etsy Ads Without Creating Messy Data if you want cleaner campaign source data as traffic starts coming in.