> For the complete documentation index, see [llms.txt](https://help.citrusad.com/retail-media-interface/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.citrusad.com/retail-media-interface/integration/reporting/reporting-schema-definitions.md).

# Schema Definitions

## Dataset Naming Conventions

Access to tables and views is provided via a single, centralised project (insight-platform-external-iam), with each client having their own distinct client name embedded within their dataset names.

For example, for a client named “Company A”, the client name assigned might be “companya”. This would then be used to prefix dataset names. For example, sharing the Reporting Dataset would be via a dataset called: -

`insight-platform-external-iam.companya_insight_reporting`

Epsilon Retail Media will advise a client upon provisioning an endpoint what the names of their datasets will be.

***

## Core Dataset

Location: `insight-platform-external-iam.<client name>_<platform instance name>_analytics`

(eg `companya_retailerb_analytics`)

### Dimensions

| Name                                                                                                                   | Access                       | Purpose                                                                                                            |
| ---------------------------------------------------------------------------------------------------------------------- | ---------------------------- | ------------------------------------------------------------------------------------------------------------------ |
| [`currency_aud`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticscurrency_aud)           | <p>namespace<br>retailer</p> | Current conversion rates between the base currency (AUD) to other common currencies. ISO 4217 currency codes used. |
| [`currency_usd`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticscurrency_usd)           | <p>namespace<br>retailer</p> | Current conversion rates between the base currency (USD) to other common currencies. ISO 4217 currency codes used. |
| [`dim_campaign`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_campaign)           | <p>namespace<br>retailer</p> | Campaign master data dimension.                                                                                    |
| [`dim_campaign_attr`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_campaign_attr) | <p>namespace<br>retailer</p> | Campaign custom attributes (certain retailers only).                                                               |
| [`dim_catalog`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_catalog)             | <p>namespace<br>retailer</p> | Catalog master data dimension.                                                                                     |
| [`dim_category`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_category)           | <p>namespace<br>retailer</p> | Category dimension.                                                                                                |
| [`dim_env_namespace`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_env_namespace) | <p>namespace<br>retailer</p> | Namespace dimension.                                                                                               |
| [`dim_placement`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_placement)         | <p>namespace<br>retailer</p> | Placement dimension.                                                                                               |
| [`dim_product`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_product)             | <p>namespace<br>retailer</p> | Product dimension.                                                                                                 |
| [`dim_retailer`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_retailer)           | <p>namespace<br>retailer</p> | Retailer dimension.                                                                                                |
| [`dim_search_term`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_search_term)     | <p>namespace<br>retailer</p> | Search Term dimension.                                                                                             |
| [`dim_supplier`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_supplier)           | <p>namespace<br>retailer</p> | Supplier dimension.                                                                                                |
| [`dim_team`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_team)                   | <p>namespace<br>retailer</p> | Team dimension.                                                                                                    |
| [`dim_user`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_user)                   | <p>namespace<br>retailer</p> | User dimension.                                                                                                    |
| [`dim_wallet`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsdim_wallet)               | <p>namespace<br>retailer</p> | Wallet dimension.                                                                                                  |

### Facts

| Name                                                                                                                                                   | Access                       | Purpose                                                                                                                                                      |
| ------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| [`fact_ad_request`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_ad_request)                                     | <p>namespace<br>retailer</p> | Request fact (full detail).                                                                                                                                  |
| [`fact_ad_request_agg`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_ad_request_agg)                             | <p>namespace<br>retailer</p> | Request fact (aggregated).                                                                                                                                   |
| [`fact_ad_request_agg_ltz`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_ad_request_agg_ltz)                     | <p>namespace<br>retailer</p> | Request fact (aggregated) in local timezone.                                                                                                                 |
| [`fact_enhanced_attribution`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_enhanced_attribution)                 | <p>namespace<br>retailer</p> | Enhanced Attribution (full detail, first model only).                                                                                                        |
| [`fact_enhanced_attribution_2`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_enhanced_attribution_2)             | <p>namespace<br>retailer</p> | Enhanced Attribution (full detail, second model only).                                                                                                       |
| [`fact_enhanced_attribution_agg`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_enhanced_attribution_agg)         | <p>namespace<br>retailer</p> | Enhanced Attribution (aggregated).                                                                                                                           |
| [`fact_enhanced_attribution_agg_ltz`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_enhanced_attribution_agg_ltz) | <p>namespace<br>retailer</p> | Enhanced Attribution (aggregated) in local timezone.                                                                                                         |
| [`fact_fta_campaign_spend`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_fta_campaign_spend)                     | <p>namespace<br>retailer</p> | FTA Campaign Spend fact.                                                                                                                                     |
| [`fact_ledger`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_ledger)                                             | <p>namespace<br>retailer</p> | Ledger fact (full detail).                                                                                                                                   |
| [`fact_ledger_agg`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_ledger_agg)                                     | <p>namespace<br>retailer</p> | Ledger fact (aggregated into UTC+0 day buckets).                                                                                                             |
| [`fact_ledger_agg_2`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_ledger_agg_2)                                 | <p>namespace<br>retailer</p> | Ledger fact (aggregated into UTC+0 hourly buckets). Only for current + previous 3 months.                                                                    |
| [`fact_ledger_agg_2_ltz`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_ledger_agg_2_ltz)                         | <p>namespace<br>retailer</p> | Ledger fact (aggregated into local timezone hourly buckets). Only for current + previous 3 months.                                                           |
| [`fact_ledger_agg_ltz`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_ledger_agg_ltz)                             | <p>namespace<br>retailer</p> | Ledger fact (aggregated into local timezone day buckets).                                                                                                    |
| [`fact_order`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_order)                                               | <p>namespace<br>retailer</p> | Order fact (full detail).                                                                                                                                    |
| [`fact_order_agg`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_order_agg)                                       | <p>namespace<br>retailer</p> | Order fact (aggregated).                                                                                                                                     |
| [`fact_order_agg_ltz`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_order_agg_ltz)                               | <p>namespace<br>retailer</p> | Order fact (aggregated in local timezone dates).                                                                                                             |
| [`fact_realised_ad`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_realised_ad)                                   | <p>namespace<br>retailer</p> | Realised Ad fact (full detail).                                                                                                                              |
| [`fact_realised_ad_agg`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_realised_ad_agg)                           | <p>namespace<br>retailer</p> | Realised Ad fact (aggregated into UTC+0 day buckets).                                                                                                        |
| [`fact_realised_ad_agg_2`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_realised_ad_agg_2)                       | <p>namespace<br>retailer</p> | Realised Ad fact (aggregated, customer centric). Includes customer\_id, but no breakdown by Campaign, Placement and Product.                                 |
| [`fact_realised_ad_agg_3`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_realised_ad_agg_3)                       | <p>namespace<br>retailer</p> | Realised Ad fact (aggregated into UTC+0 hourly buckets). Only for current + previous 3 months.                                                               |
| [`fact_realised_ad_agg_3_live`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_realised_ad_agg_3_live)             | namespace                    | Realised Ad fact (aggregated into UTC+0 hourly buckets). Only for current + previous 2 Days.                                                                 |
| [`fact_realised_ad_agg_3_ltz`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_realised_ad_agg_3_ltz)               | <p>namespace<br>retailer</p> | Realised Ad fact (aggregated into local timezone hourly buckets). Only for current + previous 3 months.                                                      |
| [`fact_realised_ad_agg_3_ltz_live`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_realised_ad_agg_3_ltz_live)     | namespace                    | Realised Ad fact (aggregated into local timezone hourly buckets). Only for current + previous 2 days.                                                        |
| [`fact_realised_ad_agg_4a`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_realised_ad_agg_4a)                     | <p>namespace<br>retailer</p> | Realised Ad fact (aggregated by day). Based on fact\_realised\_ad with keyword and keyword\_matchtype. Includes metrics aggregated at the search term level. |
| [`fact_realised_ad_agg_4a_ltz`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_realised_ad_agg_4a_ltz)             | <p>namespace<br>retailer</p> | Realised Ad fact (aggregated by day). Based on fact\_realised\_ad with keyword and keyword\_matchtype. Includes metrics aggregated at the search term level. |
| [`fact_realised_ad_agg_ltz`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_realised_ad_agg_ltz)                   | <p>namespace<br>retailer</p> | Realised Ad fact (aggregated into local timezone day buckets).                                                                                               |
| [`fact_report_request_tracking`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_report_request_tracking)           | <p>namespace<br>retailer</p> | Epsilon Retail Media client reporting usage fact.                                                                                                            |
| [`fact_user_team`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticsfact_user_team)                                       | <p>namespace<br>retailer</p> | List of all Team Users.                                                                                                                                      |

### Logging

| Name                                                                                                     | Access                       | Purpose                                                                                               |
| -------------------------------------------------------------------------------------------------------- | ---------------------------- | ----------------------------------------------------------------------------------------------------- |
| [`log_status`](/retail-media-interface/integration/reporting/reporting-reference.md#analyticslog_status) | <p>namespace<br>retailer</p> | Logging table. Records when this dataset has been updated (both start time and end time with status). |

## Reporting Datamart

Location: `insight-platform-external-iam.<client name>_insight_reporting`

(eg `companya_insight_reporting`)

### Dimensions

| Name                                                                                                                   | Access                                   | Purpose                                                                                                                               |
| ---------------------------------------------------------------------------------------------------------------------- | ---------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------- |
| [`campaign`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingcampaign)                   | <p>supplier<br>retailer<br>namespace</p> | Campaign data.                                                                                                                        |
| [`catalog`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingcatalog)                     | <p>retailer<br>namespace</p>             | Catalog data.                                                                                                                         |
| [`category`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingcategory)                   | namespace                                | Category data.                                                                                                                        |
| [`deduped_product`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingdeduped_product)     | <p>retailer<br>namespace</p>             | Deduped product data.                                                                                                                 |
| [`env_namespace`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingenv_namespace)         | namespace                                | Namespace data.                                                                                                                       |
| [`placement`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingplacement)                 | namespace                                | Placement data.                                                                                                                       |
| [`product`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingproduct)                     | <p>retailer<br>namespace</p>             | Product data.                                                                                                                         |
| [`retailer`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingretailer)                   | <p>retailer<br>namespace</p>             | Retailer data.                                                                                                                        |
| [`retailer_supplier`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingretailer_supplier) | retailer                                 | Retailer centric Supplier data (only relevant Suppliers as referenced within Realised Ads generated against the Retailer's Catalogs). |
| [`search_term`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingsearch_term)             | namespace                                | Search Term data.                                                                                                                     |
| [`supplier`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingsupplier)                   | <p>supplier<br>namespace</p>             | Supplier data.                                                                                                                        |
| [`supplier_product`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingsupplier_product)   | supplier                                 | Supplier centric Product data (only relevant Products as referenced within Realised Ads generated by Supplier Campaigns).             |
| [`supplier_retailer`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingsupplier_retailer) | supplier                                 | Supplier centric Retailer data (only relevant Retailers as referenced within Realised Ads generated by Supplier Campaigns).           |
| [`team`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingteam)                           | <p>supplier<br>retailer<br>namespace</p> | Team data.                                                                                                                            |
| [`user`](/retail-media-interface/integration/reporting/reporting-reference.md#reportinguser)                           | namespace                                | User data.                                                                                                                            |
| [`user_team`](/retail-media-interface/integration/reporting/reporting-reference.md#reportinguser_team)                 | namespace                                | Team users data.                                                                                                                      |
| [`wallet`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingwallet)                       | <p>supplier<br>retailer<br>namespace</p> | Wallet data.                                                                                                                          |

### Facts

| Name                                                                                                                                         | Access                                   | Purpose                                                                                                                  |
| -------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------- | ------------------------------------------------------------------------------------------------------------------------ |
| [`ad_request_agg`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingad_request_agg)                             | <p>retailer<br>namespace</p>             | Request data (aggregated).                                                                                               |
| [`enhanced_attribution_agg`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingenhanced_attribution_agg)         | <p>retailer<br>namespace</p>             | Enhanced Attribution data (aggregated, both models).                                                                     |
| [`external_attribution_agg`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingexternal_attribution_agg)         | namespace                                | external Attribution data (aggregated, both models).                                                                     |
| [`external_attribution_agg_ltz`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingexternal_attribution_agg_ltz) | namespace                                | external Attribution data (aggregated, both models) LTZ Version.                                                         |
| [`fta_campaign_spend`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingfta_campaign_spend)                     | <p>supplier<br>namespace</p>             | FTA Campaign Spend data.                                                                                                 |
| [`ledger_agg`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingledger_agg)                                     | <p>supplier<br>retailer<br>namespace</p> | Ledger data (aggregated into UTC+0 day buckets).                                                                         |
| [`ledger_agg_2`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingledger_agg_2)                                 | <p>supplier<br>retailer<br>namespace</p> | Ledger data (aggregated into UTC+0 hourly buckets). Only for current + previous 3 months.                                |
| [`order_ad_stats`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingorder_ad_stats)                             | <p>retailer<br>namespace</p>             | Order and Realised Ad statistics data (aggregated).                                                                      |
| [`order_agg`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingorder_agg)                                       | <p>retailer<br>namespace</p>             | Order data (aggregated).                                                                                                 |
| [`realised_ad_agg`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingrealised_ad_agg)                           | supplier                                 | Realised Ad data (aggregated into UTC+0 day buckets).                                                                    |
| [`realised_ad_agg_2`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingrealised_ad_agg_2)                       | namespace                                | Realised Ad data (aggregated by customerid). Includes customer\_id, but no breakdown by Campaign, Placement and Product. |
| [`realised_ad_agg_3`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingrealised_ad_agg_3)                       | supplier                                 | Realised Ad data (aggregated into UTC+0 hourly buckets). Only for current + previous 3 months.                           |
| [`wallet_balance`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingwallet_balance)                             | <p>supplier<br>retailer<br>namespace</p> | Wallet balance data.                                                                                                     |

### Decorated Facts

| Name                                                                                                                                                   | Access                       | Purpose                                                                                                                                                                                                                                 |
| ------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [`ad_request__realised_ad_ltz_view`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingad_request__realised_ad_ltz_view)   | namespace                    | Union of ad\_request\_agg\_view and realised\_ad\_agg\_view (local timezone). Allows for convenient calculation of measures that require both Request and Realised Ad statistics (for example a ratio of impressions vs ads requested). |
| [`ad_request__realised_ad_view`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingad_request__realised_ad_view)           | <p>retailer<br>namespace</p> | Union of ad\_request\_agg\_view and realised\_ad\_agg\_view. Allows for convenient calculation of measures that require both Request and Realised Ad statistics (for example a ratio of impressions vs ads requested).                  |
| [`ad_request_agg_ltz_view`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingad_request_agg_ltz_view)                     | namespace                    | Request view (aggregated in local timezone). Decorated version of ad\_request\_agg.                                                                                                                                                     |
| [`ad_request_agg_view`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingad_request_agg_view)                             | <p>retailer<br>namespace</p> | Request view (aggregated). Decorated version of ad\_request\_agg.                                                                                                                                                                       |
| [`enhanced_attribution_agg_ltz_view`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingenhanced_attribution_agg_ltz_view) | namespace                    | Enhanced Attribution view (aggregated, both models in local timezone). Decorated version of enhanced\_attribution\_agg.                                                                                                                 |
| [`enhanced_attribution_agg_view`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingenhanced_attribution_agg_view)         | <p>retailer<br>namespace</p> | Enhanced Attribution view (aggregated, both models). Decorated version of enhanced\_attribution\_agg.                                                                                                                                   |
| [`external_attribution_agg_ltz_view`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingexternal_attribution_agg_ltz_view) | namespace                    | External Attribution view (aggregated, both models) LTZ version. Decorated version of external\_attribution\_agg\_ltz.                                                                                                                  |
| [`external_attribution_agg_view`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingexternal_attribution_agg_view)         | namespace                    | External Attribution view (aggregated, both models). Decorated version of external\_attribution\_agg.                                                                                                                                   |
| [`realised_ad_agg_ltz_view`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingrealised_ad_agg_ltz_view)                   | namespace                    | Realised Ad view (aggregated in local timezone) + FTA Campaign spend data. Union of realised\_ad\_agg and fta\_campaign\_spend.                                                                                                         |
| [`realised_ad_agg_view`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingrealised_ad_agg_view)                           | <p>retailer<br>namespace</p> | Realised Ad view (aggregated) + FTA Campaign spend data. Union of realised\_ad\_agg and fta\_campaign\_spend.                                                                                                                           |

## Visualisation

Location: `insight-platform-external-iam.<client name>_insight_reporting`

(eg `companya_insight_reporting`)

| Name                                                                                                                                                                                 | Purpose                                                                                                                                                                                                       |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [`viz_global_campaign_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_campaign_out)                                                   | Campaign data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is campaign.                                                                  |
| [`viz_global_catalog_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_catalog_out)                                                     | Catalog data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is catalog.                                                                    |
| [`viz_global_category_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_category_out)                                                   | Category data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is category.                                                                  |
| [`viz_global_daily_wallet_balance`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_daily_wallet_balance)                                   | Daily wallet balance data.                                                                                                                                                                                    |
| [`viz_global_decorated_ad__adrequest_stats_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_decorated_ad__adrequest_stats_out)         | Request and Realised Ad data (aggregated and unioned). Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is ad\_request\_\_realised\_ad\_view. |
| [`viz_global_decorated_ad_stats_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_decorated_ad_stats_out)                               | Realised Ad (aggregated) data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is realised\_ad\_agg\_view.                                   |
| [`viz_global_decorated_adrequests_stats_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_decorated_adrequests_stats_out)               | Request (aggregated) data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is ad\_request\_agg\_view.                                        |
| [`viz_global_decorated_bucketed_order_ad_stats_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_decorated_bucketed_order_ad_stats_out) | Order and Realised Ad (aggregated) data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is order\_ad\_stats.                                |
| [`viz_global_decorated_report_request_tracking_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_decorated_report_request_tracking_out) | Epsilon Retail Media client reporting usage (aggregated) data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is report\_request\_tracking. |
| [`viz_global_halo_attribution_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_halo_attribution_out)                                   | Enhanced Attribution (aggregated, both models) data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is enhanced\_attribution\_agg\_view.    |
| [`viz_global_ledger_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_ledger_out)                                                       | Ledger (aggregated) data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is ledger\_agg.                                                    |
| [`viz_global_product_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_product_out)                                                     | Product data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is product.                                                                    |
| [`viz_global_retailer_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_retailer_out)                                                   | Product data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is retailer.                                                                   |
| [`viz_global_sov_category_mth_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_sov_category_mth_out)                                   | Share of voice by Category data (month buckets). Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is insights\_sov\_category.                 |
| [`viz_global_sov_category_week_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_sov_category_week_out)                                 | Share of voice by Category data (weekly buckets). Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is insights\_sov\_category.                |
| [`viz_global_sov_search_term_mth_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_sov_search_term_mth_out)                             | Share of voice by Search Term data (month buckets). Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is insights\_sov\_search\_term.          |
| [`viz_global_supplier_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_supplier_out)                                                   | Supplier data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is supplier.                                                                  |
| [`viz_global_team_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_team_out)                                                           | Team data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is team.                                                                          |
| [`viz_global_team_user_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_team_user_out)                                                 | Team Users data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is user\_team.                                                              |
| [`viz_global_wallet_balance_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_wallet_balance_out)                                       | Wallet balance (daily) data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is wallet\_balance.                                             |
| [`viz_global_wallet_out`](/retail-media-interface/integration/reporting/reporting-reference.md#reportingviz_global_wallet_out)                                                       | Wallet data. Use to reconcile to the Epsilon Retail Media BI platform (if applicable). Legacy use only, preferred view to use is wallet.                                                                      |

Version: 1ace13f


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://help.citrusad.com/retail-media-interface/integration/reporting/reporting-schema-definitions.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.