Git Product home page Git Product logo

google-analytics-utilities's Introduction

Google Analytics Utilities

This is not an officially supported Google product.

This repository contains an app script that can be used in combination with a Google Spreadsheet to save various information in bulk or individually about Universal Google Analytics accounts, properties, or views to a spreadsheet. Additional information about Google Analytics 4 properties can be saved.

If you find this tool useful, please consider leaving feedback by filling out this quick, anonymous survey.

The script currently performs the following functions:

Resource Capabilities
Account Summaries List
Properties List, Create, Delete, Update
Data Streams List, Create, Delete, Update
Custom Dimensions List, Create, Archive, Update
Custom Metrics List, Create, Archive, Update
Key Events List, Create, Delete
Firebase Links List, Create, Delete
Google Ads Links List, Create, Delete, Update
DV360 Links List, Create, Delete, Update
Audiences Settings List, Create, Delete, Update
SA360 Links List, Create, Delete, Update
BigQuery Links List
User Access Bindings List, Create, Delete, Update
Settings Report Create
Expanded Data Sets List, Create, Delete, Update
Easy Property Creation Create
Channel Groups List, Create, Delete, Update
Measurement Protocol Secrets List, Create, Delete, Update
AdSense Links List, Create, Delete
Event Create Rules List, Create, Delete, Update
Audience Lists List, Create, Check, Export
Subproperty Event Filters List, Create, Delete, Update
Rollup Property Source Links List, Create, Delete

These tasks can be completed by joining the Google Group, copying the template spreadsheet, and clicking on various options under the Google Analytics Utilities menu.

To access information about a given Analytics account, a user must have at least viewer permissions for the accounts, properties, and views they are interested in. If a user wants to create or update settings, they must have editor permissions.

All API requests are subject to the limitations documented here.

How to Access the Spreadsheet

It is strongly recommended that you use the template spreadsheet to use the Google Analytics Utilities script. Follow these steps to make a copy of the template spreadsheet and start using the script:

  1. Join this group to access the spreadsheet.
  2. Create a copy of this spreadsheet.

The spreadsheet is now ready to use the Google Analytics Utilities script. The first time you run a function from the menu, you will need to authorize the permissions for the script and then run the function a second time. You may see a warning that the script is unauthorized. You should be able to proceed anyway. The script does not collect any information.

APIs and Access Permissions

The script makes use of the following APIs/advanced app script services:

  • Google Analytics Admin API
  • Google Analytics Data API
  • Google Drive API
  • BigQuery API

Limited Scope Template

If you are concerned about the access permissions required for the script, then please use this sheet instead. This sheet lacks some of the more advanced features, but it has more restricted scopes.

Check for Updates

It is recommended to periodically run the “Check for Updates” menu item to see if a new version of the tool has been released.

Features

Color Coding

For the GA4 functions, whenever you check a box to archive/delete, create, or update, the sheet will highlight specific cells in each row that need to have values for the given setting to be modified or created. Please see additional details below:

  • If a highlighted cell is empty, a row will remain white.
  • When all the necessary fields have been entered to archive/delete a setting, the row will turn red.
  • When all the necessary fields have been entered to create a setting, the row will turn green.
  • When all the necessary fields have been entered to update a setting, the row will turn blue.

Action Taken Messages

If you archive, delete, create, or update a GA4 setting, then a corresponding action taken will be recorded in the same row. Errors will also be recorded in the “Action Taken” column. If you are missing a necessary value when trying to modify a setting, then that will likely be recorded in the “Action Taken” column taken. If you see “Error 404: HttpResponseException” then you are likely missing a value in the resource name column (or the account ID column in the Property Details sheet) and should probably list your values again.

Account Summaries

List

  1. Navigate to “GA4 Account Summaries”
  2. Click on Google Analytics Utilities > List Account Summaries.
  3. The script will identify all the Google Analytics 4 properties your email has access to and list a flattened table of accounts and properties in the “GA4 Account Summaries” sheet.
    • This sheet can then be used to select specific accounts and properties for other functions.

Properties

List

  1. List GA4 account summaries.
  2. Select each property for which you want to see details.
  3. Navigate to the “GA4 Property Details” sheet.
  4. Click on Google Analytics Utilities > Properties > List.
  5. The selected property details will be listed in the “GA4 Property Details” sheet.

Create

  1. Navigate to the “GA4 Property Details” sheet.
  2. Each row represents a separate data stream. Enter the following information:
    1. Account ID
    2. Property name
    3. Industry category
    4. Time zone
    5. Currency code
    6. Data Retention Duration
      1. Note - The following values are only available for 360 properties:
        1. TWENTY_SIX_MONTHS
        2. THIRTY_EIGHT_MONTHS
        3. FIFTY_MONTHS
    7. Reset User Data on New Activity
    8. Check the box for “Create”
  3. Click on Google Analytics Utilities > Properties > Modify.
  4. The script will attempt to create the selected properties.

Delete

  1. After listing your GA4 data streams, navigate to the “GA4 Property Details” sheet.
  2. Select the data streams you want to delete.
  3. Click on Google Analytics Utilities > Properties > Modify.
  4. The script will attempt to delete the selected properties.

Update

  1. After listing your GA4 data streams, navigate to the “GA4 Property Details” sheet.
  2. Modify any of the following for a given property:
    1. Property Name
    2. Industry category
    3. Time zone
    4. Currency code
    5. Data Retention Duration
      1. Note - The following values are only available for 360 properties:
        1. TWENTY_SIX_MONTHS
        2. THIRTY_EIGHT_MONTHS
        3. FIFTY_MONTHS
    6. Reset User Data on New Activity
  3. Check the “Update” box for each property you want to update.
  4. Click on Google Analytics Utilities > Properties > Modify.
  5. The script will attempt to update the selected properties.

