Skip to content
AWS for Query.Farm

aws.lexv2_models.list_session_metrics

Example SQL Queries

SELECT * FROM
aws.lexv2_models.list_session_metrics
WHERE
"bot_id" = 'VALUE'
AND "start_date_time" = 'VALUE'
AND "end_date_time" = 'VALUE'
AND "metrics" = 'VALUE';

Description

Retrieves summary metrics for the user sessions with your bot. The following fields are required:

  • metrics – A list of AnalyticsSessionMetric objects. In each object, use the name field to specify the metric to calculate, the statistic field to specify whether to calculate the Sum, Average, or Max number, and the order field to specify whether to sort the results in Ascending or Descending order.

  • startDateTime and endDateTime – Define a time range for which you want to retrieve results.

Of the optional fields, you can organize the results in the following ways:

  • Use the filters field to filter the results, the groupBy field to specify categories by which to group the results, and the binBy field to specify time intervals by which to group the results.

  • Use the maxResults field to limit the number of results to return in a single response and the nextToken field to return the next batch of results if the response does not return the full set of results.

Note that an order field exists in both binBy and metrics. Currently, you can specify it in either field, but not in both.

Table Definition

Column NameColumn Data Type
bot_id Required Input Column

The identifier for the bot for which you retrieved session metrics.

VARCHAR
end_date_time Required Input Column

The date and time that marks the end of the range of time for which you want to see session metrics.

TIMESTAMP_S
metrics Required Input Column

A list of objects, each of which contains a metric you want to list, the statistic for the metric you want to return, and the method by which to organize the results.

STRUCT(
    "name" VARCHAR,
    "statistic" VARCHAR,
    "order" VARCHAR
)[]
Show child fields
metrics[]
Show child fields
metrics[].name

The metric for which you want to get session summary statistics.

  • Count – The number of sessions.

  • Success – The number of sessions that succeeded.

  • Failure – The number of sessions that failed.

  • Dropped – The number of sessions that the user dropped.

  • Duration – The duration of sessions.

  • TurnsPerSession – The number of turns in the sessions.

  • Concurrency – The number of sessions occurring in the same period of time.

metrics[].order

Specifies whether to sort the results in ascending or descending order.

metrics[].statistic

The summary statistic to calculate.

  • Sum – The total count for the category you provide in name.

  • Average – The total count divided by the number of sessions in the category you provide in name.

  • Max – The highest count in the category you provide in name.

start_date_time Required Input Column

The date and time that marks the beginning of the range of time for which you want to see session metrics.

TIMESTAMP_S
bin_by Input Column

A list of objects, each of which contains specifications for organizing the results by time.

STRUCT(
    "name" VARCHAR,
    "interval" VARCHAR,
    "order" VARCHAR
)[]
Show child fields
bin_by[]
Show child fields
bin_by[].interval

Specifies the interval of time by which to bin the analytics data.

bin_by[].name

Specifies the time metric by which to bin the analytics data.

bin_by[].order

Specifies whether to bin the analytics data in ascending or descending order. If this field is left blank, the default order is by the key of the bin in descending order.

filters Input Column

A list of objects, each of which describes a condition by which you want to filter the results.

STRUCT(
    "name" VARCHAR,
    "operator" VARCHAR,
    "values" VARCHAR[]
)[]
Show child fields
filters[]
Show child fields
filters[].name

The category by which to filter the sessions. The descriptions for each option are as follows:

  • BotAlias – The name of the bot alias.

  • BotVersion – The version of the bot.

  • LocaleId – The locale of the bot.

  • Modality – The modality of the session with the bot (audio, DTMF, or text).

  • Channel – The channel that the bot is integrated with.

  • Duration – The duration of the session.

  • conversationEndState – The final state of the session.

  • SessionId – The identifier of the session with the bot.

  • OriginatingRequestId – The identifier of the first request in a session.

  • IntentPath – The order of intents taken in a session.

filters[].operator

The operation by which to filter the category. The following operations are possible:

  • CO – Contains

  • EQ – Equals

  • GT – Greater than

  • LT – Less than

The operators that each filter supports are listed below:

  • BotAlias – EQ.

  • BotVersion – EQ.

  • LocaleId – EQ.

  • Modality – EQ.

  • Channel – EQ.

  • Duration – EQ, GT, LT.

  • conversationEndState – EQ, CO.

  • SessionId – EQ.

  • OriginatingRequestId – EQ.

  • IntentPath – EQ.

filters[].values[]
group_by Input Column

A list of objects, each of which specifies how to group the results. You can group by the following criteria:

  • ConversationEndState – The final state of the conversation. The possible end states are detailed in Key definitions in the user guide.

  • LocaleId – The unique identifier of the bot locale.

STRUCT(
    "name" VARCHAR
)[]
Show child fields
group_by[]
Show child fields
group_by[].name

Specifies whether to group the session by their end state or their locale.

max_results Input Column

The maximum number of results to return in each page of results. If there are fewer results than the maximum page size, only the actual number of results are returned.

BIGINT
next_token Input Column

If the response from the ListSessionMetrics operation contains more results than specified in the maxResults parameter, a token is returned in the response.

Use the returned token in the nextToken parameter of a ListSessionMetrics request to return the next page of results. For a complete set of results, call the ListSessionMetrics operation until the nextToken returned in the response is null.

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

results

The results for the session metrics.

STRUCT(
    "bin_keys" STRUCT(
        "name" VARCHAR,
        "value" BIGINT
    )[],
    "group_by_keys" STRUCT(
        "name" VARCHAR,
        "value" VARCHAR
    )[],
    "metrics_results" STRUCT(
        "name" VARCHAR,
        "statistic" VARCHAR,
        "value" DOUBLE
    )[]
)[]
Show child fields
results[]
Show child fields
results[].bin_keys[]
Show child fields
results[].bin_keys[].name

The criterion by which to bin the results.

results[].bin_keys[].value

The value of the criterion that defines the bin.

results[].group_by_keys[]
Show child fields
results[].group_by_keys[].name

The category by which the session analytics were grouped.

results[].group_by_keys[].value

A member of the category by which the session analytics were grouped.

results[].metrics_results[]
Show child fields
results[].metrics_results[].name

The metric that you requested.

  • Count – The number of sessions.

  • Success – The number of sessions that succeeded.

  • Failure – The number of sessions that failed.

  • Dropped – The number of sessions that the user dropped.

  • Duration – The duration of sessions.

  • TurnPersession – The number of turns in the sessions.

  • Concurrency – The number of sessions occurring in the same period of time.

results[].metrics_results[].statistic

The summary statistic that you requested to calculate.

  • Sum – The total count for the category you provide in name.

  • Average – The total count divided by the number of sessions in the category you provide in name.

  • Max – The highest count in the category you provide in name.

results[].metrics_results[].value

The value of the summary statistic for the metric that you requested.