ℹ️ Available on all plans.
Track marketing goals, such as new users or conversions, with your website data from Google Analytics.
Perdoo doesn't connect to Google Analytics directly. Instead, pull your GA4 data into Google Sheets with Google's GA4 Reports Builder for Google Analytics add-on, and link your goals to the cells you need.
💡 A spreadsheet lets you adjust your Google Analytics data with formulas before it updates your goals.
Before you start
Connect the Google Sheets integration in Perdoo, or install the Google Sheets Add-on.
Pull Google Analytics data into Google Sheets
In your spreadsheet, go to Extensions > Add-ons > Get add-ons, search for GA4 Reports Builder for Google Analytics, and click Install (1). You can also install it from the Google Workspace Marketplace.
Follow the prompts to give the add-on access to your Google Analytics account.
Go to Extensions (2) > GA4 Reports Builder for Google Analytics™ (3) > Create new report (4).
Select the Account and Property you want to report on.
Enter a Report name (5), set the Start date and End date (6), and choose a dimension and the metrics you need (7), for example year and newUsers.
Click Save Report Configuration (8), and then Run Report (9). The add-on adds a sheet with the name of your report and fills it with your data.
To keep the data up to date, go to Extensions > GA4 Reports Builder for Google Analytics™ > Schedule reports. Choose a Frequency (10), for example every day, and click Save (11).
Important
The add-on needs at least one dimension before you can save a report. Choose year to get one total for your date range.
Update your goals with Google Analytics data
Link each goal to the cell with its value, for example the total under Totals For All Results (1). With the Google Sheets integration, open the goal, click Progress driver, and select the cell. With the Google Sheets Add-on, link the data to the Goal Progress cells of the goals you imported.
Good to know
How often are my goals updated?
Your sheet refreshes as often as you schedule the reports in the add-on. Perdoo then fetches the value as often as the goal's sync frequency says.
Can Gemini build the report for me?
Yes. In the Create new report panel, describe the data you need in the natural language box and click Create Query with Gemini. The add-on fills in the dimensions, metrics, and date range for you.
Where can I learn more about the add-on?
See Google's guide to the Reports Builder Google Sheets add-on.
Need help?
Start a live chat with our Support team by clicking the question mark at the left or right bottom of your screen.