Data Streams

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve data streams.
  3. Navigate to the “GA4 Data Streams” sheet.
  4. Click on Google Analytics Utilities > Data Streams > List.
  5. The data streams for the selected properties will be listed in the “GA4 Data Streams” sheet.

Create

  1. Navigate to the “GA4 Data Streams” sheet.
  2. Each row represents a separate data stream. Enter the following information:
    1. Property ID
    2. Stream Name
    3. Stream type:
      1. WEB_DATA_STREAM
        1. Enter the relevant Enhanced Measurement Settings
        2. Enter the default URI
      2. ANDROID_APP_DATA_STREAM 3. Enter package ID
      3. IOS_APP_DATA_STREAM 4. Enter bundle ID
    4. Check the box for “Create”
  3. Click on Google Analytics Utilities > Data Streams > Modify.
  4. The script will attempt to create the selected data streams.

Delete

  1. After listing your GA4 data streams, navigate to the “GA4 Data Streams” sheet.
  2. Select the data streams you want to delete.
  3. Click on Google Analytics Utilities > Data Streams > Modify.
  4. The script will attempt to delete the selected data streams.

Update

  1. After listing your GA4 data streams, navigate to the “GA4 Data Streams” sheet.
  2. Enter a new stream name for a given data stream.
    1. If the the stream type is WEB_DATA_STREAM, then you can enter the relevant Enhanced Measurement Settings
  3. Check the “Update” box for each data stream you want to update.
  4. Click on Google Analytics Utilities > Data Streams > Modify.
  5. The script will attempt to update the selected data streams.

Custom Dimensions

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve custom dimensions.
  3. Navigate to the “GA4 Custom Dimensions” sheet.
  4. Click on Google Analytics Utilities > Custom Dimensions > List.
  5. The custom dimensions for the selected properties will be listed in the “GA4 Custom Dimensions” sheet.

Create

  1. Navigate to the “GA4 Custom Dimensions” sheet.
  2. Enter the following:
    1. Property ID
    2. Custom dimension name (the name displayed in the UI)
    3. Parameter name (the name collected in the code/tags)
    4. Scope
    5. Description
    6. Whether or not ads personalization is disallowed (true or false)
    7. Check the box for “Create”
    8. Repeat these steps in a new row for each custom dimension you want to create
  3. Click on Google Analytics Utilities > Custom Dimensions > Modify.
  4. The script will attempt to create the selected custom dimensions.

Archive

  1. After listing your GA4 custom dimensions, navigate to the "Custom Dimensions” sheet.
  2. Check the “Archive” box for each custom dimension you want to archive.
  3. Click on Google Analytics Utilities > Custom Dimensions > Modify.
  4. The script will attempt to archive the selected custom dimensions.

Update

  1. After listing your GA4 custom dimensions, navigate to the "Custom Dimensions” sheet.
  2. Enter a new custom dimension name or description for a given custom dimension.
  3. Check the “Update” box for each custom dimension you want to update.
  4. Click on Google Analytics Utilities > Custom Dimensions > Modify.
  5. The script will attempt to update the selected custom dimensions.

Custom Metrics

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve custom dimensions.
  3. Navigate to the “GA4 Custom Metrics” sheet.
  4. Click on Google Analytics Utilities > Custom Metrics > List.
  5. The custom dimensions for the selected properties will be listed in the “GA4 Custom Metrics” sheet.

Create

  1. Navigate to the “GA4 Custom Metrics” sheet.
  2. Enter the following:
    1. Property ID
    2. Custom metric name (the name displayed in the UI)
    3. Parameter name (the name collected in the code/tags)
    4. Scope
    5. Measurement Unit
    6. Description
    7. Check the box for “Create”
    8. Repeat these steps in a new row for each custom metric you want to create
  3. Click on Google Analytics Utilities > Custom Metrics > Modify.
  4. The script will attempt to create the selected custom metrics.

Archive

  1. After listing your GA4 custom metrics, navigate to the "Custom Metrics” sheet.
  2. Check the “Archive” box for each custom metric you want to archive.
  3. Click on Google Analytics Utilities > Custom Metrics > Modify.
  4. The script will attempt to archive the selected custom metrics.

Update

  1. After listing your GA4 custom metrics, navigate to the "Custom Metrics” sheet.
  2. Enter a new custom metric name, description, or measurement unit for a given custom metric.
  3. Check the “Update” box for each custom metric you want to update.
  4. Click on Google Analytics Utilities > Custom Metrics > Modify.
  5. The script will attempt to update the selected custom metrics.

Key Events

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve key events.
  3. Navigate to the “GA4 Key Events” sheet.
  4. Click on Google Analytics Utilities > Key Events > List.
  5. The key events for the selected properties will be listed in the “GA4 Key Events” sheet.

Create

  1. Navigate to the “GA4 Key Events” sheet.
  2. Enter the following:
    1. Property ID
    2. Event name
    3. Check the box for “Create”
    4. Repeat these steps in a new row for each key event you want to create
  3. Click on Google Analytics Utilities > Key Events > Modify.
  4. The script will attempt to create a new key event based on the information in each row.

Delete

  1. After listing your GA4 key events, navigate to the "Key Events” sheet.
  2. Check the “Delete” box for each key event you want to delete.
  3. Click on Google Analytics Utilities > Key Events > Modify.
  4. The script will attempt to delete the selected key events.

Firebase Links

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve Firebase links.
  3. Navigate to the “GA4 Firebase Links” sheet.
  4. Click on Google Analytics Utilities > Firebase Links > List.
  5. The Firebase links for the selected properties will be listed in the “GA4 Firebase Links” sheet.

