Skip to content
AWS for Query.Farm

aws.evidently.get_experiment_results

Example SQL Queries

SELECT * FROM
aws.evidently.get_experiment_results
WHERE
"experiment" = 'VALUE'
AND "metric_names" = 'VALUE'
AND "project" = 'VALUE'
AND "treatment_names" = 'VALUE';

Description

Retrieves the results of a running or completed experiment. No results are available until there have been 100 events for each variation and at least 10 minutes have passed since the start of the experiment. To increase the statistical power, Evidently performs an additional offline p-value analysis at the end of the experiment. Offline p-value analysis can detect statistical significance in some cases where the anytime p-values used during the experiment do not find statistical significance.

Experiment results are available up to 63 days after the start of the experiment. They are not available after that because of CloudWatch data retention policies.

Table Definition

Column NameColumn Data Type
experiment Required Input Column

The name of the experiment to retrieve the results of.

VARCHAR
metric_names Required Input Column

The names of the experiment metrics that you want to see the results of.

VARCHAR[]
Show child fields
metric_names[]
project Required Input Column

The name or ARN of the project that contains the experiment that you want to see the results of.

VARCHAR
treatment_names Required Input Column

The names of the experiment treatments that you want to see the results for.

VARCHAR[]
Show child fields
treatment_names[]
base_stat Input Column

The statistic used to calculate experiment results. Currently the only valid value is mean, which uses the mean of the collected values as the statistic.

VARCHAR
end_time Input Column

The date and time that the experiment ended, if it is completed. This must be no longer than 30 days after the experiment start time.

TIMESTAMP_S
period Input Column

In seconds, the amount of time to aggregate results together. 

BIGINT
report_names Input Column

The names of the report types that you want to see. Currently, BayesianInference is the only valid value.

VARCHAR[]
Show child fields
report_names[]
result_stats Input Column

The statistics that you want to see in the returned results.

  • PValue specifies to use p-values for the results. A p-value is used in hypothesis testing to measure how often you are willing to make a mistake in rejecting the null hypothesis. A general practice is to reject the null hypothesis and declare that the results are statistically significant when the p-value is less than 0.05.

  • ConfidenceInterval specifies a confidence interval for the results. The confidence interval represents the range of values for the chosen metric that is likely to contain the true difference between the baseStat of a variation and the baseline. Evidently returns the 95% confidence interval.

  • TreatmentEffect is the difference in the statistic specified by the baseStat parameter between each variation and the default variation.

  • BaseStat returns the statistical values collected for the metric for each variation. The statistic uses the same statistic specified in the baseStat parameter. Therefore, if baseStat is mean, this returns the mean of the values collected for each variation.

VARCHAR[]
Show child fields
result_stats[]
start_time Input Column

The date and time that the experiment started.

TIMESTAMP_S
_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.

_aws_region Input Column

The AWS region to use.

VARCHAR
details

If the experiment doesn't yet have enough events to provide valid results, this field is returned with the message Not enough events to generate results. If there are enough events to provide valid results, this field is not returned.

VARCHAR
reports

An array of structures that include the reports that you requested.

STRUCT(
    "content" VARCHAR,
    "metric_name" VARCHAR,
    "report_name" VARCHAR,
    "treatment_name" VARCHAR
)[]
Show child fields
reports[]
Show child fields
reports[].content

The content of the report.

reports[].metric_name

The name of the metric that is analyzed in this experiment report.

reports[].report_name

The type of analysis used for this report.

reports[].treatment_name

The name of the variation that this report pertains to.

results_data

An array of structures that include experiment results including metric names and values. 

STRUCT(
    "metric_name" VARCHAR,
    "result_stat" VARCHAR,
    "treatment_name" VARCHAR,
    "values" DOUBLE[]
)[]
Show child fields
results_data[]
Show child fields
results_data[].metric_name

The name of the metric.

results_data[].result_stat

The experiment statistic that these results pertain to.

results_data[].treatment_name

The treatment, or variation, that returned the values in this structure.

results_data[].values[]
timestamps

The timestamps of each result returned.

TIMESTAMP_S[]
Show child fields
timestamps[]