Order DSL for GA4 OrderBy
Use with ga_data to create orderBys
ga_data_order(
x,
type = c("ALPHANUMERIC", "CASE_INSENSITIVE_ALPHANUMERIC", "NUMERIC")
)x |
Order DSL enabled syntax |
type |
Order Type |
The DSL rules are:
Fields can be quoted or unquoted. If unquoted they will be validated
Use + as a prefix to indicate ascending order e.g. +sessions
Use - as a prefix to indicate decreasing order e.g. -sessions
Combine order fields without commas e.g. +sessions -city
Ordering of dimensions can also specify a type of ordering: ALPHANUMERIC, CASE_INSENSITIVE_ALPHANUMERIC, NUMERIC
The dimension ordering have these effects:
ALPHANUMERIC For example, "2" < "A" < "X" < "b" < "z"
CASE_INSENSITIVE_ALPHANUMERIC Case insensitive alphanumeric sort by lower case Unicode code point. For example, "2" < "A" < "b" < "X" < "z"
NUMERIC Dimension values are converted to numbers before sorting. For example in NUMERIC sort, "25" < "100", and in ALPHANUMERIC sort, "100" < "25". Non-numeric dimension values all have equal ordering value below all numeric values
A list of OrderBy objects suitable for use in ga_data
Other GA4 functions:
ga_data_filter(),
ga_data()
# session in descending order
ga_data_order(-sessions)
# city dimension in ascending alphanumeric order
ga_data_order(+city)
# as above plus sessions in descending order
ga_data_order(+city -sessions)
# as above plus activeUsers in ascending order
ga_data_order(+city -sessions +activeUsers)
# dayOfWeek dimension in ascending numeric order
ga_data_order(+dayOfWeek, type = "NUMERIC")
# you can also combine them with c()
a <- ga_data_order(-sessions)
b <- ga_data_order(-dayOfWeek, type = "NUMERIC")
c(a, b)
## Not run:
# example of use
ga_data(
206670707,
metrics = c("activeUsers","sessions"),
dimensions = c("date","city","dayOfWeek"),
date_range = c("2020-03-31", "2020-04-27"),
orderBys = ga_data_order(-sessions -dayOfWeek)
)
## End(Not run)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.