Create

  1. Navigate to the “GA4 Firebase Links” sheet.
  2. Enter the following:
    1. Property ID
    2. Firebase project ID or name
    3. Check the box for “Create”
    4. Repeat these steps in a new row for each Firebase link you want to create
  3. Click on Google Analytics Utilities > Firebase Links > Modify.
  4. The script will attempt to create a new Firebase link based on the information in each row.

Delete

  1. After listing your GA4 firebase links, navigate to the “GA4 Firebase Links” sheet.
  2. Check the “Delete” box for each Firebase link you want to delete.
  3. Click on Google Analytics Utilities > Firebase Links > Modify.
  4. The script will attempt to delete the selected Firebase links.

Google Ads Links

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve Google Ads links.
  3. Navigate to the “GA4 Google Ads Links” sheet.
  4. Click on Google Analytics Utilities > Links > Google Ads > List.
  5. The Google Ads links for the selected properties will be listed in the “GA4 Google Ads Links” sheet.

Create

  1. Navigate to the “GA4 Google Ads Links” sheet.
  2. Enter the following:
    1. Property ID
    2. Google Ads client ID
    3. True or false for “Ads Personalization Enabled”
    4. Check the box for “Create”
    5. Repeat these steps in a new row for each Google Ads link you want to create
  3. Click on Google Analytics Utilities > Links > Google Ads > Modify.
  4. The script will attempt to create a new Google Ads link based on the information in each row.

Delete

  1. After listing your GA4 Google Ads links, navigate to the “GA4 Google Ads Links” sheet.
  2. Check the “Delete” box for each Google Ads link you want to delete.
  3. Click on Google Analytics Utilities > Links > Google Ads > Modify.
  4. The script will attempt to delete the selected Google Ads links.

Update

  1. After listing your GA4 Google Ads links, navigate to the “GA4 Google Ads Links” sheet.
  2. Enter true or false for “Ads Personalization Enabled”
  3. Check the “Update” box for each Google Ads link you want to update.
  4. Click on Google Analytics Utilities > Links > Google Ads > Modify.
  5. The script will attempt to update the selected Google Ads links.

DV360 Links

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve DV360 links.
  3. Navigate to the “GA4 DV360 Links” sheet.
  4. Click on Google Analytics Utilities > Links > DV360 > List.
  5. The DV360 links for the selected properties will be listed in the “GA4 DV360 Links” sheet.

Create

  1. Navigate to the “GA4 DV360 Links” sheet.
  2. Enter the following:
    1. Property ID
    2. Advertiser ID
    3. True or false for “Ads Personalization Enabled”
    4. True or false for “Campaign Data Sharing Enabled”
    5. True or false for “Cost Data Sharing Enabled”
    6. Check the box for “Create”
    7. Repeat these steps in a new row for each DV360 link you want to create
  3. Click on Google Analytics Utilities > Links > DV360 > Modify.
  4. The script will attempt to create a new DV360 link based on the information in each row.

Delete

  1. After listing your GA4 DV360 links, navigate to the “GA4 DV360 Links” sheet.
  2. Check the “Delete” box for each DV360 link you want to delete.
  3. Click on Google Analytics Utilities > Links > DV360 > Modify.
  4. The script will attempt to delete the selected DV360 links.

Update

  1. After listing your GA4 DV360 links, navigate to the “GA4 DV360 Links” sheet.
  2. Enter true or false for “Ads Personalization Enabled”
  3. Check the “Update” box for each DV360 link you want to update.
  4. Click on Google Analytics Utilities > Links > DV360 > Modify.
  5. The script will attempt to update the selected DV360 links.

GA4 Audiences

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve audiences.
  3. Navigate to the “GA4 Audiences” sheet.
  4. Click on Google Analytics Utilities > Audiences > List.
  5. The audiences for the selected properties will be listed in the “GA4 Audiences” sheet.

Create

  1. Navigate to the “GA4 Audiences” sheet.
  2. Enter the following:
    1. Property ID
    2. Audience Name
    3. Audience Description
    4. Membership Duration
    5. Filter Clauses
    6. (Optional) Event Trigger Name
    7. (Optional) Event Trigger Log Condition
    8. (Only set with exclusion filter conditions) Exclusion Duration Mode
    9. Repeat these steps in a new row for each audience you want to create
  3. Click on Google Analytics Utilities > Audiences > Modify.
  4. The script will attempt to create a new audience based on the information in each row.

Delete

  1. After listing your GA4 audiences, navigate to the “GA4 Audiences” sheet.
  2. Check the “Delete” box for each audience link you want to delete.
  3. Click on Google Analytics Utilities > Audiences > Modify.
  4. The script will attempt to delete the selected audiences.

Update

  1. After listing your GA4 audiences, navigate to the “GA4 Audiences” sheet.
  2. The following can be updated:
    1. Audience Name
    2. Audience Description
  3. Check the “Update” box for each audience you want to update.
  4. Click on Google Analytics Utilities > Audience > Modify.
  5. The script will attempt to update the selected audience.

SA360 Links

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve SA360 links.
  3. Navigate to the “GA4 SA360 Links” sheet.
  4. Click on Google Analytics Utilities > Links > SA360 > List.
  5. The SA360 links for the selected properties will be listed in the “GA4 SA360 Links” sheet.

Create

  1. Navigate to the “GA4 SA360 Links” sheet.
  2. Enter the following:
    1. Property ID
    2. Advertiser ID
    3. True or false for “Ads Personalization Enabled”
    4. True or false for “Campaign Data Sharing Enabled”
    5. True or false for “Cost Data Sharing Enabled”
    6. True or false for “Site States Sharing Enabled”
    7. Check the box for “Create”
    8. Repeat these steps in a new row for each SA360 link you want to create
  3. Click on Google Analytics Utilities > Links > SA360 > Modify.
  4. The script will attempt to create a new SA360 link based on the information in each row.

