Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Salesforce Marketing Cloud data to
Salesforce Marketing Cloud Connector Reference
49 metrics85 dimensions
The Salesforce Marketing Cloud connector retrieves data from Salesforce Marketing Cloud on campaign level.
https://connectors.windsor.ai/salesforce_marketing?api_key=[your API key]&date_preset=last_7d&fields=send_id,send_status,sent_date,send_created_date,send_modified_date,send_from_address,send_from_name,send_bcc_email,send_subject,send_email_name,send_limit,send_is_always_on,send_is_multipart,send_preview_url,send_window_close,send_window_open,send_number_delivered,send_unique_opens,send_unique_clicks,send_soft_bounces,send_hard_bounces,send_other_bounces,send_number_errored,send_forwarded_emails,send_duplicates,send_missing_addresses,send_invalid_addresses,send_existing_unsubscribes,send_unsubscribes,send_number_excluded,send_existing_undeliverables,send_number_sent,send_number_targeted,send_partner_key,send_delivery_rate,send_open_rate,send_click_rate,send_bounces,send_bounce_rate,link_id,link_url,link_alias,link_total_clicks,link_unique_clicks,link_shown,link_click_rate,list_id,list_name,list_category,list_classification,list_type,list_name,list_description
The Salesforce Marketing Cloud connector exposes 134 fields (49 metrics, 85 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Salesforce Marketing Cloud Fields
Salesforce Marketing Cloud Campaign fields
The Campaign report of the Salesforce Marketing Cloud connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| campaign_code | TEXT | Send Campaign Code | Campaign Code. |
| campaign_created_date | Campaign Created Date | Campaign created date. | |
| campaign_description | TEXT | Campaign Description | Campaign Description. |
| campaign_id | TEXT | Campaign ID | Campaign ID. |
| campaign_modified_date | DATE | Campaign Modified Date | Campaign modified date. |
| campaign_name | TEXT | Campaign Name | Campaign Name. |
Salesforce Marketing Cloud Journey_Email fields
The Journey_Email report of the Salesforce Marketing Cloud connector includes 22 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| journey_email_activity_id | TEXT | Journey Email Activity ID | ID of the email activity inside the journey. |
| journey_email_activity_key | TEXT | Journey Email Activity Key | External key of the email activity inside the journey. |
| journey_email_activity_name | TEXT | Journey Email Activity Name | Name of the email activity inside the journey. |
| journey_email_bounces | NUMERIC | Journey Email Bounces | Number of bounces of the journey email on this date. |
| journey_email_clicks | NUMERIC | Journey Email Clicks | Number of clicks in the journey email on this date, including repeat clicks by the same subscriber. |
| journey_email_email_id | TEXT | Journey Email Email ID | ID of the email sent by the journey email activity. |
| journey_email_email_name | TEXT | Journey Email Email Name | Name of the email sent by the journey email activity. |
| journey_email_journey_id | TEXT | Journey Email Journey ID | ID of the journey, which stays the same across all of its versions. |
| journey_email_journey_key | TEXT | Journey Email Journey Key | External key of the journey. |
| journey_email_journey_name | TEXT | Journey Email Journey Name | Name of the journey. |
| journey_email_journey_status | TEXT | Journey Email Journey Status | Status of the journey version, such as Published, Paused or Stopped. |
| journey_email_journey_version | TEXT | Journey Email Journey Version | Version number of the journey. |
| journey_email_journey_version_id | TEXT | Journey Email Journey Version ID | ID of the journey version that owns the email activity. |
| journey_email_opens | NUMERIC | Journey Email Opens | Number of opens of the journey email on this date, including repeat opens by the same subscriber. |
| journey_email_sent | NUMERIC | Journey Email Sent | Number of sends of the journey email on this date. A subscriber re- entering the journey is counted for every send. |
| journey_email_subject | TEXT | Journey Email Email Subject | Subject line of the email sent by the journey email activity. |
| journey_email_triggered_send_customer_key | TEXT | Journey Email Triggered Send Customer Key | External key of the triggered send definition behind the journey email activity. |
| journey_email_triggered_send_name | TEXT | Journey Email Triggered Send Name | Name of the triggered send definition behind the journey email activity. |
| journey_email_triggered_send_object_id | TEXT | Journey Email Triggered Send Object ID | System-controlled identifier of the triggered send definition behind the journey email activity. |
| journey_email_unique_clicks | NUMERIC | Journey Email Unique Clicks | Number of subscribers who clicked in the journey email on this date. Summing this across dates or activities overstates unique subscribers. |
| journey_email_unique_opens | NUMERIC | Journey Email Unique Opens | Number of subscribers who opened the journey email on this date. Summing this across dates or activities overstates unique subscribers. |
| journey_email_unsubscribes | NUMERIC | Journey Email Unsubscribes | Number of unsubscribes resulting from the journey email on this date. |
Salesforce Marketing Cloud Link fields
The Link report of the Salesforce Marketing Cloud connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| link_alias | TEXT | Link Alias | Name of link contained in message. |
| link_click_rate | NUMERIC | Link Click Rate | Link click rate based on unique link clicks and the number of times a link was shown. |
| link_id | TEXT | Link ID | Link ID. |
| link_shown | NUMERIC | Link Shown | Number of times a link was shown based on unique opens of an email where the link is included. |
| link_total_clicks | NUMERIC | Link Total Clicks | Indicates total number of clicks on link in message. |
| link_unique_clicks | NUMERIC | Link Unique Clicks | Indicates number of unique clicks on link. |
| link_url | TEXT | Link URL | Indicates URL included in an event or configuration. |
Salesforce Marketing Cloud List fields
The List report of the Salesforce Marketing Cloud connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| list_category | TEXT | List Category | ID of the folder that an item is located in. |
| list_classification | TEXT | List Classification | Specifies the classification for a list. Valid values include: ExactTargetList, PublicationList, SuppressionList. |
| list_description | TEXT | List Description | Describes and provides information regarding the list. |
| list_id | TEXT | List ID | List ID |
| list_name | TEXT | List Name | List Name |
| list_type | TEXT | List Type | Indicates type of specific list. Valid values include Public, Private, Salesforce, GlobalUnsubscribe, and Master. Indicates the type of email to send to the address. Valid values include Text and HTML. |
Salesforce Marketing Cloud List_Subscriber fields
The List_Subscriber report of the Salesforce Marketing Cloud connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| list_subscriber_key | TEXT | List Subscriber Key | Unique identifier of the subscriber, often the email address. |
| list_subscriber_list_id | TEXT | List Subscriber List ID | ID of the list the subscriber resides on. |
| list_subscriber_status | TEXT | List Subscriber Status | Subscription status of the subscriber on the list. Valid values include Active, Bounced, Held, Unsubscribed, and Deleted. |
Salesforce Marketing Cloud Send fields
The Send report of the Salesforce Marketing Cloud connector includes 40 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| send_bcc_email | TEXT | Send Bcc Email | Indicates email addresses to receive blind carbon copy of a message. |
| send_bounce_rate | PERCENT | Email Bounce rate | Emails bounced divided by emails sent. |
| send_bounces | NUMERIC | Email Bounces | Number of times when an email bounced as soft bounce, hard bounce or other bounce. |
| send_click_rate | PERCENT | Emails Click Rate | Unique email clicks divided by emails delivered. |
| send_created_date | DATE | Send Created Date | Date and time of the object's creation. |
| send_date | DATE | Send Send Date | The date and time when a send occurred. Set this value to have a CST (Central Standard Time) value. |
| send_delivery_rate | PERCENT | Emails Delivery Rate | Emails delivered divided by emails sent. |
| send_duplicates | NUMERIC | Email Duplicates | Represent the number of duplicate email addresses associated with a send (exists only when a send occurs to multiple lists). |
| send_email_name | TEXT | Send Email Name | Specifies the name of an email message associated with a send. |
| send_existing_undeliverables | TEXT | Send Existing Undeliverables | Indicates whether bounces occurred on previous send. |
| send_existing_unsubscribes | TEXT | Send Existing Unsubscribes | Indicates whether unsubscriptions occurred on previous send. |
| send_forwarded_emails | NUMERIC | Forwarded Emails | Number of emails forwarded for a send. |
| send_from_address | TEXT | Send From Address | Indicates From address associated with a object. Deprecated for email send definitions and triggered send definitions. |
| send_from_name | TEXT | Send From Name | Specifies the default email message From Name. Deprecated for email send definitions and triggered send definitions. |
| send_hard_bounces | NUMERIC | Email Hard Bounces | Indicates number of hard bounces associated with a send. |
| send_id | TEXT | Send ID | Send ID |
| send_invalid_addresses | NUMERIC | Email Invalid Addresses | Specifies the number of invalid addresses associated with a send. |
| send_is_always_on | BOOLEAN | Send Is Always On | Indicates whether the request can be performed while the system is in maintenance mode. A value of true indicates that the system processes the request. |
| send_is_multipart | BOOLEAN | Send Is Multipart | Indicates whether the email is sent with Multipart/MIME enabled. |
| send_limit | NUMERIC | Send Limit | Indicates limit of messages to send as part of a send definition within a predefined send window. |
| send_missing_addresses | NUMERIC | Email Missing Addresses | Specifies number of missing addresses encountered within a send. |
| send_modified_date | DATE | Send Modified Date | Indicates the last time object information was modified. |
| send_number_delivered | NUMERIC | Emails Delivered | Number of sent emails that did not bounce. |
| send_number_errored | NUMERIC | Email Number Errored | Number of emails not sent as part of a send because an error occurred while trying to build the email. |
| send_number_excluded | NUMERIC | Send Number Excluded | Indicates the number recipients excluded froman email send because of a held, unsubscribed, master unsubscribed, or global unsubscribed status. |
| send_number_sent | NUMERIC | Send Number Sent | Number of emails actually sent as part of an email send. This number reflects all of the sent messages and may include bounced messages. |
| send_number_targeted | NUMERIC | Send Number Targeted | Indicates the number of possible recipients for an email send. This number does not include unsubscribed or excluded subscribers for a given list or data extension. |
| send_open_rate | NUMERIC | Emails Open Rate | Unique email opens divided by emails delivered. |
| send_other_bounces | NUMERIC | Email Other Bounces | Specifies number of Other-type bounces in a send. |
| send_partner_key | TEXT | Send Partner Key | Unique identifier provided by partner for an object. |
| send_preview_url | TEXT | Send Preview Url | Indicates URL used to preview the message associated with a send. |
| send_soft_bounces | NUMERIC | Email Soft Bounces | Indicates number of soft bounces associated with a specific send. |
| send_status | TEXT | Send Status | Defines status of object. Status of an address. |
| send_subject | TEXT | Send Subject | Contains subject area information for a message. |
| send_unique_clicks | NUMERIC | Send Unique Clicks | Indicates number of unique clicks on message. |
| send_unique_opens | NUMERIC | Emails Unique Opens | Indicates number of unique opens resulting from a triggered send. |
| send_unsubscribes | NUMERIC | Send Unsubscribes | Indicates the number of unsubscribe events associated with a send. |
| send_window_close | TEXT | Send Window Close | Defines the end of a send window for a send definition. |
| send_window_open | TEXT | Send Window Open | Defines the beginning of a send window for a send definition. |
| sent_date | DATE | Send Sent Date | Indicates date on which a send took place. (This field might have the value 'null' and it is not clearly documented. 'Send Send Date' can also be used if that fits better the requirements.) |
Salesforce Marketing Cloud Triggered_Send_Definition fields
The Triggered_Send_Definition report of the Salesforce Marketing Cloud connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| triggered_send_bcc_email | TEXT | Triggered Send BCC Email | Indicates email addresses to receive blind carbon copy of a message. |
| triggered_send_created_date | DATE | Triggered Send Created Date | Date and time of the object's creation. |
| triggered_send_customer_key | TEXT | Triggered Send Customer Key | External key of the triggered send definition. Journey Builder email activities use it to reference their triggered send. |
| triggered_send_description | TEXT | Triggered Send Description | Description of the triggered send definition. |
| triggered_send_email_id | TEXT | Triggered Send Email ID | ID of the email sent by the triggered send definition. |
| triggered_send_email_subject | TEXT | Triggered Send Email Subject | Contains subject area information for a message. |
| triggered_send_is_multipart | BOOLEAN | Triggered Send Is Multipart | Indicates whether the email is sent with Multipart/MIME enabled |
| triggered_send_limit | NUMERIC | Triggered Send Limit | Indicates limit of messages to send as part of a send definition within a predefined send window. |
| triggered_send_modified_date | DATE | Triggered Send Modified Date | Indicates the last time object information was modified. |
| triggered_send_name | TEXT | Triggered Send Name | Name of the triggered send definition. |
| triggered_send_object_id | TEXT | Triggered Send Object ID | System-controlled identifier of the triggered send definition. |
| triggered_send_status | TEXT | Triggered Send Status | Defines status of object. Status of an address. |
| triggered_send_window_close | DATE | Triggered Send Window Close | Defines the end of a send window for a send definition. |
| triggered_send_window_open | DATE | Triggered Send Window Open | Defines the beginning of a send window for a send definition. |
Salesforce Marketing Cloud Triggered_Send_Summary fields
The Triggered_Send_Summary report of the Salesforce Marketing Cloud connector includes 17 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| triggered_send_bounces | NUMERIC | Triggered Send Bounces | Indicates number of bounces resulting from a triggered send. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_clicks | NUMERIC | Triggered Send Clicks | Indicates the number of clicks resulting from a triggered send. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_conversions | NUMERIC | Triggered Send Conversions | Indicates the number of conversions results from a triggered send. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_ftaf_emails_sent | NUMERIC | Triggered Send FTAF Emails Sent | Indicates Forward To A Friend emails sent as a result of a triggered send. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_ftaf_opt_ins | NUMERIC | Triggered Send FTAF Opt Ins | Indicates number of subscribers opting in to receiving messages as a result of a Forward To A Friend action from a triggered send. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_ftaf_requests | TEXT | Triggered Send FTAF Requests | Indicates number of Forward To A Friend requests received as part of a triggered send. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_not_sent_due_to_error | NUMERIC | Triggered Send Not Sent Due To Error | Indicates number of triggered send messages not sent due to error. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_not_sent_due_to_opt_out | NUMERIC | Triggered Send Not Sent Due To Opt Out | Indicates number of sends not completed due to a subscriber's decision to opt out of receiving messages. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_not_sent_due_to_undeliverable | NUMERIC | Triggered Send Not Sent Due To Undeliverable | Indicates number of sends not completed due to a subscriber's undeliverable status. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_opens | NUMERIC | Triggered Send Opens | Indicates number of opens from a triggered send. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_opt_outs | NUMERIC | Triggered Send Opt Outs | Indicates number of subscribers who opted out of receiving messages after receiving a triggered send. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_queued | NUMERIC | Triggered Send Queued | Indicates number of messages queued for sending. Current queue count of the triggered send definition, which falls as the queue drains and is not limited to the requested date range. |
| triggered_send_sent | NUMERIC | Triggered Send Sent | Indicates number of messages sent. Indicates the message was sent to a subscriber. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_survey_responses | NUMERIC | Triggered Send Survey Responses | Indicates number of responses to a survey question contained in a triggered send. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_unique_clicks | NUMERIC | Triggered Send Unique Clicks | Indicates number of unique clicks on message. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_unique_conversions | NUMERIC | Triggered Send Unique Conversions | Indicates number of unique conversions resulting from a triggered send. Lifetime total of the triggered send definition, not limited to the requested date range. |
| triggered_send_unique_opens | NUMERIC | Triggered Send Unique Opens | Indicates number of unique opens resulting from a triggered send. Lifetime total of the triggered send definition, not limited to the requested date range. |
Salesforce Marketing Cloud other fields
The Salesforce Marketing Cloud connector has 19 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date of the object's creation. | General |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |