SparkPost

Explore the interactive ERD

Table & Field Reference

rejection_reason_metrics

Column	Type	Keys
`_fivetran_id`	String	PK
`count_rejected`	Unknown
`domain`	Unknown
`end_date`	Unknown
`metric_type`	Unknown
`reason`	Unknown
`rejection_category_id`	Unknown
`rejection_category_name`	Unknown
`start_date`	Unknown

deliverability_metrics

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_id`	Unknown	FK
`subaccount_id`	Unknown	FK
`template_id`	Unknown	FK
`count_accepted`	Unknown
`count_admin_bounce`	Unknown
`count_block_bounce`	Unknown
`count_bounce`	Unknown
`count_clicked`	Unknown
`count_delayed`	Unknown
`count_delayed_first`	Unknown
`count_delivered`	Unknown
`count_delivered_first`	Unknown
`count_delivered_subsequent`	Unknown
`count_generation_failed`	Unknown
`count_generation_rejection`	Unknown
`count_hard_bounce`	Unknown
`count_inband_bounce`	Unknown
`count_inbox_panel`	Unknown
`count_inbox_seed`	Unknown
`count_inbox_seed_private`	Unknown
`count_inbox_seed_virtual`	Unknown
`count_initial_rendered`	Unknown
`count_injected`	Unknown
`count_moved_to_inbox`	Unknown
`count_moved_to_spam`	Unknown
`count_nonprefetched_rendered`	Unknown
`count_nonprefetched_unique_confirmed_opened`	Unknown
`count_nonprefetched_unique_rendered`	Unknown
`count_outofband_bounce`	Unknown
`count_policy_rejection`	Unknown
`count_rejected`	Unknown
`count_rendered`	Unknown
`count_sent`	Unknown
`count_soft_bounce`	Unknown
`count_spam_complaint`	Unknown
`count_spam_panel`	Unknown
`count_spam_seed`	Unknown
`count_spam_seed_private`	Unknown
`count_spam_seed_virtual`	Unknown
`count_targeted`	Unknown
`count_undetermined_bounce`	Unknown
`count_unique_clicked`	Unknown
`count_unique_confirmed_opened`	Unknown
`count_unique_initial_rendered`	Unknown
`count_unique_rendered`	Unknown
`domain`	Unknown
`end_date`	Unknown
`ip_pool`	Unknown
`metric_type`	Unknown
`sending_domain`	Unknown
`sending_ip`	Unknown
`start_date`	Unknown
`total_delivery_time_first`	Unknown
`total_delivery_time_subsequent`	Unknown
`total_msg_volume`	Unknown
`ts`	Unknown
`watched_domain`	Unknown

engagement_detail

Column	Type	Keys
`_fivetran_id`	String	PK
`count_clicked`	Unknown
`count_raw_clicked`	Unknown
`end_date`	String
`link_name`	Unknown
`start_date`	String

event_rcpt_tag

Column	Type	Keys
`rcpt_tag`	Unknown	PK
`event_id`	Unknown	PKFK

event_sms_remote

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`sms_remote_id`	Unknown

event

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`template_id`	Unknown	FK
`ab_test_id`	Unknown
`ab_test_version`	Unknown
`amp_enabled`	Unknown
`bounce_class`	Unknown
`campaign_id`	Unknown
`click_tracking`	Unknown
`delv_method`	Unknown
`device_token`	Unknown
`end_date`	String
`error_code`	Unknown
`fbtype`	Unknown
`friendly_from`	Unknown
`geo_ip_city`	Unknown
`geo_ip_continent`	Unknown
`geo_ip_country`	Unknown
`geo_ip_latitude`	Unknown
`geo_ip_longitude`	Unknown
`geo_ip_postal_code`	Unknown
`geo_ip_region`	Unknown
`geo_ip_zip`	Unknown
`initial_pixel`	Unknown
`injection_time`	Unknown
`ip_address`	Unknown
`ip_pool`	Unknown
`mailbox_provider`	Unknown
`mailbox_provider_region`	Unknown
`mailfrom`	Unknown
`message_id`	Unknown
`msg_from`	Unknown
`msg_size`	Unknown
`num_retry`	Unknown
`open_tracking`	Unknown
`outbound_tls`	Unknown
`queue_time`	Unknown
`raw_rcpt_to`	Unknown
`raw_reason`	Unknown
`rcpt_hash`	Unknown
`rcpt_subs_country`	Unknown
`rcpt_subs_gender`	Unknown
`rcpt_to`	Unknown
`rcpt_type`	Unknown
`reason`	Unknown
`recipient_domain`	Unknown
`recv_method`	Unknown
`remote_addr`	Unknown
`report_by`	Unknown
`report_to`	Unknown
`routing_domain`	Unknown
`scheduled_time`	Unknown
`sending_domain`	Unknown
`sending_ip`	Unknown
`sms_coding`	Unknown
`sms_dst`	Unknown
`sms_dst_npi`	Unknown
`sms_dst_ton`	Unknown
`sms_segments`	Unknown
`sms_src`	Unknown
`sms_src_npi`	Unknown
`sms_src_ton`	Unknown
`sms_text`	Unknown
`start_date`	String
`subaccount_id`	Unknown
`subject`	Unknown
`target_link_name`	Unknown
`target_link_url`	Unknown
`template_version`	Unknown
`timestamps`	Unknown
`transactional`	Unknown
`transmission_id`	Unknown
`type`	Unknown
`user_agent`	Unknown
`user_agent_parsed_agent_family`	Unknown
`user_agent_parsed_device_brand`	Unknown
`user_agent_parsed_device_family`	Unknown
`user_agent_parsed_is_mobile`	Unknown
`user_agent_parsed_is_prefetched`	Unknown
`user_agent_parsed_is_proxy`	Unknown
`user_agent_parsed_os_family`	Unknown
`user_agent_parsed_os_version`	Unknown
`rcpt_meta_`

tracking_domain

Column	Type	Keys
`_fivetran_id`	String	PK
`defaults`	Unknown
`domain`	Unknown
`port`	Unknown
`secure`	Unknown
`status_cname_status`	Unknown
`status_compliance_status`	Unknown
`status_verified`	Unknown

sending_ip

Column	Type	Keys
`_fivetran_id`	String	PK
`auto_warmup_enabled`	Unknown
`auto_warmup_stage`	Unknown
`customer_provided`	Unknown
`external_ip`	Unknown
`hostname`	Unknown
`ip_pool`	Unknown

account

Column	Type	Keys
`customer_id`	Unknown	PK
`anniversary_date`	Unknown
`company_name`	Unknown
`country_code`	Unknown
`created`	Unknown
`options_blocklist_monitor`	Unknown
`options_inbox_placement`	Unknown
`options_smtp_tracking_default`	Unknown
`service_level`	Unknown
`status`	Unknown
`status_reason_category`	Unknown
`status_updated`	Unknown
`subscription_code`	Unknown
`subscription_name`	Unknown
`subscription_overage`	Unknown
`subscription_period`	Unknown
`subscription_plan_volume`	Unknown
`subscription_plan_volume_per_period`	Unknown
`subscription_recurring_charge`	Unknown
`subscription_self_serve`	Unknown
`subscription_type`	Unknown
`tfa_required`	Unknown
`ui_allow_deliverability_metrics`	Unknown
`ui_hide_terminated_subaccount`	Unknown
`ui_onboarding_view_developer_docs_completed`	Unknown
`updated`	Unknown
`usage_day_end`	Unknown
`usage_day_limit`	Unknown
`usage_day_start`	Unknown
`usage_day_used`	Unknown
`usage_month_end`	Unknown
`usage_month_limit`	Unknown
`usage_month_start`	Unknown
`usage_month_used`	Unknown
`usage_sandbox_limit`	Unknown
`usage_sandbox_used`	Unknown
`usage_timestamp`	Unknown

snippet

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`shared_with_subaccount`	Unknown
`updated_at`	Unknown

bounce_metrics

Column	Type	Keys
`_fivetran_id`	String	PK
`bounce_category_id`	Unknown
`bounce_category_name`	Unknown
`bounce_class_description`	Unknown
`bounce_class_name`	Unknown
`classification_id`	Unknown
`count_bounce`	Unknown
`count_inband_bounce`	Unknown
`count_outofband_bounce`	Unknown
`domain`	Unknown
`end_date`	Unknown
`metric_type`	Unknown
`reason`	Unknown
`start_date`	Unknown

subaccount

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`compliance_status`	Unknown
`deliverability`	Unknown
`ip_pool`	Unknown
`name`	Unknown
`status`	Unknown

template

Column	Type	Keys
`id`	Unknown	PK
`subaccount_id`	Unknown	FK
`description`	Unknown
`has_draft`	Unknown
`has_published`	Unknown
`last_update_time`	Unknown
`last_use`	Unknown
`name`	Unknown
`published`	Unknown
`shared_with_subaccount`	Unknown

deliveries_by_attempt

Column	Type	Keys
`_fivetran_id`	String	PK
`attempt`	Unknown
`count_delivered`	Unknown
`count_raw_clicked`	Unknown
`end_date`	String
`start_date`	String

delay_reason_metrics

Column	Type	Keys
`_fivetran_id`	String	PK
`count_delayed`	Unknown
`count_delayed_first`	Unknown
`domain`	Unknown
`end_date`	Unknown
`metric_type`	Unknown
`reason`	Unknown
`start_date`	Unknown

sending_domain

Column	Type	Keys
`_fivetran_id`	String	PK
`creation_time`	Unknown
`domain`	Unknown
`is_default_bounce_domain`	Unknown
`shared_with_subaccount`	Unknown
`status_abuse_at_status`	Unknown
`status_cname_status`	Unknown
`status_compliance_status`	Unknown
`status_dkim_status`	Unknown
`status_mx_status`	Unknown
`status_ownership_verified`	Unknown
`status_postmaster_at_status`	Unknown
`status_spf_status`	Unknown
`status_verification_mailbox`	Unknown
`status_verification_mailbox_status`	Unknown

recipient_list

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`internal_id`	Unknown
`list_group_id`	Unknown
`name`	Unknown
`total_accepted_recipient`	Unknown

a_b_testing_variant

Column	Type	Keys
`a_b_testing_id`	Unknown	PKFK
`template_id`	Unknown	PKFK
`count_accepted`	Unknown
`count_unique_confirmed_opened`	Unknown
`engagement_rate`	Unknown
`percents`	Unknown

a_b_testing

Column	Type	Keys
`id`	Unknown	PK
`audience_selection`	Unknown
`confidence_level`	Unknown
`created_at`	Unknown
`default_template_count_accepted`	Unknown
`default_template_count_unique_confirmed_opened`	Unknown
`default_template_engagement_rate`	Unknown
`default_template_id`	Unknown
`default_template_percent`	Unknown
`engagement_timeout`	Unknown
`metric`	Unknown
`name`	Unknown
`start_time`	Unknown
`status`	Unknown
`test_mode`	Unknown
`updated_at`	Unknown
`version`	Unknown

ip_pool_ip

Column	Type	Keys
`index`	Unknown	PK
`ip_pool_id`	Unknown	PKFK
`auto_warmup_enabled`	Unknown
`external_ip`	Unknown
`hostname`	Unknown

ip_pool

Column	Type	Keys
`id`	Unknown	PK
`customer_provided`	Unknown
`name`	Unknown