The Ads Experiments Geolift table stores geo-based incrementality (GeoLift) experiments and their measured results. One row per experiment cell.

📋
Table Guide
What You Can Answer With This Table

What incrementality tests have I run and what did they find? — use experiment_name, experiment_status, start_date, end_date, result_revenue_lift, result_revenue_lift_pct, result_revenue_iroas, result_revenue_p_value

Which geolift experiments are currently running and when do they end? — use experiment_name, experiment_status, start_date, end_date

What is the incremental ROAS of the campaigns I tested? — use experiment_name, campaigns, result_revenue_iroas, result_revenue_effect, result_revenue_p_value

Before You Query

This table is not time-series. No event date filter is needed.

Grain: One row per experiment cell (cell_id); experiment_id identifies the experiment and experiment_set_id groups experiments designed together.

Inverse tests: Triple Whale runs inverse tests where ad spend is reduced in the treatment geos, but all result columns are already re-oriented so positive lift means the ads add value.

Sign convention: All lift / iROAS / iCPA / effect columns are already oriented as the incremental contribution of advertising: positive = ads add value. Do not flip signs. The Compass UI shows absolute values with a separate effect-direction label, so a signed value here may appear unsigned there.

Percent scales: spend_reduction_pct is percentage points 0-100 (21.7 = 21.7%), while result lift percentage columns are fractions (0.05 = 5%). Multiply lift-percent columns by 100 to present them as percentages. The MDE columns are efficiency thresholds (minimum detectable iROAS for revenue MDEs; spend-per-incremental-conversion for conversions MDEs), not lift fractions.

Holdout spend: spend_reduction / spend_reduction_pct describe only the holdout (treatment) geos: the absolute column is the holdout geos' spend over the test duration, and the pct column is the holdout geos' share of the tested campaigns' total spend.

Confidence values: Result p-value columns hold a confidence percentage clamped to 1-99 (higher = more confident), not a raw p-value.

Incomplete results: Result columns are NULL (effect empty) until experiment_status is completed; filter to completed experiments when reporting results.

Nested fields: campaigns and accounts are nested (repeated) fields; use ARRAY JOIN to expand them into rows.

Platform breakdown: Per-sales-platform results other than Shopify (Amazon, TikTok Shop, Walmart, and similar) live only in the extra_platform_results JSON column. Shopify has dedicated columns such as result_shopify_revenue_lift and result_shopify_conversions_lift. Platform-level lifts are floored at 0 and normalized so result_shopify_revenue_lift plus the revenue entries in extra_platform_results sums exactly to result_revenue_lift (same for conversions).

Scope: Recommended-but-not-launched test setups are excluded; only real experiments (draft through completed) appear.

When to Use a Different Table

Use MMM Attributions table when you need always-on modeled channel contribution rather than a one-off measured test. Geolift rows are point-in-time experiments; ongoing model-based channel contribution lives in MMM Attributions.

