# Performance Hourly Standard Aggregated Performance Report in Campaign Currency ### Fields | Field | Time Windows | Rollups | | --- | --- | --- | | **Dimensions** | | | | `agg_timestamp` | `current_day`, `last_X_hours`, `yesterday`, `last_X_days`, `month_to_date` | `by_hour`, `by_day`, `by_week`, `by_month` | | `advertiser_id`
| Any | Any | | `advertiser_name`
| Any | Any | | `agency_id`
| Any | Any | | `agency_name`
| Any | Any | | `campaign_archived`
| Any | Any | | `campaign_conversion_type`
| Any | Any | | `campaign_conversion_variable_minutes`
| Any | Any | | `campaign_created_on`
Campaign Creation Time | Any | Any | | `campaign_currency_code`
Campaign Currency Code | Any | Any | | `campaign_custom_attribution_source`
| Any | Any | | `campaign_dynamic_budget_allocation_type`
| Any | Any | | `campaign_end_date`
(GMT) Campaign End Date | Any | Any | | `campaign_end_date_campaign_tz`
(CTZ) Campaign End Date | Any | Any | | `campaign_frequency_amount`
Campaign Frequency Amount | Any | Any | | `campaign_frequency_interval`
Campaign Frequency Interval | Any | Any | | `campaign_frequency_optimization`
Campaign Frequency Optimization | Any | Any | | `campaign_frequency_type`
Campaign Frequency Type | Any | Any | | `campaign_goal_type`
| Any | Any | | `campaign_goal_value`
| Any | Any | | `campaign_has_custom_attribution`
| Any | Any | | `campaign_id`
| Any | Any | | `campaign_impression_cap_amount`
| Any | Any | | `campaign_impression_cap_automatic`
| Any | Any | | `campaign_impression_cap_type`
| Any | Any | | `campaign_initial_start_date`
(GMT) Campaign Initial Start Date | Any | Any | | `campaign_initial_start_date_campaign_tz`
(CTZ) Campaign Initial Start Date | Any | Any | | `campaign_io_name`
| Any | Any | | `campaign_io_reference_num`
| Any | Any | | `campaign_is_programmatic_guaranteed`
Campaign Is Programmatic Guaranteed | Any | Any | | `campaign_name`
| Any | Any | | `campaign_pc_window_minutes`
| Any | Any | | `campaign_political`
| Any | Any | | `campaign_pv_pct`
| Any | Any | | `campaign_pv_window_minutes`
| Any | Any | | `campaign_service_type`
Campaign Service Type, a.k.a. Managed Service Flag / managed_service_flag | Any | Any | | `campaign_spend_cap_amount`
| Any | Any | | `campaign_spend_cap_automatic`
| Any | Any | | `campaign_spend_cap_daily_cap`
| Any | Any | | `campaign_spend_cap_type`
| Any | Any | | `campaign_start_date`
(GMT) Campaign Start Date | Any | Any | | `campaign_start_date_campaign_tz`
(CTZ) Campaign Start Date | Any | Any | | `campaign_status`
Active Status | Any | Any | | `campaign_total_budget`
| Any | Any | | `campaign_total_impression_budget`
Campaign Impressions Budget | Any | Any | | `campaign_updated_on`
Campaign Update Time | Any | Any | | `campaign_zone_name`
Campaign Time Zone, a.k.a time_zone | Any | Any | | `flight_id`
| Any | Any | | `merit_pixel_created_on`
Pixel Creation Time | Any | Any | | `merit_pixel_eligible`
| Any | Any | | `merit_pixel_external_identifier`
| Any | Any | | `merit_pixel_funnel_position`
| Any | Any | | `merit_pixel_id`
| Any | Any | | `merit_pixel_name`
| Any | Any | | `merit_pixel_status`
| Any | Any | | `merit_pixel_updated_on`
Pixel Update Time | Any | Any | | `merit_pixel_weight`
| Any | Any | | `organization_id`
| Any | Any | | `organization_name`
| Any | Any | | `prisma_campaign_id`
| Any | Any | | `prisma_campaign_name`
| Any | Any | | `prisma_client_product_estimate`
| Any | Any | | `prisma_io_number`
| Any | Any | | `strategy_archived`
| Any | Any | | `strategy_audience_segment_exclude_op`
| Any | Any | | `strategy_audience_segment_include_op`
| Any | Any | | `strategy_bid_aggressiveness`
| Any | Any | | `strategy_bid_price_is_media_only`
| Any | Any | | `strategy_budget`
| Any | Any | | `strategy_channel`
| Any | Any | | `strategy_created_on`
| Any | Any | | `strategy_description`
| Any | Any | | `strategy_end_date`
| Any | Any | | `strategy_exchange_type_for_run_on_all`
| Any | Any | | `strategy_frequency_amount`
| Any | Any | | `strategy_frequency_interval`
Campaign Frequency Interval | Any | Any | | `strategy_frequency_optimization`
| Any | Any | | `strategy_frequency_type`
Campaign Frequency Type | Any | Any | | `strategy_goal_type`
| Any | Any | | `strategy_goal_value`
| Any | Any | | `strategy_group_created_on`
| Any | Any | | `strategy_group_description`
| Any | Any | | `strategy_group_external_identifier`
| Any | Any | | `strategy_group_id`
| Any | Any | | `strategy_group_impression_cap_amount`
| Any | Any | | `strategy_group_impression_cap_type`
| Any | Any | | `strategy_group_name`
| Any | Any | | `strategy_group_spend_cap_amount`
| Any | Any | | `strategy_group_spend_cap_type`
| Any | Any | | `strategy_group_updated_on`
| Any | Any | | `strategy_groups`
| Any | Any | | `strategy_id`
| Any | Any | | `strategy_impression_pacing_amount`
| Any | Any | | `strategy_impression_pacing_interval`
| Any | Any | | `strategy_impression_pacing_type`
| Any | Any | | `strategy_max_bid`
| Any | Any | | `strategy_max_bid_wm`
| Any | Any | | `strategy_min_bid`
| Any | Any | | `strategy_name`
| Any | Any | | `strategy_pacing_amount`
| Any | Any | | `strategy_pacing_interval`
| Any | Any | | `strategy_pacing_optimization_amount`
| Any | Any | | `strategy_pacing_optimization_type`
| Any | Any | | `strategy_pacing_type`
| Any | Any | | `strategy_roi_target`
| Any | Any | | `strategy_site_restriction_transparent_urls`
| Any | Any | | `strategy_start_date`
| Any | Any | | `strategy_status`
Active Status | Any | Any | | `strategy_targeting_segment_exclude_op`
| Any | Any | | `strategy_targeting_segment_include_op`
| Any | Any | | `strategy_updated_on`
| Any | Any | | `strategy_use_campaign_end`
| Any | Any | | `strategy_use_campaign_start`
| Any | Any | | `strategy_use_mm_freq`
| Any | Any | | `strategy_use_optimization`
| Any | Any | | **Metrics** | | | | `clicks`
| Any | Any | | `ctc`
CTC | Any | Any | | `ctr`
CTR | Any | Any | | `general_invalid_clicks`
| Any | Any | | `impressions`
| Any | Any | | `in_view`
In View Impressions | Any | Any | | `in_view_100_percent`
100% In View Impressions | Any | Any | | `in_view_15_seconds`
| Any | Any | | `in_view_15_seconds_rate`
| Any | Any | | `in_view_5_seconds`
| Any | Any | | `in_view_5_seconds_rate`
| Any | Any | | `measurability_rate`
Measurability Rate | Any | Any | | `measurable`
Measurable Impressions | Any | Any | | `post_click_aov`
Post-Click AOV | Any | Any | | `post_click_conversions`
Post-Click Conversions | Any | Any | | `post_click_conversions_unweighted`
Post-Click Conversions (Unweighted) | Any | Any | | `post_click_revenue`
Post-Click Revenue | Any | Any | | `post_click_revenue_usd`
| Any | Any | | `post_click_total_spend_roi`
Post-Click Total Spend ROI | Any | Any | | `post_view_aov`
Post-View AOV | Any | Any | | `post_view_conversions`
Post-View Conversions | Any | Any | | `post_view_conversions_unweighted`
Post-View Conversions (Unweighted) | Any | Any | | `post_view_revenue`
Post-View Revenue | Any | Any | | `post_view_total_spend_roi`
Post-View Total Spend ROI | Any | Any | | `rr_per_1k_imps`
Response Rate/1K Imps | Any | Any | | `total_aov`
Total AOV | Any | Any | | `total_clicks`
| Any | Any | | `total_conversions`
| Any | Any | | `total_conversions_unweighted`
Total Conversions (Unweighted) | Any | Any | | `total_revenue`
| Any | Any | | `total_spend`
| Any | Any | | `total_spend_cpa`
Total Spend eCPA | Any | Any | | `total_spend_cpc`
Total Spend eCPC | Any | Any | | `total_spend_cpcv`
Total Spend eCPCV | Any | Any | | `total_spend_cpm`
Total Spend eCPM | Any | Any | | `total_spend_pc_cpa`
Total Spend PC CPA | Any | Any | | `total_spend_pv_cpa`
Total Spend PV CPA | Any | Any | | `total_spend_roi`
Total Spend ROI | Any | Any | | `total_spend_usd`
| Any | Any | | `total_spend_vcpm`
Total Spend vCPM | Any | Any | | `video_close`
Close | Any | Any | | `video_collapse`
Collapse | Any | Any | | `video_companion_clicks`
Companion Clicks | Any | Any | | `video_companion_ctr`
Companion CTR | Any | Any | | `video_companion_impressions`
Companion Impressions | Any | Any | | `video_complete`
100% Completed Views | Any | Any | | `video_complete_rate`
100% Completed Rate | Any | Any | | `video_complete_rate_impression_based`
VCR (Impression Based) | Any | Any | | `video_engaged_impressions`
Engaged Impressions | Any | Any | | `video_engaged_rate`
Engaged Rate | Any | Any | | `video_expand`
Expand | Any | Any | | `video_first_quartile`
25% Completed Views | Any | Any | | `video_first_quartile_rate`
25% Completed Rate | Any | Any | | `video_first_quartile_rate_impression_based`
25% Completed Rate - Impressions Based | Any | Any | | `video_fullscreen`
Fullscreen | Any | Any | | `video_midpoint`
50% Completed Views | Any | Any | | `video_midpoint_rate`
50% Completed Rate | Any | Any | | `video_midpoint_rate_impression_based`
50% Completed Rate - Impressions Based | Any | Any | | `video_mute`
| Any | Any | | `video_pause`
Pause | Any | Any | | `video_play_rate`
Play Rate | Any | Any | | `video_resume`
Resume | Any | Any | | `video_rewind`
Rewind | Any | Any | | `video_skip`
Skip | Any | Any | | `video_skippable_impressions`
Skippable Impressions | Any | Any | | `video_skipped_impressions`
Skipped Impressions | Any | Any | | `video_skipped_rate`
Skipped Rate | Any | Any | | `video_start`
Start | Any | Any | | `video_third_quartile`
75% Completed Views | Any | Any | | `video_third_quartile_rate`
75% Completed Rate | Any | Any | | `video_third_quartile_rate_impression_based`
75% Completed Rate - Impressions Based | Any | Any | | `video_unmute`
| Any | Any | | `viewability_rate`
Viewability Rate | Any | Any | | `viewability_rate_100_percent`
100% In View Rate | Any | Any | ### Pageable Yes ### Time Windows `current_day`, `last_X_hours`, `yesterday`, `last_X_days`, `month_to_date` ### Rollups `all`, `by_hour`, `by_day`, `by_week`, `by_month` ### Data Retention / Lookback Window 90 days ### Time Zones `UTC`, `campaign` Endpoint: POST /performance-hourly Version: 1.0.0 Security: Auth0 ## Response 200 fields (application/json): - `meta` (object) - `meta.items_count` (integer) - `meta.page_index` (integer) - `meta.status` (string) Enum: "OK" - `meta.total_items_count` (integer) - `meta.total_pages` (integer) - `results` (array) ## Response 400 fields (application/json): - `error_code` (string) - `message` (string) - `request_id` (string) ## Response 401 fields (application/json): - `error_code` (string) - `message` (string) - `request_id` (string) ## Response 5XX fields (application/json): - `error_code` (string) - `message` (string) - `request_id` (string)