Google Analytics Metric/ Field Issue

[Alex0101]

I keep getting this error message:

Did you mean itemRevenue? Field itemName is not a valid metric. For a list of valid dimensions and metrics, see https://developers.google.com/analytics/devguides/reporting/data/v1/api-schema

but if you check on that link, "itemName" is a valid metric.

Thanks!

 

[Alex0101]

Hi I am trying to automate adding Google Analytics Data to Google Sheet. The information I wanna add on the sheet are:

Date
ItemName
itemsViewed
totalUsers
sessions
totalPurchasers
userEngagementDuration
totalRevenue

Note that those information are all I need on the report but I keep getting an error message saying:

"Did you mean itemRevenue? Field itemName is not a valid metric."

I also tried adding itemName on the dimensions but here's the error:

"Please remove itemName to make the request compatible for example."

Item Name is the most important data we wanna get.

Thanks!

 

[Pabblymember11]

Hey @Alex0101

Can you please share the workflow URL where you experienced this issue so that we can investigate?

 

[Alex0101]

Hey @Alex0101

Can you please share the workflow URL where you experienced this issue so that we can investigate?

Here:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[Pabblymember11]

Regarding your concern, we recommend you use the "Google Analytics: Run Report (GA4) Advance" action step where you need to pass the custom JSON request in the action step according to your required metrics and report which you can get with the help of Query Explorer.

After getting the JSON request you can pass it in the action step.

You can also use the Query Explorer tool to get the desired report with the help of Run ReportGA4 Advance action step accordingly.

https://ga-dev-tools.google/ga4/query-explorer/