analyticsData.gs

/**
 * Copyright 2021 Google LLC
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * https://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
// [START apps_script_analyticsdata]
/**
 * Runs a report of a Google Analytics 4 property ID. Creates a sheet with the
 * report.
 */
functionrunReport(){
/**
 * TODO(developer): Uncomment this variable and replace with your
 * Google Analytics 4 property ID before running the sample.
 */
constpropertyId='YOUR-GA4-PROPERTY-ID';

try{
constmetric=AnalyticsData.newMetric();
metric.name='activeUsers';

constdimension=AnalyticsData.newDimension();
dimension.name='city';

constdateRange=AnalyticsData.newDateRange();
dateRange.startDate='2020-03-31';
dateRange.endDate='today';

constrequest=AnalyticsData.newRunReportRequest();
request.dimensions=[dimension];
request.metrics=[metric];
request.dateRanges=dateRange;

constreport=AnalyticsData.Properties.runReport(request,
'properties/'+propertyId);
if(!report.rows){
console.log('No rows returned.');
return;
}

constspreadsheet=SpreadsheetApp.create('Google Analytics Report');
constsheet=spreadsheet.getActiveSheet();

// Append the headers.
constdimensionHeaders=report.dimensionHeaders.map(
(dimensionHeader)=>{
returndimensionHeader.name;
});
constmetricHeaders=report.metricHeaders.map(
(metricHeader)=>{
returnmetricHeader.name;
});
constheaders=[...dimensionHeaders, ...metricHeaders];

sheet.appendRow(headers);

// Append the results.
constrows=report.rows.map((row)=>{
constdimensionValues=row.dimensionValues.map(
(dimensionValue)=>{
returndimensionValue.value;
});
constmetricValues=row.metricValues.map(
(metricValues)=>{
returnmetricValues.value;
});
return[...dimensionValues, ...metricValues];
});

sheet.getRange(2,1,report.rows.length,headers.length)
.setValues(rows);

console.log('Report spreadsheet created: %s',
spreadsheet.getUrl());
}catch(e){
// TODO (Developer) - Handle exception
console.log('Failed with error: %s',e.error);
}
}
// [END apps_script_analyticsdata]