How to Import Google Analytics New Users Data into Excel

using Coefficient excel Add-in (500k+ users)

Learn how to import Google Analytics New Users data directly into Excel using Coefficient. Track audience growth and first-time visitor behavior with automatically refreshing data.

“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”

5 star rating coeff g2 badge

Analyzing New Users data from Google Analytics in Excel helps marketing teams understand audience growth, acquisition effectiveness, and how first-time visitors interact with your website.

Rather than manually exporting data that quickly becomes outdated, you can create a live connection that refreshes automatically with the latest new user metrics.

TLDR

  • Step 1:

    Install Coefficient from the Office Add-ins store

  • Step 2:

    Connect to your Google Analytics account

  • Step 3:

    Select New Users as your primary metric

  • Step 4:

    Configure dimensions to segment your new user data

  • Step 5:

    Import into Excel and set up auto-refresh

Step 1: Install Coefficient and Connect to Google Analytics

Begin by installing the Coefficient add-in and connecting it to your Google Analytics account:

  1. Open Excel and navigate to the Insert tab
  2. Click on Get Add-ins
  3. Search for “Coefficient” in the Office Add-ins store
  4. Click Add to install the Coefficient add-in
  5. Once installed, the Coefficient sidebar will appear
  6. Click “Import” to begin connecting data sources
  7. Select “Google Analytics” from the marketing integrations
  8. Log in with your Google account and authorize Coefficient to access your data
Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Select and Configure New Users Data

After connecting your Google Analytics account, configure your New Users data import:

  1. Choose your Google Analytics 4 property from the dropdown menu
  2. Set your desired date range (last 7 days, last 30 days, custom range, etc.)
  3. Select “New Users” as your primary metric
    • By date to track acquisition trends over time
    • By source/medium to identify which channels bring new visitors
    • By campaign to measure acquisition efforts
    • By geography to understand regional growth
    Add dimensions to segment your new user data:
  4. Apply filters if you want to focus on specific segments of new users
  5. Preview your selection to ensure it provides the insights you need
Marketing integrations such as Google Ads, Facebook Ads, HubSpot, and Klaviyo listed.

Step 3: Import and Set Up Auto-Refresh

Once you’ve configured your New Users data selection, import it into Excel and set up automatic refreshes:

  1. Click “Import” to bring the New Users data into your Excel worksheet
  2. Choose where you want the data to be placed in your spreadsheet
    • Navigate to the “Automations” tab in the Coefficient sidebar
    • Select “Schedule Refresh” for your imported new users data
    • Choose your preferred refresh frequency (hourly, daily, weekly)
    Set up auto-refresh to keep your new user acquisition data current:
  3. Optionally, set up alerts for significant changes in new user acquisition
Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Google Analytics Data

Metrics & Dimensions

  • Sessions
  • Pageviews
  • Conversions (Key Events)
  • Traffic Source / Medium
  • Engaged Sessions
  • Session Conversion Rate
  • Total Revenue
  • Landing Page
  • Event Count
  • Campaign
  • Device Category
  • New Users

Analyzing New Users Data in Excel

With your New Users data now in Excel, you can create valuable analyses like:

  • Audience growth trends over time
  • New vs. returning users comparison
  • Channel effectiveness for acquiring new visitors
  • Custom visualizations showing acquisition by source
  • Automated reports that highlight changes in new user patterns

Related Resources

For more information about working with Google Analytics data in your spreadsheets:

Start importing your Google Analytics New Users data into Excel today with Coefficient and transform how your team analyzes audience growth.

Frequently Asked Questions

  • How to get New Users data from Google Analytics?

    down-chevron

    To access New Users data traditionally:

    • Log into your Google Analytics account
    • Navigate to Reports > Acquisition > User acquisition
    • Look for the “New users” metric in the report
    • Export the data manually as a CSV file

    With Coefficient, you can import New Users data directly into Excel with just a few clicks, eliminating manual exports.

  • How do I get a list of new users in Google Analytics?

    down-chevron

    To analyze new users broken down by different dimensions:

    1. Go to Reports > Acquisition > User acquisition
    2. View the “New users” metric
    3. Apply dimensions like source, date, or campaign
    4. View the resulting breakdown table

    Alternatively, Coefficient lets you easily import new users data with any dimensions directly into Excel for more flexible analysis.

  • How do I download New Users data from Google Analytics?

    down-chevron

    The traditional download process requires:

    • Finding a report with New Users in Google Analytics
    • Clicking the download button
    • Selecting your preferred format (CSV, Excel)
    • Repeating this process whenever you need updated data

    With Coefficient, you can import live New Users data into Excel that refreshes automatically, eliminating repetitive manual downloads.

  • How to automate importing Google Analytics New Users to Excel daily?

    down-chevron

    To automate daily New Users data imports:

    1. Install the Coefficient add-in for Excel
    2. Connect to Google Analytics and import New Users data
    3. Go to the Automations tab in Coefficient
    4. Set up a daily refresh schedule
    5. Optionally, configure email notifications

    This ensures your Excel reports always contain the latest acquisition metrics without manual updates.

  • How to send email alerts about New Users data from Google Analytics?

    down-chevron

    To set up alerts for significant new user acquisition changes:

    1. Import your New Users data to Excel using Coefficient
    2. Go to Automations in the Coefficient sidebar
    3. Select “Set up Notifications”
    4. Configure conditions (e.g., new users drop below target)
    5. Add recipients and customize your alert message

    This automatically notifies your team about important acquisition changes without constant monitoring.

500,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies