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