Delete

  1. After listing your GA4 SA360 links, navigate to the “GA4 SA360 Links” sheet.
  2. Check the “Delete” box for each SA360 link you want to delete.
  3. Click on Google Analytics Utilities > Links > SA360 > Modify.
  4. The script will attempt to delete the selected SA360 links.

Update

  1. After listing your GA4 SA360 links, navigate to the “GA4 SA360 Links” sheet.
  2. Edit the following:
    1. Enter true or false for “Ads Personalization Enabled”
    2. Enter true or false for “Site States Sharing Enabled”
  3. Check the “Update” box for each SA360 link you want to update.
  4. Click on Google Analytics Utilities > Links > SA360 > Modify.
  5. The script will attempt to update the selected SA360 links.

BigQuery Links

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve BigQuery links.
  3. Navigate to the “GA4 BigQuery Links” sheet.
  4. Click on Google Analytics Utilities > Links > BigQuery > List.
  5. The BigQuery links for the selected properties will be listed in the “GA4 BigQuery Links” sheet.

Expanded Data Sets

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve expanded data sets.
  3. Navigate to the “GA4 Expanded Data Sets” sheet.
  4. Click Google Analytics Utilities > Expanded Data Sets > List.
  5. Expanded data sets for the selected properties will be listed in the “GA4 Expanded Data Sets” sheet.

Create

  1. Navigate to “GA4 Expanded Data Sets”.
  2. Enter the following for each expanded data set you want to create:
    1. Property ID
    2. Expanded data set name
    3. Description (optional)
    4. A comma separated list of dimension names
    5. A comma separated list of metric names
    6. A filter expression (optional)
    7. Check the “Create” box
  3. Click Google Analytics Utilities > Expanded Data Sets > Modify.
  4. The script will attempt to create new expanded data sets. NOTE: The script will not validate if a given combination of dimensions and metrics can be used in an expanded data set.

Update

  1. List your expanded data sets.
  2. Navigate to “GA4 Expanded Data Sets”.
  3. Modify the following for each expanded data set you want to update:
    1. Display Name
    2. Description
    3. Check the “Update” box
  4. Click Google Analytics Utilities > Expanded Data Sets > Modify.
  5. The script will attempt to update the expanded data sets.

Delete

  1. List your expanded data sets.
  2. Navigate to “GA4 Expanded Data Sets”.
  3. Check the “Delete” box for the expanded data sets you want to delete.
  4. Click Google Analytics Utilities > Expanded Data Sets > Modify.
  5. The script will attempt to delete the expanded data sets.

GA4 Users

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve access bindings.
  3. Navigate to the “GA4 Users” sheet.
  4. Click on Google Analytics Utilities > Users > List.
  5. The access bindings for the selected properties will be listed in the “GA4 Users” sheet. Access bindings will only be displayed if the user requesting the information has the necessary permissions. If possible, the access bindings for the accounts associated with each property will also be listed.

Create

  1. Navigate to the “GA4 Users” sheet.
  2. Enter the following in a new row:
    1. Account Access Binding:
      1. Account ID
      2. User Email
      3. Primary permissions - Must be one of the following:
        1. predefinedRoles/viewer
        2. predefinedRoles/analyst
        3. predefinedRoles/editor
        4. predefinedRoles/admin
      4. Secondary Permissions - Can be one of the following: 5. Blank 6. predefinedRoles/no-cost-data 7. predefinedRoles/no-revenue-data 8. predefinedRoles/no-cost-data, predefinedRoles/no-revenue-data
    2. Property Access Binding: 5. Account ID 6. Property ID 7. User Email 8. Primary permissions - Must be one of the following: 9. predefinedRoles/viewer 10. predefinedRoles/analyst 11. predefinedRoles/editor 12. predefinedRoles/admin 9. Secondary Permissions - Can be one of the following: 13. Blank 14. predefinedRoles/no-cost-data 15. predefinedRoles/no-revenue-data 16. predefinedRoles/no-cost-data, predefinedRoles/no-revenue-data
  3. Check the “Create” box for the row.
  4. Click on Google Analytics Utilities > Users > Modify.
  5. The script will attempt to create a new access binding based on the information in each row. Batching is not used.

Delete

  1. After listing your GA4 access bindings, navigate to the “GA4 Users” sheet.
  2. Check the “Delete” box for each access binding you want to delete.
  3. Click on Google Analytics Utilities > Users > Modify.
  4. The script will attempt to delete the selected access bindings. Batching is not used.

Update

  1. After listing your GA4 access bindings, navigate to the “GA4 Users” sheet.
  2. The following can be updated:
    1. Primary Permissions
    2. Secondary Permissions
  3. Check the “Update” box for each access binding you want to update.
  4. Click on Google Analytics Utilities > Users > Modify.
  5. The script will attempt to update the selected access bindings. Batching is not used.

GA4 Settings Report

