Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

Order

112 views
Skip to first unread message

Faisal Ahmed

unread,
Jun 19, 2024, 9:15:04 AM6/19/24
to google-analytics-spreadsheet-add-on
Hi,
I cant find any information on how to use the 'Order' row in GA4 reports.
I want to sort by cost with the highest cost at the top. The way I did it with GA-UA doesnt work anymore. You can see an example in column C below. How do I do this?

Screenshot 2024-06-19 141354.png

Jean-Etienne Juthier

unread,
Jun 19, 2024, 9:19:12 AM6/19/24
to google-analytics-spreadsheet-add-on
Hi,
I tried everything: nothing worked. I now use GA4 Magic Reports, which work with this type of syntax: : metric|screenPageViews__DESC or dimension|yearMonth__ASC

Jeff Schulz

unread,
Jun 19, 2024, 11:53:28 PM6/19/24
to google-analytics-spreadsheet-add-on

Julian Incko

unread,
Feb 3, 2025, 5:16:29 AMFeb 3
to google-analytics-spreadsheet-add-on
Hi Community,

I got the same problem - I can't figure out how to order my results.

Can someone explain to me whether my Syntax is wrong - or is the functionality is currently broken?

Any help would be greatly appreciated!

9bwwkc2ikwfe1.jpeg

I've also tried various other combinations like these - but nothing worked

{"sortOrder":"asc","sortBy":{"dimension":"yearMonth"},"dataType":"string"}

"orderBys":[{"dimension":"yearMonth","desc":false}]

{"dimension":{"orderType":"ALPHANUMERIC","dimensionName":"yearMonth"},"desc":true}

{"desc":false,"dimension":{"dimensionName":"yearMonth"}}

{"desc":false,"dimension":{"yearMonth"}}




Reply all
Reply to author
Forward
0 new messages