google / google-analytics-utilities Goto Github PK

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.

ReferenceError: templateCd is not defined

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"}

Hi,

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

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

Hi,

The formula in cell C57 (--prop_details_highlights_list--) in the GA Report Settings tab references to cell D28 (--360_props_percent--) but it should reference cell D27 (--props_google_signals_enabled_percent--) instead.

Thanks

Boolean fields gets converted to language locale (i.e. if you use Sheet while your Google account is set to Italian, TRUE is VERO). Hence, they return errors in the functions. Switching Google account language to English solves the issue.

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

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.

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:

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.

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

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.

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

Regards,
Björn

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

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?

How could the users and their permissions be extracted for the UA and GA4 accounts and copied to a sheet?

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.