Create a Report

  1. List GA4 account summaries.
  2. Select the properties for which you want to generate a report.
  3. Navigate to the “GA4 Report Settings” sheet.
  4. Enter the information as indicated for rows 4-9.
    1. If the “Template Slides URL” value is left as “Default” or is blank, then the default template will be used. Otherwise, a Google Slides URL of a template presentation must be provided.
    2. If the box for “Request New Settings Information” is checked, then GA Utilities will automatically list new information for several different GA4 sheets. This newly listed information will clear any existing settings listed in the sheets. This includes the following sheets:
      1. GA4 Property Details
      2. GA4 Audiences
      3. GA4 Data Streams
      4. GA4 Key Events
      5. GA4 Custom Dimensions
      6. GA4 Custom Metrics
      7. GA4 Google Ads Links
      8. GA4 DV360 Links
      9. GA4 Firebase Links
  5. The placeholder rows starting at row 10 can be added to, removed, or changed as you prefer. Each column works in the following way:
    1. Placeholder Text: This is the placeholder text found in the template spreadsheet. Each placeholder text can only be used once per slide. A placeholder can be whatever you want, but the behavior of the script will change if any of the following words are used:
      1. percent: If the word “percent” (all in lowercase) is used in the placeholder, then the value in the slide will be properly formatted as a percent and will change color depending on the information entered for the percent range color scale. The value in the spreadsheet must be a number.
      2. image, graphic, or logo: If the image, graphic, or logo (all lowercase) are used in the placeholder, then the value must be a URL that points to an image. The script will then try to swap out the placeholder in the template with the image from the URL.
      3. list: If the word “list” is used in the placeholder, then the script will try to create a bulleted list in the slide based on the value in the spreadsheet. The value in the spreadsheet will be split by the presence of double semicolons (;;). For example, the following would be split into two bullet points: hello, world;;example list. You can either construct a list value in a single line, or you can have multiple rows with the exact same placeholder name and the script will create a list for you from those rows.
    2. Template Slide: The template slide column is used to determine which slide a given placeholder text belongs to. The template slide text must exist in the speaker notes section for a given slide in order for the script to identify the correct slide.
    3. Include: Either check the box or use a formula to determine if a placeholder should be considered when building the final presentation.
    4. Value: The final value that will appear on the slide where the placeholder text is present.
  6. If your template includes one or more slides that need to be duplicated, then you must navigate to the “GA4 Report Settings - Snapshot” sheet and enter settings for those slides. This sheet can be customized in the following way:
    1. Column A: Contains the property ID for a given GA4 property and is included to make it easier to create formulas in other columns.
    2. Column B: Contains the template slide placeholder and is used to identify the template slide.
    3. Columns C+: The headers for these columns should contain the placeholder text that will be swapped with a real value when the report is complete. Every row after the header should have a value for that specific property. These values can be derived from the other GA Utilities sheets or entered as plain text. The placeholder name rules are the same as previously stated: percent formats the number value as a percent on the slide, list creates a bulleted list, image/graphic/logo uses a provided URL as an image, and any other name just replaces the value on the slide as is.
  7. Once all values have been entered, click GA Utilities > Advanced > Health Report > Create Report
  8. Once the health report has been created, a link to the report and the date of its creation will be appended to columns F and G in the “GA4 Report Settings” sheet. The date of creation will default to MM-DD-YYYY format, but that can be reformatted if you so wish.
  9. Review the new report and make any necessary adjustments. There may be some placeholders that aren’t removed if said placeholder was not included in the sheet but was present in the template. This is expected and you should delete the placeholder manually. You may also need to adjust image sizes, which is expected.

Easy Property Creation

List

  1. List GA4 account summaries.
  2. Select the properties you want to use as templates.
  3. Navigate to the “GA4 Easy Property Creation” sheet.
  4. Click on Google Analytics Utilities > Advanced > Easy Property Creation > List Templates.
  5. The selected properties and many of their associated settings will be listed in the “GA4 Easy Property Creation” sheet.

Create

  1. Navigate to the “GA4 Easy Property Creation” sheet.
  2. Enter the following in the row for the property you want to make a copy of. If necessary, you can make copy the property settings into multiple rows:
    1. Account ID for New Property
    2. New Property Name
  3. (Optional) If necessary, edit, add, or remove any of the settings in the various columns.
  4. Check the “Create” box for each row you want to use to make a property.
  5. Click on Google Analytics Utilities > Advanced > Easy Property Creation > Create Properties.
  6. The script will attempt to create a new property for each selected row and will also create the various settings (i.e. data streams, audiences, key events, etc.) in the columns. Note: Due to limitations with the API, Google Signals will not be enabled in the newly created properties even if the template properties had Google Signals enabled.

Channel Groups

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve channel groups.
  3. Navigate to the “GA4 Channel Groups” sheet.
  4. Click Google Analytics Utilities > Channel Groups > List.
  5. Channel Groups for the selected properties will be listed in the “GA4 Channel Groups” sheet.

Create

  1. Navigate to “GA4 Channel Groups”.
  2. Enter the following for each channel group you want to create:
    1. Property ID
    2. Channel group name
    3. Description (optional)
    4. Grouping rule as defined here
    5. Check the “Create” box
  3. Click Google Analytics Utilities > Channel Groups > Modify.
  4. The script will attempt to create new channel groups.

Update

  1. List your channel groups.
  2. Navigate to “GA4 Channel Groups”.
  3. Modify the following for each channel group you want to update:
    1. Channel Group Name
    2. Description
    3. Grouping rule
    4. Check the “Update” box
  4. Click Google Analytics Utilities > Channel Groups > Modify.
  5. The script will attempt to update the channel groups.

Delete

  1. List your channel groups.
  2. Navigate to “GA4 Channel Groups”.
  3. Check the “Delete” box for the channel groups you want to delete.
  4. Click Google Analytics Utilities > Channel Groups > Modify.
  5. The script will attempt to delete the channel groups.

Measurement Protocol Secrets

List

  1. List GA4 account summaries.
  2. Select the properties for which you want to list their data streams.
  3. Navigate to "Data Stream Selection".
  4. Click Google Analytics Utilities > List Data Stream Selection.
  5. Select the data streams for which you want to list their measurement protocol secrets.
  6. Click Google Analytics Utilities > Measurement Protocol Secrets > List.
  7. Measurement Protocol Secrets for the selected data streams will be listed in the “GA4 Measurement Protocol Secrets” sheet.

