What is levels of detail?
Levels of detail are the various aspects or categories of your data. Think of them as the what of your data. These could be dates, locations, users, resources, services, etc. Levels of detail give you the context of your data, allowing you to break down your analysis into specific parts or to view your data from different angles.
For more information about Metrics, Levels of detail, and how they differ, see
Levels of detail glossary
Below is a glossary of all available levels of detail and a description of how they break down your data:
Category | Display name | CSV header name | Definition |
Account | Account ID | ACCOUNT_ID | The unique ID associated to the account. |
Account | Billing account ID | BILLING_ACCOUNT_ID | The ID of the account associated with all billing for a company. |
Account | Billing email | BILLING_EMAIL | The email address of the account associated with all billing for a company. |
Account | Business name | ACCOUNT_BUSINESS_NAME | The business name set upon account creation. |
Account | Organization ID | ORGANIZATION_ID | The unique ID that is associated with a group of accounts under the same company. |
Account | Plan type | PLAN_ID | The subscription plan type assigned to the account currently. |
Data fields | Input field ID | DATA_FIELD_ID | The unique data field ID associated with custom input fields. |
Data fields | Input field name | DATA_FIELD_NAME | The name of the data field associated with custom input fields. |
Data fields | Input field type | DATA_FIELD_TYPE | The type of input for the data field. Example: CHECKBOX, CHOICE, TEXT, NUMBER |
Data fields | Input field values | DATA_FIELD_VALUES | The input values associated with the data field name. |
Financials | Order value currency | ORDER_VALUE_CURRENCY | The currency associated with the order value. |
Location | Business name within location | LOCATION_BUSINESS_NAME | The business name assigned in the location settings. |
Location | Location Address 1 | LOCATION_ADDRESS_1 | The address of the location. |
Location | Location Address 2 | LOCATION_ADDRESS_2 | The second line of the locations address |
Location | Location City | LOCATION_CITY | The city of the location |
Location | Location country | LOCATION_COUNTRY | The country assigned in location settings. |
Location | Location ID | LOCATION_ID | The unique ID associated with the location. One account can have many location IDs. Location IDs cannot have more than one associated account ID. |
Location | Location is active | LOCATION_ACTIVE | An indicator if a location is active. TRUE and NULL values indicate the location is active. FALSE indicates the location is not active. Only based on the current value. |
Location | Location is active in range | LOCATION_ACTIVE_IN_RANGE | An indicator if a location was ever active within the report's start and end date. TRUE indicates the location was active at one point in the report date range. |
Location | Location is deleted | LOCATION_DELETED | An indicator if a location is active. FALSE and NULL values indicate the location is not deleted. TRUE indicates the location is not active. Only based on current value. |
Location | Location is not deleted in range | LOCATION_NOT_DELETED_IN_RANGE | An indicator if a location was ever not deleted within the report's start and end date. TRUE indicates the location was marked as not deleted at one point in the report date range. |
Location | Location name | LOCATION_NAME | The full location name. |
Location | Location short name | LOCATION_SHORT_NAME | The shortened name associated to a location. |
Location | Location state | LOCATION_STATE_CODE | The state abbreviation associated to the location. |
Location | Location Zip Code | LOCATION_ZIP_CODE | The zip code of the location |
Location | Provisioned Phone Number | PROVISIONED_PHONE_NUMBER | The sending phone number(s) that were provisioned for the location |
Resources | Resource cateogry name | RESOURCE_CATEGORY_NAME | The category name associated to a resource. Multiple resources can be assigned to a category. |
Resources | Resource ID | RESOURCE_ID | The unique ID associated with a resource. |
Resources | Resource name | RESOURCE_NAME | The name of the resource. |
Services | Service category name | SERVICE_CATEGORY_NAME | The category name associated to a service. Multiple services can be assigned to a category. |
Services | Service combinations | SERVICE_COMBINATIONS | The unique combination of services per visit. |
Services | Service ID | SERVICE_ID | The unique ID associated with a service. |
Services | Service name | SERVICE_NAME | The name of the service. |
Time period | Date | DATE | The date the event occurs |
Time period | Day of week | DAY_OF_WEEK | The day of the week an event occurs. Represented as the full month name. |
Time period | Day of week number | DAY_OF_WEEK_NUMBER | The day of the week an event occurs. Represented as a number where 1 is the start of the week and 7 is the last day of the week. Will adjust according to the week starting selection. |
Time period | Month | MONTH | We first day of the month an event occurs. |
Time period | Week starting | WEEK_STARTING | We first day of the week an event occurs. Will be adjusted based on the week starting selection. |
Time period | Year | YEAR | The year an event occurs. |
User | Created by ID | CREATED_BY | The unique user ID associated with the first user to create the visit. |
User | Created by username | CREATED_BY_NAME | The user name associated with the first user to create the visit. |
User | Updated by ID | UPDATED_BY | The unique user ID associated with the last user to update the visit. |
User | Updated By Role | UPDATED_BY_ROLE | The role associated to the user who last updated the visit. Multiple roles can be assigned to a single visit if the user (Updated By) has multiple roles. |
User | Updated by username | UPDATED_BY_NAME | The user name associated with the last user to update the visit. |
Visit | Creator | AGENT | The agent who generated the visit. Examples: STAFF, GUEST, API. |
Visit | Is a capacity visit | IS_CAPACITY | An indicator of the visits that are attributed to tracking location capacity. |
Visit | Is a deleted visit | IS_DELETED | An indicator of the visits that were deleted. TRUE = deleted visits. |
Visit | Party size | PARTY_SIZE | The size of the party associated with the visit. |
Visit | Visit created source | SOURCE | The source the visit was created from. Examples: WEB-APP, PUBLIC, IOS-APP, KIOSK, etc. |
Visit | Visit type | VISIT_TYPE | A classification of the type of visit. Examples include: waitlist, booking, waitlisted booking, booking from waitlist, direct to served, direct to completed |
Have additional questions or need assistance? Reach out to us via chat or at support@waitwhile.com.