• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Google Analytics Metric/ Field Issue

Alex0101

Member
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!
 
P

Pabblymember11

Guest
Hey @Alex0101

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

Pabblymember11

Guest
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.

1724825187924.png


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/
 
Top