Create

  1. Navigate to “GA4 Measurement Protocol Secrets”.
  2. Enter the following for each measurement protocol secret you want to create:
    1. Property ID
    2. Data Stream ID
    3. Measurement Protocol Secret Name
    4. Check the “Create” box
  3. Click Google Analytics Utilities > Measurement Protocol Secrets > Modify.
  4. The script will attempt to create new measurement protocol secrets.

Update

  1. List your measurement protocol secrets.
  2. Navigate to “GA4 Measurement Protocol Secrets”.
  3. Modify the following for each measurement protocol secret you want to update:
    1. Measurement Protocol Secret Name
    2. Check the “Update” box
  4. Click Google Analytics Utilities > Measurement Protocol Secrets > Modify.
  5. The script will attempt to update the measurement protocol secrets.

Delete

  1. List your measurement protocol secrets.
  2. Navigate to “GA4 Measurement Protocol Secrets”.
  3. Check the “Delete” box for the measurement protocol secrets you want to delete.
  4. Click Google Analytics Utilities > Measurement Protocol Secrets > Modify.
  5. The script will attempt to delete the measurement protocol secrets.

AdSense Links

List

  1. List GA4 account summaries.
  2. Select the properties from which you want to retrieve AdSense Links.
  3. Navigate to the “GA4 AdSense Links” sheet.
  4. Click Google Analytics Utilities > Links > AdSense > List.
  5. AdSense links for the selected properties will be listed in the “GA4 AdSense Links” sheet.

Create

  1. Navigate to “GA4 AdSense Links”.
  2. Enter the following for each AdSense link you want to create:
    1. Property ID
    2. Ad Client ID
    3. Check the “Create” box
  3. Click Google Analytics Utilities > Links > AdSense > Modify.
  4. The script will attempt to create new AdSense links.

Delete

  1. List your AdSense links.
  2. Navigate to “GA4 AdSense Links”.
  3. Check the “Delete” box for the AdSense links you want to delete.
  4. Click Google Analytics Utilities > Links > AdSense > Modify.
  5. The script will attempt to delete the AdSense links.

Event Create Rules

List

  1. List GA4 account summaries.
  2. Select the properties for which you want to list their data streams.
  3. Navigate to "Data Stream Selection".
  4. Click Google Analytics Utilities > List Data Stream Selection.
  5. Select the data streams for which you want to list their event create rules.
  6. Click Google Analytics Utilities > Event Create Rules > List.
  7. Event Create Rules for the selected data streams will be listed in the “GA4 Event Create Rules” sheet.

Create

  1. Navigate to “GA4 Event Create Rules”.
  2. Enter the following for each event create rule you want to create:
    1. Property ID
    2. Data Stream ID
    3. Destination Event Name
    4. (Optional) Copy Source Parameters
    5. (Optional) Event Conditions
    6. (Optional) Parameter Mutations
    7. Check the “Create” box
  3. Click Google Analytics Utilities > Event Create Rules > Modify.
  4. The script will attempt to create new event create rules.

Update

  1. List your event create rules.
  2. Navigate to “GA4 Event Create Rules”.
  3. Modify the following for each event create rule you want to update:
    1. Destination Event Name
    2. (Optional) Copy Source Parameters
    3. (Optional) Event Conditions
    4. (Optional) Parameter Mutations
    5. Check the “Update” box
  4. Click Google Analytics Utilities > Event Create Rules > Modify.
  5. The script will attempt to update the event create rules.

Delete

  1. List your event create rules.
  2. Navigate to “GA4 Event Create Rules”.
  3. Check the “Delete” box for the event create rules you want to delete.
  4. Click Google Analytics Utilities > Event Create Rules > Modify.
  5. The script will attempt to delete the event create rules.

Audience Lists

List

  1. List GA4 account summaries.
  2. Select the properties for which you want to list audience lists.
  3. Navigate to the "Audience Lists" sheet.
  4. Click Google Analytics Utilities > Advanced > Audience Lists > List Audience Lists.
  5. The Audience Lists for the selected properties will be listed in the “GA4 Audience Lists” sheet.

Create

  1. Navigate to “GA4 Audience Lists”.
  2. Enter the following for each event create rule you want to create. It is suggesteed that you click Google Analytics Utilities > Advanced > Audience Lists > List Existing Audiences to list the following information automatically in your sheet:
    1. Property ID
    2. Audience Resource Name
    3. A comma separated list of dimensions (E.g. deviceId, userId)
    4. Check the “Create” box
  3. Click Google Analytics Utilities > Advanced > Audience Lists > Create Audience Lists.
  4. The script will attempt to create audience lists.

Check State

To check the state of your audience lists, you can either list the audience lists in a property or retrieve the state for a single audience list by going through the following steps.

  1. Navigate to “GA4 Audience Lists”.
  2. Enter the following for each audience list you want to check:
    1. Audience List Resource Name
    2. Check the “Check State” box
  3. Click Google Analytics Utilities > Advanced > Audience Lists > Check Audience List States.
  4. The script will attempt to check the state for the selected audience lists.

Export

Currently, the Google Anaytics Utilities can export audience list dimensions either to a new spreadsheet, and existing spreadsheet, or an existing empty BigQuery table. It is not recommended that you try to export more than 100 - 150 thousand users total at one time across all of your audience lists selected for export. If you choose more than this, the scritp may throw an error and fail to properly export the users in one or more audience lists.

  1. Navigate to “GA4 Audience Lists”.
  2. List your audience lists by clicking on Google Analytics Utilities > Advanced > Audience Lists > List Audience Lists.
  3. For a given audience, make sure the following is entered:
    1. Audience List Resource Name
    2. Output Location is set to either "Spreadsheet" or "BigQuery"
    3. If the output location is "Spreadsheet":
      1. If you want to export to a new spreadsheet, check the new spreadsheet box
      2. If you want to export to an existing spreadsheet, leave the new spreadsheet box unchecked and enter the URL for the new spreadsheet.
    4. If the output location is "BigQuery":
      1. Enter the existing project and dataset names.
      2. Enter the name for new table that will be created by the script and poplulated with the audience export data. The table should not already exist in BigQuery.
    5. Check the "Export" box
  4. Click Google Analytics Utilities > Advanced > Audience Lists > Export Audience Lists.
  5. The script will attempt to export the audience lists users to a the chosen export locations. As indicated above, if the audience lists are too large, the export may fail.

