Supermetrics brings all your Close CRM data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure
49 metrics140 dimensionsACTIVITY
|
|
| latest_activity_user_name | |
|
|
|
CALL
|
|
| latest_incoming_call_date | |
|
| latest_incoming_call_datetime | |
|
| latest_outgoing_call_date | |
|
| latest_outgoing_call_datetime | |
|
|
|
|
| latest_voicemail_duration | |
|
|
|
|
|
|
|
|
|
|
|
COMMUNICATION
|
|
| latest_communication_user_name | |
|
| latest_communication_user_id | |
|
| latest_communication_date | |
|
| latest_communication_datetime | |
|
|
|
| first_communication_user_name | |
|
| first_communication_user_id | |
|
|
| first_communication_datetime | |
|
|
CONTACT
DATASOURCE
|
| system_metadata.data_source_logins | |
|
| system_metadata.data_source_login_owners | |
|
EMAIL
|
|
| latest_received_email_date | |
|
| latest_received_email_datetime | |
|
|
| latest_sent_email_datetime | |
|
|
| email_last_opened_datetime | |
|
|
|
|
|
|
|
LEAD
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| latest_lead_status_change_date | |
|
| latest_lead_status_change_datetime | |
|
|
MEETING
|
|
|
|
| declined_meetings_by_lead | |
|
| declined_meetings_by_organization | |
|
|
|
NOTE
OPPORTUNITY
| latest_opportunity_status_change_date | |
|
| latest_opportunity_status_change_datetime | |
|
| total_opportunity_value_summary | |
|
| active_opportunity_value_summary | |
|
| won_opportunity_value_summary | |
|
| lost_opportunity_value_summary | |
|
|
|
|
|
|
|
|
OPPORTUNITY VALUE
| total_opportunity_value_annual | |
|
| total_opportunity_value_monthly | |
|
| total_opportunity_value_one_time | |
|
| total_active_opportunity_value_annual | |
|
| total_active_opportunity_value_monthly | |
|
| total_active_opportunity_value_one_time | |
|
| total_won_opportunity_value_annual | |
|
| total_won_opportunity_value_monthly | |
|
| total_won_opportunity_value_one_time | |
|
| total_lost_opportunity_value_annual | |
|
| total_lost_opportunity_value_monthly | |
|
| total_lost_opportunity_value_one_time | |
|
| primary_opportunity_value | |
|
ORGANIZATION
OTHER
PRIMARY CONTACT DETAILS
|
|
|
|
|
|
| primary_email_is_subscribed | |
|
|
PRIMARY OPPORTUNITY
| primary_opportunity_value_summary | |
|
| primary_opportunity_user_id | |
|
| primary_opportunity_user_name | |
|
| primary_opportunity_status_id | |
|
| primary_opportunity_status_name | |
|
| primary_opportunity_status_label | |
|
| primary_opportunity_status_type | |
|
| primary_opportunity_won_date | |
|
| primary_opportunity_created_date | |
|
| primary_opportunity_created_datetime | |
|
| primary_opportunity_updated_date | |
|
| primary_opportunity_updated_datetime | |
|
| primary_opportunity_confidence | |
|
| primary_opportunity_billing_period | |
|
| primary_opportunity_pipeline_id | |
|
| primary_opportunity_pipeline_name | |
|
QUERY
| system_metadata.query_date_range_start | |
|
| system_metadata.query_date_range_end | |
|
| system_metadata.query_timezone | |
|
| system_metadata.query_filters | |
|
| system_metadata.query_date_start | |
|
| system_metadata.query_date_end | |
|
| system_metadata.query_duration | |
|
| system_metadata.query_accounts | |
|
SMS MESSAGE
|
|
|
| latest_received_sms_datetime | |
|
|
|
|
|
|
|
| first_received_sms_datetime | |
|
|
|
|
|
|
|
TASK
TIME