Reference for the metrics, group_by dimensions, and filters supported by the Query Analytics Report endpoint. Last updated July 2026. Use this page to look up valid values for the metrics[].value, group_by[].name, and filters fields in your request payload.
This page lists the built-in metrics and group_by dimensions supported by the
Query Analytics Report endpoint. New metrics and dimensions are added over time — if you don't see a metric here, check the Apollo Analytics UI to confirm availability.
Important: Smart reference fields
Every metric object requires two fields beyond value that control which date and user fields the analytics engine uses when applying filters for that metric:
smart_datetime_reference: Which date field to use for the date range filtersmart_user_id_reference: Which user field to use for the team member filter
The tables on this page show the valid date and user field for each metric. Using the wrong value may return no data or unexpected results for that metric. The API does not validate reference field values against the metric type.
display_name is metadata only
You may include a display_name field on any metric object in the request. This is a UI label override and has no effect on the API response — bucket keys in the response always use the original metric value string (e.g. num_emails_sent), regardless of display_name.
Smart Reference Field Values
Important
smart_datetime_rangeorsmart_user_idare filter/grouping keys, not valid reference fields. These values are metric-specific. Use thesmart_datetime_referenceandsmart_user_id_referencevalues listed under the table for the metric family you're reporting on.
smart_datetime_reference
smart_datetime_reference| Value | Description |
|---|---|
activity_datetime | Exact timestamp of the activity, such as when an email was sent, a call was logged, a task activity occurred, or a meeting was recorded. |
contact_created_at | Date the contact was created in Apollo. |
account_created_at | Date the account was created in Apollo. |
task_created_at | Date the task was created. |
task_due_at | Due date of the task. Commonly used for task metrics. |
opportunity_created_at | Date the opportunity was created. Commonly used for opportunity metrics. |
opportunity_close_date | Expected or actual close date of the opportunity. |
start_time | Start time of a calendar event or conversation. |
end_time | End time of a calendar event. |
date_from | Date used for email deliverability score metrics. |
conversation_play_histories.listened_at | Date and time a conversation recording was listened to. |
conversation_comments.created_at | Date and time a conversation comment was created. |
conversation_scorecard_responses.submitted_at | Date and time a conversation scorecard response was submitted. |
smart_user_id_reference
smart_user_id_reference| Value | Description |
|---|---|
user_id | Apollo user associated with the activity or event, such as the user who sent an email, logged a call, completed a task, changed a stage, or triggered an enrichment activity. |
owner_id | Owner of the contact. Used by contact metrics. |
account_owner_id | Owner of the account. Used by account, and contact metrics. |
opportunity_owner_id | Owner of the opportunity. Used by opportunity metrics. |
contact_owner_id | Owner of the contact. Used by contact metrics. |
nested_participant_user_ids | Users who participated in a conversation. Used by conversation metrics. |
conversation_participants.user_id | User ID for a conversation participant. Used by conversation metrics. |
conversation_play_histories.user_id | User ID associated with a conversation playback/listen event. Used by conversation metrics. |
conversation_comments.conversation_user_id | User ID associated with a conversation comment. Used by conversation metrics. |
conversation_scorecard_responses.conversation_user_id | User ID associated with a submitted conversation scorecard response. Used by conversation metrics. |
Metrics
ImportantAll metrics with names beginning with
percent_(e.g.percent_emails_replied,percent_phone_calls_connect,percent_win_rate) return decimal values between 0 and 1. They are not percentages. For example,0.331means 33.1%. Multiply by 100 to convert to a percentage for display.
Email metrics
metrics[].value | Description | Valid smart_datetime_reference | Valid smart_user_id_reference |
|---|---|---|---|
num_emails_scheduled | Number of Emails scheduled. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_sent | Number of Emails sent — emails delivered or bounced. | activity_datetime, contact_created_at, account_created_at | user_id |
num_contacts_emailed | Number of Contacts emailed — unique contacts emailed. | activity_datetime, contact_created_at, account_created_at | user_id |
num_accounts_emailed | Number of Accounts emailed — unique accounts emailed. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_delivered | Number of Emails delivered. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_delivered_open_tracked | Number of Emails delivered with open tracking enabled. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_delivered_click_tracked | Number of Emails delivered with click tracking enabled. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_emails_delivered | Percentage of Emails delivered out of sent. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_bounced | Number of Emails bounced. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_bounced_waterfall_enriched | Number of Emails bounced that were Waterfall-enriched. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_bounced_waterfall_validated | Number of Emails bounced that were Waterfall-validated. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_emails_bounced | Percentage of Emails bounced out of sent. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_opened | Number of Emails opened (bots filtered). | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_opened_unfiltered | Number of Emails opened including bot opens. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_emails_opened_tracked | Percentage of Emails opened out of delivered with tracking enabled. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_emails_opened_unfiltered_tracked | Percentage of Emails opened (bots included) out of delivered with tracking enabled. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_clicked | Number of Emails clicked (bots filtered). | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_clicked_unfiltered | Number of Emails clicked including bot clicks. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_emails_clicked_tracked | Percentage of Emails clicked out of delivered with tracking enabled. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_emails_clicked_unfiltered_tracked | Percentage of Emails clicked (bots included) out of delivered with tracking enabled. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_replied | Number of Emails replied. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_replied_waterfall_enriched | Number of Emails replied that were Waterfall-enriched. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_replied_waterfall_validated | Number of Emails replied that were Waterfall-validated. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_emails_replied | Percentage of Emails replied out of delivered. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_positive | Number of Emails with positive sentiment. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_num_emails_positive | Percentage of Positive-sentiment emails out of delivered. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_negative | Number of Emails with negative sentiment. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_num_emails_negative | Percentage of Negative-sentiment emails out of delivered. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_demoed | Number of Emails marked "interested". | activity_datetime, contact_created_at, account_created_at | user_id |
percent_emails_demoed | Percentage of Emails interested out of delivered. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_unsubscribed | Number of Unsubscribes from emails. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_emails_unsubscribed | Percentage of Unsubscribes out of delivered. | activity_datetime, contact_created_at, account_created_at | user_id |
num_contacts_demoed | Number of Unique contacts marked "interested". | activity_datetime, contact_created_at, account_created_at | user_id |
num_contacts_opened | Number of Unique contacts who opened at least one email. | activity_datetime, contact_created_at, account_created_at | user_id |
num_contacts_replied | Number of Unique contacts who replied to at least one email. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_contacts_opened | Percentage of Contacts opened. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_contacts_replied | Percentage of Contacts replied. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_contacts_interested | Percentage of Contacts interested. | activity_datetime, contact_created_at, account_created_at | user_id |
num_emails_spam_blocked | Number of Emails blocked as spam. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_emails_spam_blocked | Percentage of Emails spam-blocked. | activity_datetime, contact_created_at, account_created_at | user_id |
email_deliverability_score | Average deliverability score across email accounts (metric_type: email_deliverability_score). | date_from | user_id |
Phone metrics
metrics[].value | Description | Valid smart_datetime_reference | Valid smart_user_id_reference |
|---|---|---|---|
num_phone_calls | Number of Outbound phone calls logged. | activity_datetime, contact_created_at, account_created_at | user_id |
num_contacts_called | Number of Unique contacts called. | activity_datetime, contact_created_at, account_created_at | user_id |
num_accounts_called | Number of Unique accounts called. | activity_datetime, contact_created_at, account_created_at | user_id |
num_phone_calls_connect | Number of Calls connected. | activity_datetime, contact_created_at, account_created_at | user_id |
num_phone_calls_connect_waterfall_enriched | Number of Calls connected on Waterfall-enriched numbers. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_phone_calls_connect | Percentage of Calls connected out of total logged. | activity_datetime, contact_created_at, account_created_at | user_id |
num_phone_calls_connect_positive | Number of Connected calls with disposition "positive". | activity_datetime, contact_created_at, account_created_at | user_id |
percent_phone_calls_connect_positive | Percentage of Connected calls with positive disposition. | activity_datetime, contact_created_at, account_created_at | user_id |
num_phone_calls_connect_neutral | Number of Connected calls with neutral disposition. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_phone_calls_connect_neutral | Percentage of Connected calls with neutral disposition. | activity_datetime, contact_created_at, account_created_at | user_id |
num_phone_calls_connect_negative | Number of Connected calls with negative disposition. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_phone_calls_connect_negative | Percentage of Connected calls with negative disposition. | activity_datetime, contact_created_at, account_created_at | user_id |
avg_phone_call_duration | Average call duration. | activity_datetime, contact_created_at, account_created_at | user_id |
dialer_total_calls | Number of Dials — outbound + inbound calls via the dialer. | activity_datetime, contact_created_at, account_created_at | user_id |
dialer_calls_answered | Number of Dialer connects — calls with duration ≥ 1 second. | activity_datetime, contact_created_at, account_created_at | user_id |
dialer_calls_conversations | Number of Dialer conversations — calls with duration ≥ 30 seconds. | activity_datetime, contact_created_at, account_created_at | user_id |
dialer_calls_bridged | Number of Calls successfully bridged. | activity_datetime, contact_created_at, account_created_at | user_id |
dialer_calls_callbacks | Number of Callbacks — inbound calls received. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_phone_calls_answered | Dial-to-connect rate — Percentage of dialed calls that connected. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_callbacks_answered | Callbacks-to-connect rate — Percentage of callbacks that connected. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_phone_calls_bridged | Bridged-to-connect rate — Percentage of total calls bridged. | activity_datetime, contact_created_at, account_created_at | user_id |
percent_connects_to_conversations | Connect-to-conversation rate — Percentage of connected calls ≥ 30s. | activity_datetime, contact_created_at, account_created_at | user_id |
Meeting metrics
metrics[].value | Description | Valid smart_datetime_reference | Valid smart_user_id_reference |
|---|---|---|---|
num_calendar_events_scheduled | Number of Meetings scheduled via Apollo Meetings. | activity_datetime, start_time, end_time | user_id |
num_calendar_events_scheduled_inbound | Number of Meetings scheduled via the Inbound router. | activity_datetime, start_time, end_time | user_id |
num_calendar_events_cancelled | Number of Meetings cancelled via Apollo Meetings. | activity_datetime, start_time, end_time | user_id |
num_calendar_events_cancelled_inbound | Number of Meetings cancelled via the Inbound router. | activity_datetime, start_time, end_time | user_id |
num_calendar_events_rescheduled | Number of Meetings rescheduled via Apollo Meetings. | activity_datetime, start_time, end_time | user_id |
num_all_meetings_scheduled | Number of All meetings scheduled (Apollo + external). | activity_datetime, start_time, end_time | user_id |
num_all_meetings_rescheduled | Number of All meetings rescheduled. | activity_datetime, start_time, end_time | user_id |
num_all_meetings_scheduled_via_email | Number of All meetings scheduled in response to email. | activity_datetime, start_time, end_time | user_id |
num_all_meetings_scheduled_via_call | Number of All meetings scheduled in response to phone calls. | activity_datetime, start_time, end_time | user_id |
num_meetings_attended | Number of Meetings where the guest attended. | activity_datetime, start_time, end_time | user_id |
num_meetings_no_show | Number of Meetings where the guest did not show up. | activity_datetime, start_time, end_time | user_id |
percent_meeting_show_rate | Percentage of scheduled meetings where the guest attended. | activity_datetime, start_time, end_time | user_id |
num_contacts_with_meetings | Number of Unique contacts with at least one meeting. | activity_datetime, start_time, end_time | user_id |
percent_contact_to_meeting_rate | Percentage of Sequence-enrolled contacts with at least one meeting. | activity_datetime, start_time, end_time | user_id |
Task metrics
metrics[].value | Description | Valid smart_datetime_reference | Valid smart_user_id_reference |
|---|---|---|---|
num_phone_calls_scheduled | Number of phone call tasks scheduled. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_phone_calls_completed | Number of phone call tasks completed. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_tasks | Number of Tasks — completed, scheduled, or archived. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_tasks_scheduled | Number of Tasks scheduled and not yet completed. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_email_item_tasks_scheduled | Number of Email tasks scheduled. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_action_item_tasks_scheduled | Number of Action-item tasks scheduled. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_tasks_completed_or_skipped | Number of Tasks completed or archived. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_tasks_completed | Number of Tasks completed. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
percent_tasks_completed | Percentage Tasks completed out of completed + archived. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_email_item_tasks_completed | Number of Email tasks completed. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_action_item_tasks_completed | Number of Action-item tasks completed. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_tasks_completed_on_time | Number of Tasks completed by their due date. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
percent_tasks_completed_on_time | Percentage Tasks completed on time out of completed. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
percent_total_tasks_completed_on_time | Percentage Tasks completed on time out of scheduled + completed + archived. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_tasks_skipped | Number of Tasks archived. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
percent_tasks_skipped | Percentage Tasks archived. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
overdue_tasks | Number of Overdue tasks — scheduled or completed past due date. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
unfinished_overdue_tasks | Number of Overdue tasks not completed by the due date. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
percent_unfinished_overdue_tasks | Percentage Unfinished overdue tasks. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_tasks_from_sequences | Number of Tasks created from sequences. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
percent_tasks_from_sequences | Percentage Tasks from sequences. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_linkedin_tasks_scheduled | Number of LinkedIn-type tasks scheduled. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_linkedin_tasks_completed_or_skipped | Number of LinkedIn tasks completed or archived. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_linkedin_tasks_completed | Number of LinkedIn tasks completed. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
percent_linkedin_tasks_completed | Percentage of LinkedIn tasks completed out of completed + archived. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_linkedin_tasks_completed_on_time | Number of LinkedIn tasks completed by their due date. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
percent_linkedin_tasks_completed_on_time | Percentage of LinkedIn tasks completed on time. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
num_linkedin_tasks_skipped | Number of LinkedIn tasks archived. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
percent_linkedin_tasks_skipped | Percentage of LinkedIn tasks archived. | task_created_at, activity_datetime, task_due_at, contact_created_at, account_created_at | user_id |
Contact metrics
metrics[].value | Description | Valid smart_datetime_reference | Valid smart_user_id_reference |
|---|---|---|---|
num_contacts | Number of Total contacts prospected. | contact_created_at, account_created_at | owner_id, account_owner_id |
num_crm_contacts | Number of Contacts and leads connected to your CRM. | contact_created_at, account_created_at | owner_id, account_owner_id |
num_salesforce_contacts | Number of Contacts connected to Salesforce. | contact_created_at, account_created_at | owner_id, account_owner_id |
num_salesforce_leads | Number of Leads connected to Salesforce. | contact_created_at, account_created_at | owner_id, account_owner_id |
num_contacts_with_job_change | Number of Contacts who have changed jobs. | contact_created_at, account_created_at | owner_id, account_owner_id |
num_contacts_with_missing_email | Number of Contacts whose email is missing. | contact_created_at, account_created_at | owner_id, account_owner_id |
num_total_contacts_in_sequence | Number of Cumulative contacts ever added to any sequence. | contact_created_at, account_created_at | owner_id, account_owner_id |
num_total_accounts_in_sequence | Number of Cumulative unique accounts with ever-sequenced contacts. | contact_created_at, account_created_at | owner_id, account_owner_id |
num_contacts_touched | Number of unique contacts touched via phone calls or emails. | activity_datetime, contact_created_at | user_id, contact_owner_id |
num_contacts_added_to_sequence | Number of unique contacts added to a sequence. | activity_datetime, contact_created_at, account_created_at | user_id |
num_contacts_remove_from_sequence | Number of unique contacts removed from a sequence. | activity_datetime, contact_created_at, account_created_at | user_id |
num_net_new_people | Number of people that have not been prospected yet. | — | — |
Note:
num_net_new_peopledoes not use date or user reference fields — any values you pass forsmart_datetime_referenceandsmart_user_id_referenceare ignored. You must still include both keys in each metric object, as the API rejects a metric that is missing either key.
Account metrics
metrics[].value | Description | Valid smart_datetime_reference | Valid smart_user_id_reference |
|---|---|---|---|
num_accounts | Number of Total accounts prospected. | account_created_at | account_owner_id |
num_accounts_touched | Number of unique accounts touched via phone calls or emails. | activity_datetime, account_created_at | user_id, account_owner_id |
num_net_new_companies | Number of companies that have not been prospected yet. | — | — |
revenue_amount | $ Sum of account revenue (thousand-dollar units). | account_created_at | account_owner_id |
avg_revenue_amount | $ Average account revenue (thousand-dollar units). | account_created_at | account_owner_id |
num_crm_accounts | Number of Accounts connected to your CRM. | account_created_at | account_owner_id |
num_stage_change_accounts | Number of Unique accounts that changed stage at least once. | activity_datetime, account_created_at | user_id |
Note:
num_net_new_companiesdoes not use date or user reference fields — any values you pass forsmart_datetime_referenceandsmart_user_id_referenceare ignored. You must still include both keys in each metric object, as the API rejects a metric that is missing either key.
Opportunity metrics
metrics[].value | Description | Valid smart_datetime_reference | Valid smart_user_id_reference |
|---|---|---|---|
num_opportunities | Number of Deals total. | opportunity_created_at, opportunity_close_date | opportunity_owner_id |
num_won | Number of Deals in Closed/Won. | opportunity_created_at, opportunity_close_date | opportunity_owner_id |
num_closed | Number of Deals in Closed/Won or Closed/Lost. | opportunity_created_at, opportunity_close_date | opportunity_owner_id |
won_amount | $ Sum of amounts across Closed/Won deals (revenue). | opportunity_created_at, opportunity_close_date | opportunity_owner_id |
avg_won_amount | $ Average deal size across Closed/Won deals. | opportunity_created_at, opportunity_close_date | opportunity_owner_id |
total_forecasted_revenue | $ Total weighted forecasted revenue, weighted by stage probability. | opportunity_created_at, opportunity_close_date | opportunity_owner_id |
avg_forecasted_revenue | $ Average weighted forecasted revenue. | opportunity_created_at, opportunity_close_date | opportunity_owner_id |
deal_amount | $ Sum of amounts across all deals. | opportunity_created_at, opportunity_close_date | opportunity_owner_id |
avg_deal_amount | $ Average amount across all deals. | opportunity_created_at, opportunity_close_date | opportunity_owner_id |
avg_salescycle_days | Average sales-cycle length in days (first touch to close). | opportunity_created_at, opportunity_close_date | opportunity_owner_id |
percent_win_rate | Percentage Win rate — Closed/Won ÷ (Closed/Won + Closed/Lost). | opportunity_created_at, opportunity_close_date | opportunity_owner_id |
pipeline_amount | $ Pipeline generated — sum across Pipeline/Best Case/Commit/Closed forecast categories. | opportunity_created_at, opportunity_close_date | opportunity_owner_id |
num_stage_change_opportunities | Number of Unique deals that changed stage at least once. | activity_datetime, opportunity_created_at, opportunity_close_date | user_id, opportunity_owner_id |
avg_stage_change_days | Average days between stage changes. | activity_datetime, opportunity_created_at, opportunity_close_date | user_id, opportunity_owner_id |
Conversation Intelligence metrics
Feature RequiredThese metrics require the Conversation Intelligence feature to be enabled on your Apollo plan and active call recording to be in use. Queries return no data if the feature is not active.
metrics[].value | Description | Valid smart_datetime_reference | Valid smart_user_id_reference |
|---|---|---|---|
num_meetings_held | Number of Meetings recorded as conversations. | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
num_conversations_recorded | Number of Conversations recorded. | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
num_conversations_upcoming | Number of Upcoming (scheduled) conversations. | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
speaker_switches | Number of Times the speaker switched between customer and team member. | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
avg_longest_customer_story | Average of the longest customer monologue per conversation (ms). | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
avg_patience | Average patience — duration between customer and team-member speaking (ms). | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
avg_talk_ratio | Average talk ratio (team vs. customer). | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
avg_question_rate | Average question rate. | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
avg_longest_monologue | Average of the team member's longest monologue per conversation (ms). | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
num_conversations_listened | Number of Conversations listened to. | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
num_conversations_with_comments | Number of Conversations that received at least one comment. | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
num_conversations_with_scorecards | Number of Conversations with a scorecard response. | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
avg_conversation_duration | Average duration of conversations (ms). | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
total_conversation_duration | Total duration of conversations (ms). | start_time, conversation_play_histories.listened_at, conversation_comments.created_at, conversation_scorecard_responses.submitted_at | nested_participant_user_ids, conversation_participants.user_id, conversation_play_histories.user_id, conversation_comments.conversation_user_id, conversation_scorecard_responses.conversation_user_id |
Custom metrics
You can query custom metrics defined by your team using the format custom_metric_{id}, where
{id} is the custom metric's id (e.g. custom_metric_507f1f77bcf86cd799439011).
Custom metric data is team-scoped; the API key you use must belong to the same Apollo team that
owns the custom metric. Group_by dimensions and filters must be compatible with the custom metric's
underlying metric type (same compatibility rules as the equivalent built-in metric).
Do not include the custom_metric_ prefix in the id portion. Use the full string including the prefix as the value:
{
"value": "custom_metric_507f1f77bcf86cd799439011",
"smart_datetime_reference": "smart_datetime_range",
"smart_user_id_reference": "smart_user_id"
}Group_by Dimensions
The following values are valid for group_by[].name and pivot_group_by[].name.
Note: Only one entry is supported in
group_byand one inpivot_group_byper request.
group_bydefines the row dimension;pivot_group_bydefines the column dimension for pivot queries.Pivot response structure: In pivot queries,
table_responseis keyed by thepivot_group_bydimension (columns), with thegroup_bydimension (rows) nested inside each column bucket. This is the inverse of the conceptual row/column model; iterate the outerbucketsarray to get columns, then each column's innerbucketsarray to get row values for that column.Tip: Not all dimensions are compatible with all metrics. Build a report in
Apollo Analytics to verify which dimensions
are available for your chosen metrics before querying the API.
Time dimensions
group_by[].name | Description |
|---|---|
smart_datetime_hour | Break down by hour (absolute — one bucket per hour across the date range) |
smart_datetime_hour_of_day | Break down by hour of day (0–23, aggregated across all dates in the range) |
smart_datetime_day_of_week | Break down by day of week (aggregated across all dates in the range) |
smart_datetime_month_of_year | Break down by month of year (1–12, aggregated across all years in the range) |
smart_datetime_day | Break down by day |
smart_datetime_week | Break down by week |
smart_datetime_month | Break down by month |
smart_datetime_year | Break down by year |
Smart datetime dimensions: All
smart_datetime_*dimensions automatically resolve to the correct underlying date field for each metric type. For absolute time series (one bucket per period), usesmart_datetime_hour,smart_datetime_day,smart_datetime_week,smart_datetime_month, orsmart_datetime_year. For recurring patterns aggregated across the range (e.g. "how does Monday compare to Friday?"), usesmart_datetime_hour_of_day,smart_datetime_day_of_week, orsmart_datetime_month_of_year.Note:
smart_datetime_quarteris not supported — it returns raw epoch timestamps instead of human-readable values.
User and team dimensions
group_by[].name | Description |
|---|---|
smart_user_id | Break down by Apollo team member (rep) |
smart_subteam_id | Break down by sub-team |
Account dimensions
group_by[].name | Description |
|---|---|
account_id | Break down by individual account |
account_owner_id | Break down by account owner |
account_stage_id | Break down by account stage |
account_label_ids | Break down by account label |
organization_num_current_employees | Break down by company headcount range |
organization_industries | Break down by industry |
organization_hq_location_country | Break down by company HQ country |
organization_hq_location_state | Break down by company HQ state |
organization_hq_location_city | Break down by company HQ city |
organization_latest_funding_stage_cd | Break down by latest funding stage |
organization_current_technologies | Break down by technology in use |
Contact dimensions
group_by[].name | Description |
|---|---|
contact_id | Break down by individual contact |
contact_owner_id | Break down by contact owner |
contact_stage_id | Break down by contact stage |
contact_label_ids | Break down by contact label |
persona | Break down by persona |
person_title_unanalyzed | Break down by job title |
person_seniority | Break down by seniority level |
person_location_country | Break down by contact location country |
person_location_state | Break down by contact location state |
person_location_city | Break down by contact location city |
Email and sequence dimensions
group_by[].name | Description |
|---|---|
emailer_campaign_id | Break down by sequence |
emailer_template_id | Break down by email template |
emailer_message_type | Break down by email type. Known values include outreach_automatic_email (sequence-automated sends) and outreach_manual_email (manually sent from a sequence step). |
emailer_step_id | Break down by sequence step (by step ID) |
emailer_touch_id | Break down by sequence step touch number or variant |
send_from_domain | Break down by sender domain |
send_from_email | Break down by sender email address |
email_account_id | Break down by email account (sender mailbox) |
Phone dimensions
group_by[].name | Description |
|---|---|
phone_call_outcome_id | Break down by call disposition (outcome) |
phone_call_purpose_id | Break down by call purpose |
phone_call_sentiment | Break down by call sentiment |
Opportunity dimensions
group_by[].name | Description |
|---|---|
opportunity_id | Break down by individual opportunity |
opportunity_owner_id | Break down by opportunity owner |
opportunity_stage_id | Break down by opportunity stage |
forecast_category | Break down by forecast category |
lead_source | Break down by lead source |
opportunity_deal_source | Break down by deal source |
opportunity_pipeline_id | Break down by pipeline |
Task dimensions
group_by[].name | Description |
|---|---|
task_type | Break down by task type |
task_status | Break down by task status |
Conversation Intelligence dimensions
group_by[].name | Description |
|---|---|
conversation_state | Break down by conversation state |
conversation_type | Break down by conversation type |
tracker_names_unanalyzed | Break down by conversation tracker or topic keyword |
Calendar dimensions
group_by[].name | Description |
|---|---|
calendar_event_setting_type | Break down by calendar event type |
Filters
Filters are passed as a flat key/value object. Most filter values are arrays of IDs for the
corresponding entity, or the special string "current" where noted.
Tip: The easiest way to discover filter IDs for your account is to open
Apollo Analytics → Start from scratch,
configure a report with the filters you want, then inspect the outgoingsync_report
network request in your browser's DevTools — thefiltersobject in that payload contains
the exact IDs to use.
| Filter key | Value type | Description | How to get IDs |
|---|---|---|---|
smart_user_id | array of strings | Filter to specific team members. Use "current" for the authenticated user. | Get a List of Users → id field |
smart_subteam_id | array of strings | Filter to specific sub-teams. | Apollo Settings → Sub-teams — IDs visible in the page URL when editing a sub-team (admin access required) |
emailer_campaign_ids | array of strings | Filter to specific sequences. | Search for Sequences → id field |
contact_stage_ids | array of strings | Filter to specific contact stages. | List Contact Stages → id field |
account_stage_ids | array of strings | Filter to specific account stages. | List Account Stages → id field |
opportunity_stage_ids | array of strings | Filter to specific opportunity/deal stages. | List Deal Stages → id field |
email_account_ids | array of strings | Filter to specific sender mailboxes. | Get a List of Email Accounts → id field |
smart_datetime_range | object | Required for custom date ranges (see below). | — |
Custom date range filter
When you set date_ranges[0].modality to custom_range, you must also include a
smart_datetime_range filter that specifies the exact dates:
{
"date_ranges": [
{ "modality": "custom_range" }
],
"filters": {
"smart_datetime_range": {
"min": "2024-01-01",
"max": "2024-03-31"
}
}
}Totals Rows and Columns
Two boolean request fields control whether aggregated totals are appended to the response alongside per-dimension-value rows:
| Parameter | Default | Effect when true |
|---|---|---|
group_by_totals_selected | false | Response includes a group_by_total_response field alongside table_response. For most queries, group_by_total_response mirrors the per-dimension buckets from table_response; it does not collapse them into a single aggregate row. |
pivot_group_by_totals_selected | false | Response includes aggregated totals per pivot column value in pivot_group_by_total_response, summing across all row values for each column. Only meaningful in pivot queries. |
Both fields default to false and can be set independently.
Date Range Presets
Use one of the following values for date_ranges[].modality:
| Modality | Period |
|---|---|
today | Current day |
yesterday | Previous day |
current_week | Current calendar week (Mon–Sun) |
current_month | Current calendar month |
current_quarter | Current calendar quarter |
current_year | Current calendar year |
last_7_days | Rolling last 7 days |
last_2_weeks | Rolling last 14 days |
last_30_days | Rolling last 30 days |
last_3_months | Rolling last 3 months |
last_6_months | Rolling last 6 months |
last_12_months | Rolling last 12 months |
last_4_quarters | Rolling last 4 quarters |
last_2_years | Rolling last 2 years |
previous_week | Full previous calendar week |
previous_month | Full previous calendar month |
previous_quarter | Full previous calendar quarter |
previous_year | Full previous calendar year |
all_time | All available data |
custom_range | Custom date range (requires smart_datetime_range filter — see above) |