Subproperty Event Filters

List

  1. List GA4 account summaries.
  2. Select the properties for which you want to list their subproperty filter events.
  3. Navigate to "Subproperty Filter Events".
  4. Click Google Analytics Utilities > Subproperty Filter Events > List.
  5. Subproperty event filters for the selected properties will be listed in the “GA4 Subproperty Event Filters” sheet.

Create

  1. Navigate to “GA4 Subproperty Event Filters”.
  2. Enter the following for each subproperty event filter you want to create:
    1. Property ID (this is the parent property)
    2. Apply to property (this is the subproperty the filter will be applied to)
    3. Filter clauses
    4. Check the “Create” box
  3. Click Google Analytics Utilities > Subproperty Event Filters > Modify.
  4. The script will attempt to create new subproperty event filters.

Update

  1. List your subproperty event filters.
  2. Navigate to “GA4 Subproperty Event Filters”.
  3. Modify the following for each subproperty event filter you want to update:
    1. Filter clauses
    2. Check the “Update” box
  4. Click Google Analytics Utilities > Subproperty Event Filters > Modify.
  5. The script will attempt to update the subproperty event filters.

Delete

  1. List your subproperty event filters.
  2. Navigate to “GA4 Subproperty Event Filters”.
  3. Check the “Delete” box for the subproperty event filters you want to delete.
  4. Click Google Analytics Utilities > Subproperty Event Filters > Modify.
  5. The script will attempt to delete the subproperty event filters.

Rollup Property Source Links

List

  1. List GA4 account summaries.
  2. Select the properties for which you want to list their rollup property source links.
  3. Navigate to "Rollup Property Source Links".
  4. Click Google Analytics Utilities > Rollup Property Source Links > List.
  5. Rollup property source links for the selected properties will be listed in the “GA4 Rollup Property Source Links” sheet.

Create

  1. Navigate to “GA4 Rollup Property Source Links”.
  2. Enter the following for each rollup property source link you want to create:
    1. Property ID (this is the rollup property)
    2. Source Link ID (this is the property ID for the source property in the format properties/ID_NUMBER)
    3. Check the “Create” box
  3. Click Google Analytics Utilities > Rollup Property Source Links > Modify.
  4. The script will attempt to create new rollup property source links.

Delete

  1. List your rollup property source links.
  2. Navigate to “GA4 Rollup Property Source Links”.
  3. Check the “Delete” box for the rollup property source links you want to delete.
  4. Click Google Analytics Utilities > Rollup Property Source Links > Modify.
  5. The script will attempt to delete the rollup property source links.

google-analytics-utilities's People

Contributors

b-kuehn avatar mrbock avatar pgilmon avatar

Stargazers

avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar

Watchers

avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar

Forkers

informaticacba ressmann manishgandotra isabella232 physolia luratic-devs epanic test-mass-forker-org-1 mrbock afelipeg jadecolpani ekusiadadus ivan-toriya-precis bpointhq jrathore jaimeapo liamyoungrwo mimobr gabrieltrinidad0101 myherbai thecodeofmontecristo

google-analytics-utilities's Issues

GA4 Google Signals Settings and Data Retention Settings not updating

I tried updating several times the GA4 Google Signals Settings and Data Retention Settings. I get an updated message, but when checking in the interface I don't see the change. When I get the property information again via List then I get the original (not updated) setting.

Is this a (known) bug?

nonwhitespace character at 490

Hi there!

We are using this utility to try to automate creation of Audiences but there is an error nonwhitespace character at 490.

In the JSON we have an EXCLUDE clausetype and the initial thought is that there is a limitation when using EXCLUDE.

After checking the docs and not finding any resolution, I think this might be expected behavior when EXCLUDING Audiences but I wanted to check here by filing an issue.

Does this utility work when EXCLUDING Audiences?

Thank you.

See JSON below

{
    "clauseType": "INCLUDE",
    "simpleFilter":
    {
        "scope": "AUDIENCE_FILTER_SCOPE_WITHIN_SAME_SESSION",
        "filterExpression":
        {
            "andGroup":
            {
                "filterExpressions": [
                {
                    "orGroup":
                    {
                        "filterExpressions": [
                        {
                            "dimensionOrMetricFilter":
                            {
                                "fieldName": "unifiedPagePathScreen",
                                "stringFilter":
                                {
                                    "value": "verterra",
                                    "matchType": "CONTAINS"                                },
                                "atAnyPointInTime": true                            }
                        },
                        {
                            "dimensionOrMetricFilter":
                            {
                                "fieldName": "unifiedPagePathScreen",
                                "stringFilter":
                                {
                                    "matchType": "CONTAINS",
                                    "value": "/events/alc-tvr"                                },
                                "atAnyPointInTime": true                            }
                        }]
                    }
                }]
            }
        }
    }
},
{
    "simpleFilter":
    {
        "scope": "AUDIENCE_FILTER_SCOPE_ACROSS_ALL_SESSIONS",
        "filterExpression":
        {
            "andGroup":
            {
                "filterExpressions": [
                {
                    "orGroup":
                    {
                        "filterExpressions": [
                        {
                            "dimensionOrMetricFilter":
                            {
                                "atAnyPointInTime": true,
                                "stringFilter":
                                {
                                    "matchType": "CONTAINS",
                                    "value": "form complete"                                },
                                "fieldName": "event_action"                            }
                        },
                        {
                            "dimensionOrMetricFilter":
                            {
                                "fieldName": "unifiedPagePathScreen",
                                "stringFilter":
                                {
                                    "value": "/investor",
                                    "matchType": "CONTAINS"                                },
                                "atAnyPointInTime": true                            }
                        }]
                    }
                }]
            }
        }
    },
    "clauseType": "EXCLUDE"}