View the full Triple Whale Data Ontology →

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Ad Accounts	`accounts`	record repeated	The ad accounts participating in the experiment. An array of objects with keys `channel` and `ad_account_id`.
Channel	`accounts.channel`	string	The ad channel of the account. Example values: `facebook-ads`, `google-ads`, `tiktok-ads`
Ad Account ID	`accounts.ad_account_id`	string	The identifier of the ad account on its channel.
Campaign Subcategory ID	`campaign_subcategory_id`	string	The Compass subcategory the tested campaigns belong to. `NULL` when the experiment is not tied to a subcategory. Example value: `9b47d2c1-6e0f-4a83-b5d9-2c71e8f4a605`
Campaigns	`campaigns`	record repeated	The campaigns whose spend is reduced in the treatment geos during the test. An array of objects with keys `campaign_id`, `campaign_name`, and `channel`.
Campaign ID	`campaigns.campaign_id`	string	The identifier of the campaign on its channel.
Campaign Name	`campaigns.campaign_name`	string	The display name of the campaign.
Channel	`campaigns.channel`	string	The ad channel of the campaign. Example values: `facebook-ads`, `google-ads`, `tiktok-ads`
Cell ID	`cell_id`	string	The identifier of the experiment cell (the treatment group of geos). Each row is one cell; most experiments have a single cell. Example value: `3b8e2f6a-91c4-4d7e-a5b0-6c2d8f4e1a92`
Cooldown End Date	`cooldown_period_end_date`	timestamp	The end of the post-treatment cooldown period. Formatted according to the ISO 8601 international standard. `NULL` when the experiment has no cooldown. Example value: `2026-02-09 20:00:00`
Cooldown Start Date	`cooldown_period_start_date`	timestamp	The start of the post-treatment cooldown period, during which delayed effects are still measured. Formatted according to the ISO 8601 international standard. `NULL` when the experiment has no cooldown. Example value: `2026-02-02 20:00:00`
Created At	`created_at`	timestamp	The time at which the experiment was created. Formatted according to the ISO 8601 international standard. Example value: `2026-01-12 08:30:00`
Currency	`currency`	string	The currency of the monetary columns (spend reduction, revenue lifts). Example values: `USD`, `EUR`
End Date	`end_date`	timestamp	The date the spend reduction (treatment) ends. Formatted according to the ISO 8601 international standard. Example value: `2026-02-02 20:00:00`
Experiment Description	`experiment_description`	string	The free-text description of what the experiment tests.
Experiment ID	`experiment_id`	string	The unique identifier of the geolift experiment. Example value: `7e3a9b21-c4d5f6a8`
Experiment Name	`experiment_name`	string	The human-readable name of the experiment. Example values: `Meta Prospecting Geolift Test`, `Brand Search Incrementality Test Feb 2026`, `TikTok \|\| Retargeting Test \|\| July 2026`
Experiment Set ID	`experiment_set_id`	string	The identifier of the experiment set the experiment belongs to. Sets group related experiments that were designed together. Example value: `a1f2c3d4`
Experiment Status	`experiment_status`	string	The lifecycle status of the experiment. Results (`result_*` columns) are populated once the experiment completes. Possible values: `draft`, `scheduled`, `running`, `cooldown`, `completed`, `cancelled`
Experiment Type	`experiment_type`	string	The type of the experiment. Example value: `geolift`
Extra Platform Results	`extra_platform_results`	string	A JSON-encoded string holding an array of per-sales-platform results for every platform other than Shopify (e.g. Amazon, TikTok Shop, Walmart); this is the only place per-platform results other than Shopify live. Each element has keys `platform`, `kpi` (`revenue` or `acquisitions`), `incremental_lift`, `lift_pct`, and optionally `iroas` or `icpa`. Platform values are floored at `0` (a platform with no positive contribution is reported as `0`) and normalized together with the `result_shopify_*` columns so that the Shopify lift plus these entries' lifts sum exactly to the experiment-level `result_revenue_lift` / `result_conversions_lift`. Per-platform effect, confidence and intervals are not provided; use the top-level result columns for experiment-level statistics. The string is `[]` (never `NULL`) when there are no extra platforms. Example value: `[]`
Full End Date	`full_end_date`	timestamp	The date the experiment fully ends, including the cooldown period when there is one. Formatted according to the ISO 8601 international standard. Example value: `2026-02-09 20:00:00`
Objective ID	`objective_id`	string	The identifier of the experiment objective the cell was designed to measure. Example value: `5d21c7e9-40b3-4f8a-9c66-1e7a2b9d0f34`
Pre-Experiment Confidence	`pre_experiment_confidence`	string	The design-time assessment of how reliable the experiment is expected to be, based on the geo split and historical data quality. Possible values: `low`, `medium`, `high`
Primary Metric	`primary_metric`	string	The main business outcome the experiment was designed to measure. Example values: `Revenue`, `New Customer Revenue`, `acquisitions`
Recommendation ID	`recommendation_id`	string	The identifier of the recommended test setup this experiment was created from. Empty when the experiment was created manually. Example value: `4f6a2b1c-8_93e0ab`
Conversions Effect Direction	`result_conversions_effect`	string	The measured direction of the ads' effect on conversions: `positive` means the ads add value, `negative` means they detract, `no_effect` means no statistically meaningful effect was found. Empty until the experiment completes. Possible values: `positive`, `negative`, `no_effect`
New Customer Conversions Effect Direction	`result_new_customer_conversions_effect`	string	The measured direction of the ads' effect on new customer conversions: `positive` means the ads add value, `negative` means they detract, `no_effect` means no statistically meaningful effect was found. Empty until the experiment completes. Possible values: `positive`, `negative`, `no_effect`
New Customer Revenue Effect Direction	`result_new_customer_revenue_effect`	string	The measured direction of the ads' effect on new customer revenue: `positive` means the ads add value, `negative` means they detract, `no_effect` means no statistically meaningful effect was found. Empty until the experiment completes. Possible values: `positive`, `negative`, `no_effect`
Returning Customer Conversions Effect Direction	`result_returning_customer_conversions_effect`	string	The measured direction of the ads' effect on returning customer conversions: `positive` means the ads add value, `negative` means they detract, `no_effect` means no statistically meaningful effect was found. Empty until the experiment completes. Possible values: `positive`, `negative`, `no_effect`
Returning Customer Revenue Effect Direction	`result_returning_customer_revenue_effect`	string	The measured direction of the ads' effect on returning customer revenue: `positive` means the ads add value, `negative` means they detract, `no_effect` means no statistically meaningful effect was found. Empty until the experiment completes. Possible values: `positive`, `negative`, `no_effect`
Revenue Effect Direction	`result_revenue_effect`	string	The measured direction of the ads' effect on revenue: `positive` means the ads add value, `negative` means they detract, `no_effect` means no statistically meaningful effect was found. Empty until the experiment completes. Possible values: `positive`, `negative`, `no_effect`
Shopify Conversions Effect Direction	`result_shopify_conversions_effect`	string	The measured direction of the ads' effect on shopify conversions: `positive` means the ads add value, `negative` means they detract, `no_effect` means no statistically meaningful effect was found. Empty until the experiment completes. Possible values: `positive`, `negative`, `no_effect`
Shopify Revenue Effect Direction	`result_shopify_revenue_effect`	string	The measured direction of the ads' effect on shopify revenue: `positive` means the ads add value, `negative` means they detract, `no_effect` means no statistically meaningful effect was found. Empty until the experiment completes. Possible values: `positive`, `negative`, `no_effect`
Start Date	`start_date`	timestamp	The date the spend reduction (treatment) starts. Formatted according to the ISO 8601 international standard. Example value: `2026-01-12 20:00:00`
Updated At	`updated_at`	timestamp	The time at which the experiment row was last updated. Formatted according to the ISO 8601 international standard. Example value: `2026-01-12 08:30:00`

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Conversions MDE	`conversions_mde`	numeric	The minimum detectable cost per incremental conversion for Conversions: holdout spend divided by the minimum number of incremental conversions this experiment's design can reliably detect (an iCPA-style threshold). Set at design time. A completed test whose true effect is below this threshold will typically report `no_effect`.
Estimated KPI Impact %	`estimated_kpi_impact_pct`	numeric	The design-time estimate of the experiment's impact on the primary metric. Rarely populated; `0` for most experiments, so do not rely on it.
New Customer Conversions MDE	`new_customer_conversions_mde`	numeric	The minimum detectable cost per incremental conversion for New Customer Conversions: holdout spend divided by the minimum number of incremental conversions this experiment's design can reliably detect (an iCPA-style threshold). Set at design time. A completed test whose true effect is below this threshold will typically report `no_effect`.
New Customer Revenue MDE	`new_customer_revenue_mde`	numeric	The minimum detectable iROAS for New Customer Revenue: the smallest incremental return on ad spend this experiment's design can reliably detect (minimum required incremental new customer revenue implied by the power analysis, divided by holdout spend), floored at `0.15`. Set at design time. A completed test whose true effect is below this threshold will typically report `no_effect`.
Conversions First Click CPA	`result_conversions_first_click_cpa`	numeric	The conversions CPA that the First Click attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
Conversions Incremental CPA	`result_conversions_icpa`	numeric	The incremental cost per acquisition for conversions: spend on the tested ads per incremental conversion. Compare with the attribution-based CPA columns to see how attribution over- or under-states incremental value. `NULL` until the experiment completes.
Conversions Last Click CPA	`result_conversions_last_click_cpa`	numeric	The conversions CPA that the Last Click attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
Incremental Conversions Lift	`result_conversions_lift`	numeric	The absolute incremental conversions attributed to the tested ads over the experiment window. Positive means the ads add value. `NULL` until the experiment completes.
Incremental Conversions Lift Lower Bound	`result_conversions_lift_lower_bound`	numeric	The lower bound of the confidence interval around the incremental conversions lift. `NULL` when no interval is available.
Incremental Conversions Lift %	`result_conversions_lift_pct`	numeric	The incremental conversions lift as a fraction of the baseline (e.g. `0.05` = 5% lift). Positive means the ads add value. `NULL` until the experiment completes.
Incremental Conversions Lift Upper Bound	`result_conversions_lift_upper_bound`	numeric	The upper bound of the confidence interval around the incremental conversions lift. `NULL` when no interval is available.
Conversions Linear All CPA	`result_conversions_linear_all_cpa`	numeric	The conversions CPA that the Linear All attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
Conversions Linear Paid CPA	`result_conversions_linear_paid_cpa`	numeric	The conversions CPA that the Linear Paid attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
Conversions Confidence	`result_conversions_p_value`	numeric	The statistical confidence in the measured conversions effect, expressed as a percentage clamped to `1`–`99` (higher = more confident; this is NOT a raw p-value). `NULL` until the experiment completes.
Conversions Triple Attribution CPA	`result_conversions_triple_attribution_cpa`	numeric	The conversions CPA that the Triple Attribution attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
Conversions Triple Attribution + Views CPA	`result_conversions_triple_attribution_plus_views_cpa`	numeric	The conversions CPA that the Triple Attribution + Views attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
New Customer Conversions First Click CPA	`result_new_customer_conversions_first_click_cpa`	numeric	The new customer conversions CPA that the First Click attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
New Customer Conversions Incremental CPA	`result_new_customer_conversions_icpa`	numeric	The incremental cost per acquisition for new customer conversions: spend on the tested ads per incremental conversion. Compare with the attribution-based CPA columns to see how attribution over- or under-states incremental value. `NULL` until the experiment completes.
New Customer Conversions Last Click CPA	`result_new_customer_conversions_last_click_cpa`	numeric	The new customer conversions CPA that the Last Click attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
Incremental New Customer Conversions Lift	`result_new_customer_conversions_lift`	numeric	The absolute incremental new customer conversions attributed to the tested ads over the experiment window. Positive means the ads add value. `NULL` until the experiment completes.
Incremental New Customer Conversions Lift Lower Bound	`result_new_customer_conversions_lift_lower_bound`	numeric	The lower bound of the confidence interval around the incremental new customer conversions lift. `NULL` when no interval is available.
Incremental New Customer Conversions Lift %	`result_new_customer_conversions_lift_pct`	numeric	The incremental new customer conversions lift as a fraction of the baseline (e.g. `0.05` = 5% lift). Positive means the ads add value. `NULL` until the experiment completes.
Incremental New Customer Conversions Lift Upper Bound	`result_new_customer_conversions_lift_upper_bound`	numeric	The upper bound of the confidence interval around the incremental new customer conversions lift. `NULL` when no interval is available.
New Customer Conversions Linear All CPA	`result_new_customer_conversions_linear_all_cpa`	numeric	The new customer conversions CPA that the Linear All attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
New Customer Conversions Linear Paid CPA	`result_new_customer_conversions_linear_paid_cpa`	numeric	The new customer conversions CPA that the Linear Paid attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
New Customer Conversions Confidence	`result_new_customer_conversions_p_value`	numeric	The statistical confidence in the measured new customer conversions effect, expressed as a percentage clamped to `1`–`99` (higher = more confident; this is NOT a raw p-value). `NULL` until the experiment completes.
New Customer Conversions Triple Attribution CPA	`result_new_customer_conversions_triple_attribution_cpa`	numeric	The new customer conversions CPA that the Triple Attribution attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
New Customer Conversions Triple Attribution + Views CPA	`result_new_customer_conversions_triple_attribution_plus_views_cpa`	numeric	The new customer conversions CPA that the Triple Attribution + Views attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
New Customer Revenue First Click ROAS	`result_new_customer_revenue_first_click_roas`	numeric	The new customer revenue ROAS that the First Click attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
New Customer Revenue Incremental ROAS	`result_new_customer_revenue_iroas`	numeric	The incremental return on ad spend for new customer revenue: incremental new customer revenue attributed to the tested ads per dollar of spend. Compare with the attribution-based ROAS columns to see how attribution over- or under-states incremental value. `NULL` until the experiment completes.
New Customer Revenue Last Click ROAS	`result_new_customer_revenue_last_click_roas`	numeric	The new customer revenue ROAS that the Last Click attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Incremental New Customer Revenue Lift	`result_new_customer_revenue_lift`	numeric	The absolute incremental new customer revenue attributed to the tested ads over the experiment window. Positive means the ads add value. `NULL` until the experiment completes.
Incremental New Customer Revenue Lift Lower Bound	`result_new_customer_revenue_lift_lower_bound`	numeric	The lower bound of the confidence interval around the incremental new customer revenue lift. `NULL` when no interval is available.
Incremental New Customer Revenue Lift %	`result_new_customer_revenue_lift_pct`	numeric	The incremental new customer revenue lift as a fraction of the baseline (e.g. `0.05` = 5% lift). Positive means the ads add value. `NULL` until the experiment completes.
Incremental New Customer Revenue Lift Upper Bound	`result_new_customer_revenue_lift_upper_bound`	numeric	The upper bound of the confidence interval around the incremental new customer revenue lift. `NULL` when no interval is available.
New Customer Revenue Linear All ROAS	`result_new_customer_revenue_linear_all_roas`	numeric	The new customer revenue ROAS that the Linear All attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
New Customer Revenue Linear Paid ROAS	`result_new_customer_revenue_linear_paid_roas`	numeric	The new customer revenue ROAS that the Linear Paid attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
New Customer Revenue Confidence	`result_new_customer_revenue_p_value`	numeric	The statistical confidence in the measured new customer revenue effect, expressed as a percentage clamped to `1`–`99` (higher = more confident; this is NOT a raw p-value). `NULL` until the experiment completes.
New Customer Revenue Triple Attribution + Views ROAS	`result_new_customer_revenue_triple_attribution_plus_views_roas`	numeric	The new customer revenue ROAS that the Triple Attribution + Views attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
New Customer Revenue Triple Attribution ROAS	`result_new_customer_revenue_triple_attribution_roas`	numeric	The new customer revenue ROAS that the Triple Attribution attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Returning Customer Conversions First Click CPA	`result_returning_customer_conversions_first_click_cpa`	numeric	The returning customer conversions CPA that the First Click attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
Returning Customer Conversions Incremental CPA	`result_returning_customer_conversions_icpa`	numeric	The incremental cost per acquisition for returning customer conversions: spend on the tested ads per incremental conversion. Compare with the attribution-based CPA columns to see how attribution over- or under-states incremental value. `NULL` until the experiment completes.
Returning Customer Conversions Last Click CPA	`result_returning_customer_conversions_last_click_cpa`	numeric	The returning customer conversions CPA that the Last Click attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
Incremental Returning Customer Conversions Lift	`result_returning_customer_conversions_lift`	numeric	The absolute incremental returning customer conversions attributed to the tested ads over the experiment window. Positive means the ads add value. `NULL` until the experiment completes.
Incremental Returning Customer Conversions Lift Lower Bound	`result_returning_customer_conversions_lift_lower_bound`	numeric	The lower bound of the confidence interval around the incremental returning customer conversions lift. `NULL` when no interval is available.
Incremental Returning Customer Conversions Lift %	`result_returning_customer_conversions_lift_pct`	numeric	The incremental returning customer conversions lift as a fraction of the baseline (e.g. `0.05` = 5% lift). Positive means the ads add value. `NULL` until the experiment completes.
Incremental Returning Customer Conversions Lift Upper Bound	`result_returning_customer_conversions_lift_upper_bound`	numeric	The upper bound of the confidence interval around the incremental returning customer conversions lift. `NULL` when no interval is available.
Returning Customer Conversions Linear All CPA	`result_returning_customer_conversions_linear_all_cpa`	numeric	The returning customer conversions CPA that the Linear All attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
Returning Customer Conversions Linear Paid CPA	`result_returning_customer_conversions_linear_paid_cpa`	numeric	The returning customer conversions CPA that the Linear Paid attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
Returning Customer Conversions Confidence	`result_returning_customer_conversions_p_value`	numeric	The statistical confidence in the measured returning customer conversions effect, expressed as a percentage clamped to `1`–`99` (higher = more confident; this is NOT a raw p-value). `NULL` until the experiment completes.
Returning Customer Conversions Triple Attribution CPA	`result_returning_customer_conversions_triple_attribution_cpa`	numeric	The returning customer conversions CPA that the Triple Attribution attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
Returning Customer Conversions Triple Attribution + Views CPA	`result_returning_customer_conversions_triple_attribution_plus_views_cpa`	numeric	The returning customer conversions CPA that the Triple Attribution + Views attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iCPA can be compared against what attribution reports. `NULL` until the experiment completes.
Returning Customer Revenue First Click ROAS	`result_returning_customer_revenue_first_click_roas`	numeric	The returning customer revenue ROAS that the First Click attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Returning Customer Revenue Incremental ROAS	`result_returning_customer_revenue_iroas`	numeric	The incremental return on ad spend for returning customer revenue: incremental returning customer revenue attributed to the tested ads per dollar of spend. Compare with the attribution-based ROAS columns to see how attribution over- or under-states incremental value. `NULL` until the experiment completes.
Returning Customer Revenue Last Click ROAS	`result_returning_customer_revenue_last_click_roas`	numeric	The returning customer revenue ROAS that the Last Click attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Incremental Returning Customer Revenue Lift	`result_returning_customer_revenue_lift`	numeric	The absolute incremental returning customer revenue attributed to the tested ads over the experiment window. Positive means the ads add value. `NULL` until the experiment completes.
Incremental Returning Customer Revenue Lift Lower Bound	`result_returning_customer_revenue_lift_lower_bound`	numeric	The lower bound of the confidence interval around the incremental returning customer revenue lift. `NULL` when no interval is available.
Incremental Returning Customer Revenue Lift %	`result_returning_customer_revenue_lift_pct`	numeric	The incremental returning customer revenue lift as a fraction of the baseline (e.g. `0.05` = 5% lift). Positive means the ads add value. `NULL` until the experiment completes.
Incremental Returning Customer Revenue Lift Upper Bound	`result_returning_customer_revenue_lift_upper_bound`	numeric	The upper bound of the confidence interval around the incremental returning customer revenue lift. `NULL` when no interval is available.
Returning Customer Revenue Linear All ROAS	`result_returning_customer_revenue_linear_all_roas`	numeric	The returning customer revenue ROAS that the Linear All attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Returning Customer Revenue Linear Paid ROAS	`result_returning_customer_revenue_linear_paid_roas`	numeric	The returning customer revenue ROAS that the Linear Paid attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Returning Customer Revenue Confidence	`result_returning_customer_revenue_p_value`	numeric	The statistical confidence in the measured returning customer revenue effect, expressed as a percentage clamped to `1`–`99` (higher = more confident; this is NOT a raw p-value). `NULL` until the experiment completes.
Returning Customer Revenue Triple Attribution + Views ROAS	`result_returning_customer_revenue_triple_attribution_plus_views_roas`	numeric	The returning customer revenue ROAS that the Triple Attribution + Views attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Returning Customer Revenue Triple Attribution ROAS	`result_returning_customer_revenue_triple_attribution_roas`	numeric	The returning customer revenue ROAS that the Triple Attribution attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Revenue First Click ROAS	`result_revenue_first_click_roas`	numeric	The revenue ROAS that the First Click attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Revenue Incremental ROAS	`result_revenue_iroas`	numeric	The incremental return on ad spend for revenue: incremental revenue attributed to the tested ads per dollar of spend. Compare with the attribution-based ROAS columns to see how attribution over- or under-states incremental value. `NULL` until the experiment completes.
Revenue Last Click ROAS	`result_revenue_last_click_roas`	numeric	The revenue ROAS that the Last Click attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Incremental Revenue Lift	`result_revenue_lift`	numeric	The absolute incremental revenue attributed to the tested ads over the experiment window. Positive means the ads add value. `NULL` until the experiment completes.
Incremental Revenue Lift Lower Bound	`result_revenue_lift_lower_bound`	numeric	The lower bound of the confidence interval around the incremental revenue lift. `NULL` when no interval is available.
Incremental Revenue Lift %	`result_revenue_lift_pct`	numeric	The incremental revenue lift as a fraction of the baseline (e.g. `0.05` = 5% lift). Positive means the ads add value. `NULL` until the experiment completes.
Incremental Revenue Lift Upper Bound	`result_revenue_lift_upper_bound`	numeric	The upper bound of the confidence interval around the incremental revenue lift. `NULL` when no interval is available.
Revenue Linear All ROAS	`result_revenue_linear_all_roas`	numeric	The revenue ROAS that the Linear All attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Revenue Linear Paid ROAS	`result_revenue_linear_paid_roas`	numeric	The revenue ROAS that the Linear Paid attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Revenue Confidence	`result_revenue_p_value`	numeric	The statistical confidence in the measured revenue effect, expressed as a percentage clamped to `1`–`99` (higher = more confident; this is NOT a raw p-value). `NULL` until the experiment completes.
Revenue Triple Attribution + Views ROAS	`result_revenue_triple_attribution_plus_views_roas`	numeric	The revenue ROAS that the Triple Attribution + Views attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Revenue Triple Attribution ROAS	`result_revenue_triple_attribution_roas`	numeric	The revenue ROAS that the Triple Attribution attribution model reported for the tested campaigns over the experiment window. This is a plain attribution ratio (always positive), included so the experiment's incremental iROAS can be compared against what attribution reports. `NULL` until the experiment completes.
Shopify Conversions Incremental CPA	`result_shopify_conversions_icpa`	numeric	The incremental cost per acquisition for shopify conversions: spend on the tested ads per incremental conversion. Compare with the attribution-based CPA columns to see how attribution over- or under-states incremental value. `NULL` until the experiment completes.
Incremental Shopify Conversions Lift	`result_shopify_conversions_lift`	numeric	The absolute incremental shopify conversions attributed to the tested ads over the experiment window. Positive means the ads add value. `NULL` until the experiment completes.
Incremental Shopify Conversions Lift Lower Bound	`result_shopify_conversions_lift_lower_bound`	numeric	The lower bound of the confidence interval around the incremental shopify conversions lift. `NULL` when no interval is available.
Incremental Shopify Conversions Lift %	`result_shopify_conversions_lift_pct`	numeric	The incremental shopify conversions lift as a fraction of the baseline (e.g. `0.05` = 5% lift). Positive means the ads add value. `NULL` until the experiment completes.
Incremental Shopify Conversions Lift Upper Bound	`result_shopify_conversions_lift_upper_bound`	numeric	The upper bound of the confidence interval around the incremental shopify conversions lift. `NULL` when no interval is available.
Shopify Conversions Confidence	`result_shopify_conversions_p_value`	numeric	The statistical confidence in the measured shopify conversions effect, expressed as a percentage clamped to `1`–`99` (higher = more confident; this is NOT a raw p-value). `NULL` until the experiment completes.
Shopify Revenue Incremental ROAS	`result_shopify_revenue_iroas`	numeric	The incremental return on ad spend for shopify revenue: incremental shopify revenue attributed to the tested ads per dollar of spend. Compare with the attribution-based ROAS columns to see how attribution over- or under-states incremental value. `NULL` until the experiment completes.
Incremental Shopify Revenue Lift	`result_shopify_revenue_lift`	numeric	The absolute incremental shopify revenue attributed to the tested ads over the experiment window. Positive means the ads add value. `NULL` until the experiment completes.
Incremental Shopify Revenue Lift Lower Bound	`result_shopify_revenue_lift_lower_bound`	numeric	The lower bound of the confidence interval around the incremental shopify revenue lift. `NULL` when no interval is available.
Incremental Shopify Revenue Lift %	`result_shopify_revenue_lift_pct`	numeric	The incremental shopify revenue lift as a fraction of the baseline (e.g. `0.05` = 5% lift). Positive means the ads add value. `NULL` until the experiment completes.
Incremental Shopify Revenue Lift Upper Bound	`result_shopify_revenue_lift_upper_bound`	numeric	The upper bound of the confidence interval around the incremental shopify revenue lift. `NULL` when no interval is available.
Shopify Revenue Confidence	`result_shopify_revenue_p_value`	numeric	The statistical confidence in the measured shopify revenue effect, expressed as a percentage clamped to `1`–`99` (higher = more confident; this is NOT a raw p-value). `NULL` until the experiment completes.
Returning Customer Conversions MDE	`returning_customer_conversions_mde`	numeric	The minimum detectable cost per incremental conversion for Returning Customer Conversions: holdout spend divided by the minimum number of incremental conversions this experiment's design can reliably detect (an iCPA-style threshold). Set at design time. A completed test whose true effect is below this threshold will typically report `no_effect`.
Returning Customer Revenue MDE	`returning_customer_revenue_mde`	numeric	The minimum detectable iROAS for Returning Customer Revenue: the smallest incremental return on ad spend this experiment's design can reliably detect (minimum required incremental returning customer revenue implied by the power analysis, divided by holdout spend), floored at `0.15`. Set at design time. A completed test whose true effect is below this threshold will typically report `no_effect`.
Revenue MDE	`revenue_mde`	numeric	The minimum detectable iROAS for Revenue: the smallest incremental return on ad spend this experiment's design can reliably detect (minimum required incremental revenue implied by the power analysis, divided by holdout spend), floored at `0.15`. Set at design time. A completed test whose true effect is below this threshold will typically report `no_effect`.
Spend Reduction	`spend_reduction`	numeric	The tested campaigns' spend in the holdout (treatment) geos over the test duration, which is the spend that is removed during the experiment, in the shop's currency. Computed as the holdout geos' daily spend times the test duration; NOT the campaigns' total spend.
Spend Reduction %	`spend_reduction_pct`	numeric	The holdout (treatment) geos' share of the tested campaigns' total spend, in percentage points `0`–`100` (e.g. `21.7` = 21.7%). Note this scale differs from the `result_*_lift_pct` columns, which are fractions.