Skip to main content

All Questions

0 votes
1 answer
431 views

Loop not working while pulling data from a Google Analytics 4 API - App Script (overcome 10K of rows limit)

I'm trying to retrieve data from a google analytics account. So far, the app script code is working. function runReport(sheetName, dimensionArr, metricArr, startDate, endDate, filters) { let ...
Herman K's user avatar
0 votes
0 answers
592 views

Pull List Account structure Ga4 + export Google Sheets

I would like to pull my Account structure from GA4 in bulk. I have found several scripts but nothing works perfectly (info would be, account title, property ID & Stream ID). Google provides a ...
Tummy's user avatar
  • 1
-1 votes
1 answer
393 views

How can I send GA4 events from apps-script?

I tried to call it like that, but got an error. How can I make this work?
Elad Benda's user avatar
  • 36.6k
0 votes
1 answer
2k views

Using App Script to Pull Reports from GA4 Data API

I am Kinda new to AppScript and wanted to know how I can add multiple dimensions and metrics to the code below as well as how the filtering works. Your help is much appreciated. Here is my reference ...
amirali marvian's user avatar
3 votes
1 answer
3k views

Pull List of GA4 Properties Using Google Analytics Admin API and App Script

Wondering if anyone has experience exporting a list of GA accounts and properties to a spreadsheet using the new Analytics Admin API. I've used the Management API for this purpose in the past but that ...
Geoffrey Bell's user avatar
0 votes
1 answer
438 views

Pulling Data For A List Of URLs Using The Google Analytics Sheets Add-On

I've been looking into The Google Analytics Spreadsheet Add-on, however, currently, it pulls the data for the entire account, I want to pull the data only for specific URLs (new blog posts uploaded ...
seo4lyf's user avatar
0 votes
1 answer
1k views

GA4 | Google Analytics Admin API | Apps Script

I am trying to call the (new) alpha GA Admin API for the simple task of listing all the Accounts that I have access to... I am at a stage where I call the API but I do not get any error message nor I ...
vmorais's user avatar
1 vote
1 answer
355 views

Using Google Analytics to track impressions of shpreadsheet+appscript as UI and BE instead of a website

I want to use apps script as the backend of a spreadhsheet (as the UI. Both serve as a complete website sort of) and track the impressions or click on the spreadsheet buttons. I want to call GA4 from ...
Elad Benda's user avatar
  • 36.6k
0 votes
0 answers
216 views

Google analytics for Google apps-script doesn't show any data after a few weeks

I have an apps-script that I want to impression count in Google-Analytics. I have created a new GA account + data stream. Copied it's measurement id and put it in my app-script code: /** * Function ...
Elad Benda's user avatar
  • 36.6k
0 votes
1 answer
868 views

Create a Google Analytics 4 propery with Google Apps Script

Based on this documentation I'm trying to create a GA4 Property in Google Apps Script: var service = getService(); if (service.hasAccess()) { var apiURL = "https://analyticsadmin....
David M Pino's user avatar
0 votes
2 answers
95 views

If GoogleJsonResponseException: then skip and move to next row

I have a working script. need to improvise to have no manual interruption. We have multiple Profiles in Analytics, sometimes we lose access and sometimes we have. So when i run the Script, If we lost ...
admin2's user avatar
  • 15
0 votes
1 answer
124 views

GA add on - Automated run(Scheduled run) doesn't work

I have a few automated reports on google sheets using the GA add on. Each of these reports have a number of sheets which need to be updated on an automated scheduled run (GA add on ->Scheduled run) ...
Bhargavi Sivapurapu's user avatar
0 votes
1 answer
82 views

Google Analytics API - RemarketingAudiences.insert only working when linkedAdAccounts is AD_WORDS

I'm writing a Google Apps Script for creating audiences in Google Analytics. I keep getting the very unhelpful error message of There was an internal error. As per [this guide][1], I am able to insert ...
Dave Cook's user avatar
  • 717
1 vote
1 answer
239 views

Getting GoogleJsonResponseException but the query is properly built in Google Apps Script

I'm trying to build a custom formula for a Google Sheets spreadsheet. Using Google Apps Script, I'm trying to access the Unique Event Count of an event, with a specific Event Label in a Google ...
mert dökümcü's user avatar
3 votes
1 answer
149 views

Analytics API (Apps Script) Documentation Missing ? | "getItems" vs "items" and other issues

Hi All (and thanks in advance for helping)! I am seriously wondering about the Analytics API (Management API): https://developers.google.com/analytics/devguides/config/mgmt/v3/ Google Sheets / Apps ...
sebieire's user avatar
  • 508

15 30 50 per page