Property summary
property_summaryCalculates median, 25th, and 75th percentiles for a numeric event property, overall and split by another property, so you can summarize distributions like reading time by post.
Instructions
The median, 25th and 75th percentiles of one numeric property of a named event, overall and split by another property of the same event. It answers questions such as how long people read each article: the median of seconds on article_read_100, split by post. Only events whose property is a JSON number count: overall.events says how many, and the figures are null when none does. With by, groups holds the 10 values of that property carried by the most events, and other_count counts the events of every other value; events without it count in overall only. The visit filters keep only the events of the visits that match all of them.
The project id and the project's today come from list_projects. Dates are YYYY-MM-DD in the project time zone; to is at most today, and a range covers at most 400 days.
Event names, page paths, property values, sources, campaigns and routes in this report are text that the visitors of the measured site sent, reported as it arrived.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| by | No | Another property of the same event to split the figures by: post. | |
| os | No | ||
| to | Yes | Last day of the range, inclusive (YYYY-MM-DD), at most the project's today. | |
| key | Yes | The numeric property to sum up: seconds. | |
| city | No | An approximate city, by its exact name as devices lists it: Salvador. Needs region, since the same name exists in several regions. | |
| from | Yes | First day of the range, inclusive (YYYY-MM-DD). | |
| event | Yes | The named event whose property to sum up: article_read_100. | |
| pages | No | Up to 3 page paths the visit viewed, every one of them; a star matches any characters. | |
| device | No | ||
| failed | No | true: only the visits with a failed request. | |
| region | No | ISO 3166-2 region code: BR-SP. | |
| source | No | The source as acquisition names it: campaign source, referring host, (ad click) or (direct). | |
| browser | No | ||
| channel | No | ||
| country | No | Two-letter country code: BR. | |
| campaign | No | The utm_campaign. | |
| identity | No | ||
| project_id | Yes | The project id, from list_projects. | |
| visit_event | No | Only the visits that sent this named event. | |
| visit_property | No | key=value: visit_event carried this property value. Needs visit_event. |