All Questions
36 questions
17
votes
5
answers
8k
views
Profiling the Performance of a Google App Script
I've written a Google App Script to pull in Google Analytics data into a Google Spreadsheet. It's a fairly long running script making multiple requests to the GA Reporting API, it also uses Google App'...
- 2,724
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 ...
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 ...
- 508
3
votes
0
answers
440
views
Google Scripts User does not have sufficient permissions for this profile. Google Analytics
I am having issues with permissions while reading data from Google Analytics Demo Account to Google Sheets using Google Scripts.
Here is my code:
var tableId = 'ga:54516992'; // this is the correct ...
2
votes
1
answer
462
views
How to use the Google Management API to delete unsampled reports that's pending?
We have Google Analytics Premium.
I would like to delete unsampled reports in Google Sheets / Google Scripts.
I've been getting unsampled reports using the Management API at: https://developers....
- 748
2
votes
1
answer
1k
views
How to request unsampled report from Google Analytics Management API using Google Apps Script?
What I have done:
I have Google Analytics Premium
I have authorized OAuth2 for Apps Script by following this instruction: https://github.com/googlesamples/apps-script-oauth2
I have enabled Google ...
- 55
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 ...
- 826
1
vote
1
answer
195
views
Trigger not working for gs code of Google Analytics
I have a chart to develop. I have published the chart using Google Docs' Spreadsheet. I want the chart to be updated automatically with any change in the data. So I have set a trigger at Midnight-1 AM ...
1
vote
2
answers
2k
views
Google Apps Script: Automated reporting with Google Analytics
I am trying to automate some custom Google Analytics reports with Google Apps Script and output the data into a Google docs spreadsheet. I followed a tutorial and got it working with the following ...
- 33
1
vote
2
answers
2k
views
Error 'Login Required' while calling Google Analytics API from Google Spreadsheet
I use google scripts to fill Google Spreadsheet by Google Analytics data.
Problem: I get error: Login Required when I call =getCountOfNewUsers(B1,B2) from my Spreadsheet file. NOTE: when I run ...
- 4,133
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 ...
- 36.6k
1
vote
0
answers
171
views
Google Apps Script - Google Analytics API - Return undefined
I'm running a script via Google Apps Script to grab data for a website via google analytics api.
The process is running fine and i can't change it to another script language.
For some URLs the ...
- 11
1
vote
2
answers
292
views
Automating Google Analytics Reports
We started using the Google Analytics add-on to do our daily reporting(Google Spreadsheet). Every morning, we run the program to get the previous day's data and copy n paste that data onto our the ...
- 11
1
vote
0
answers
1k
views
How to get the total value using Google Analytics API?
I'm trying to get data from Google Analytics using API with apps script.
I already secceed to get values of each metrics by each dimension but total values are not shown.
On the web view, I can see ...
- 137
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 ...
- 15