property lists multiple times

I have just created a copy of your tool, and tried to get an overview over my properties.
The script runs quite long for some reason.

Afterwards, in the property details list, I get the same properties multiple times:
image

Updating Data Streams returns error

The payload builder references the wrong entities when updating the Data Streams.

In the new_analytics/modifyGA4Entities.gs file. the buildUpdatePayload function needs to be updated on row 305, 309, 313 changing the index to 7, 8 and 9 respectively

This App is blocked

Hi everyone,

we have followed the instructions, but we cannot authorize the App/scripts within the sheet.

Message translated to English: This App has been blocked. The App tried to access confidential information.
image

Where can we unblock the script?
Which permissions should the account have, which is used running the scripts of the sheet?

Regards,
Björn

Column issues in property-details

Hi @b-kuehn, I discovered an issue I'd like to share.

The feature "list properties" will write the details of the selected properties into the sheet "GA4 Property Details" with Data Retention Duration & Reset User Data on New Activity in Columns Q and R

The "update" function though will use values from columns N (Service Level) and O (Number of Events Over the Past 7 Days) and thus fail.

image

With values for data retention in columns N and O it will work:
image

Request had insufficient authentication scopes | UA Custom Dimensions - Modify

When trying to copy dimensions in Universal Analytics I get the following scope error:

image
GoogleJsonResponseException: API call to analytics.management.customDimensions.insert failed with error: Request had insufficient authentication scopes.

I'm able to list both UA and GA4 Account Summary - and its connected to a GCP project.
And also able to list both Template and Destination sections of the sheet.

Fresh copy of the sheet as of today.

[UA -> GA4 Audiences migration] How to translate and setup custom events ?

Thank you to all the developers for the work on great tools to help with the UA -> GA4 migrations.
I have a question and I am not entirely sure if it belongs here - please redirect me to the correct please if it so.

I am trying to migrate some UA custom audiences to GA4. I am having troubles to "translate" the custom events.
The problem is that the migration tool succeeds to migrate the audience seemingly but the new audience definition does not appear in GA4.

I am looking for some help or pointers on how to achieve the following.
If the customer came from a google/cpc click and landed on a category page C - then I would like to add this customer to an audience. Here C is just a name of a category like e.g. Music Vinyls. Also I have the category ID available in GA4 e.g. 123.

So far i have:

users::condition::sessionMedium=@cpc
condition::ga:sessionSource=@google

# in UA i used to have:
sequence::^ga:landingContentGroup4=@MusicVinyls

# in GA4 i tried with
sequence::eventName::categoryID=@123

I would be very grateful for some pointers to how to do this, what might be going wrong or where to go look further. Please let me know if this is not the appropriate channel for my ask as well. Thank you in advance.

Error trying to Create Custom Dimensions

I'm not able to copy any selected Custom Dimensions over to the Destination Property.

Using the UA Custom Dimensions - Modify both listings for template and destination are working.
Selecting the CD indexes and a destination property the scripts throws this error when running the Universal Analytics > Custom Dimensions > Modify Custom Dimensions > Modify Custom Dimensions command.

image
ReferenceError: templateCd is not defined

Feature Request - UA Goals with Funnels

Universal Analytics Goal List does not provide the standard export data from the Management API; the JSON returned provides the funnel for URL_Destination Goals.

Insight into these funnel configurations can provide clearer direction when translating UA->GA4. It drives a strategic conversation with site owners around the uniqueness of a funnel's contents. It helps to decide between one funnel_steps event with parameters illustrating the different step numbers/names vs. individual funnel_stepN events for each one of the paths previously listed in the UA Goal.

Management API: with a 1 step required funnel as a short example

{
      "id": "11",
      "kind": "analytics#goal",
      "selfLink": "https://www.googleapis.com/analytics/v3/management/accounts/XXXXXXXX/webproperties/UA-XXXXXXXXX-8/profiles/XXXXXXXX/goals/11",
      "accountId": "XXXXXXXX",
      "webPropertyId": "UA-XXXXXXXX-8",
      "internalWebPropertyId": "XXXXXXXXXX",
      "profileId": "XXXXXXXXX",
      "name": "LP \u003e\u003e order",
      "value": 0,
      "active": true,
      "type": "URL_DESTINATION",
      "created": "2019-06-26T16:52:02.163Z",
      "updated": "2019-06-29T00:29:51.287Z",
      "parentLink": {
        "type": "analytics#profile",
        "href": "https://www.googleapis.com/analytics/v3/management/accounts/XXXXXXXX/webproperties/UA-XXXXXXXX-8/profiles/XXXXXXXX"
      },
      "urlDestinationDetails": {
        "url": "^\/summary\/(.*)confirmed",
        "caseSensitive": false,
        "matchType": "REGEX",
        "firstStepRequired": true,
        "steps": [
          {
            "number": 1,
            "name": "Zava",
            "URL": "^/zava\-"
          }
        ]
      }
    }

**Utilities:** with no indication that a funnel exists for this URL Destination

image

Pop is not defined

Hi,

After trying to list the properties I get a message: pop is not defined. Account is slected as instructed.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.