Google Analytics (UA)

Section header image mobile

Google Analytics allows you to create an import from scratch or use one of our Import Recipes to give you a head start. Coefficient allows you to pull in metrics, dimensions, and segments directly from Google Analytics for further analysis. 📈📊

Connecting to Google Analytics

Import from Google Analytics

Start from Scratch

Use an Import Template

Pre-built Dashboards

Schedule your Import, Snapshots, and Add Automations

FAQs for Google Analytics

⚠️Google Analytics (UA) will be sunset by Google in July 2024. We recommend that new users connect/use our Google Analytics 4 integration. ⚠️

Connecting to Google Analytics (UA)

When you begin a Google Analytics (UA) import for the first time, you will need to connect/authorize Coefficient to access your Google Analytics (UA) data.

1. Open the Coefficient Sidebar and click the Menu.

Menu_Icon (1).png

2. Select “Connected Sources”. 

Screenshot 2023-10-10 at 5.18.29 AM.png

3. Scroll to the bottom and click “Add Connection”, select “Google Analytics (UA)” and click “Connect”

Screenshot 2023-12-02 at 4.23.45 AM.png

4. “Authorize” Coefficient to connect to your Google Analytics (UA) account.

Screenshot 2023-12-02 at 4.24.30 AM.png

5. Choose your Google account.

Screenshot 2023-12-02 at 4.25.02 AM.png

6. “Allow” access/permissions. If successful, you will be taken back to Google Sheets/Excel.

Screenshot 2023-12-02 at 4.25.33 AM.png

Import from Google Analytics (UA)

There are 3 ways to import data using Coefficient from Google Analytics (UA), “Start from Scratch”, “Use an Import Template” or use one of our “Pre-built Dashboards”. 

Start from Scratch

With “Start from Scratch”, you have the flexibility to customize the data in your import.

1. From the Coefficient Sidebar select “Import from…”.

ImportFrom (1).png

2. Select “Google Analytics (UA)” from the list.

Screenshot 2023-12-02 at 4.22.33 AM.png

3. Select "Start from scratch"

Screenshot 2023-12-02 at 4.37.04 AM.png

4. Select the “View” you would like to import.

Screenshot 2023-12-02 at 4.51.43 AM.png

5. Add your Metrics, Dimensions, or Segments to your import.

Screenshot 2023-12-02 at 4.54.35 AM.png

6. Congratulations on your first import with Google Analytics (UA). 🎉Screenshot 2023-12-02 at 4.55.34 AM.png

Use an Import Template

“Use an Import Recipe” allows you to use one of the pre-configured imports the Coefficient team has created.

1. From the Coefficient Sidebar select “Import from…”.

ImportFrom (1).png

2. Select “Google Analytics (UA)” from the list.

Screenshot 2023-12-02 at 4.22.33 AM.png

3. Select “Use an Import Recipe”, then select from the list of recipes provided.

Screenshot 2023-12-02 at 4.35.55 AM.png

4. Select the View you would like to pull data from.

Screenshot 2023-12-02 at 4.57.34 AM.png

5. You can then edit the Metrics, Dimensions, Segments, and Date Range as needed.

Screenshot 2023-12-02 at 4.58.42 AM.png

6. Congratulations on your first Google Analytics (UA) import using Import Recipes. 🎉

Screenshot 2023-12-02 at 4.59.28 AM.png

Pre-built Dashboards

Our “Pre-built Dashboards” contain multiple imports for raw data that roll up to an amazing visualization tab to share with your team.

1. From the Coefficient Sidebar select “Import from…”.

ImportFrom (1).png

2. Select “Google Analytics (UA)” from the list.

Screenshot 2023-12-02 at 4.22.33 AM.png

3. Select “Pre-Built Dashboards” from the options.

Screenshot 2023-12-02 at 4.40.50 AM.png

4. When you click “Use Dashboard”, a new spreadsheet will open and you will be taken to a tab prompting you to make a copy of this template.

Screenshot 2023-12-02 at 4.42.02 AM.png

5. Navigate to the “Welcome” tab for instructions on how to use this DashboardScreenshot 2023-12-02 at 4.45.29 AM.png

Schedule your Import, Snapshots, and Add Automations

Once you have pulled your data into your spreadsheet using Coefficient, you can set up the following:

1. Schedule your Importa.png

2. Turn on Snapshotsb.png

3. Set Up Automations

c.png

FAQs for Google Analytics (UA)

Does Coefficient support Google Analytics 4? Will there be any conflicts if we start using GA4 for our website data?

Yes! Google Analytics 4 is now supported by Coefficient. You must create a new connection to import data from your GA4 account because our team created a new connector specifically for it.

I am having trouble importing from Google Analytics (UA). What steps can I take to resolve this?

There are a few things you can try:

  1. Make sure that you are using your own Google Analytics (UA) account and not a shared/team account.
  2. Disable any ad blockers installed on your browser. This can interfere with any requests that Coefficient makes to Google Analytics (UA)during the import process.
  3. Confirm your permissions with Google Analytics (UA) with your Admin (Editor permissions are recommended).

Was this article helpful? 0 out of 0 found this helpful