Windsor brings all your Salesforce Marketing Cloud data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure MS SQL
Salesforce Marketing Cloud Field Reference
Sample
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
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| campaign_code | TEXT | Send Campaign Code | Campaign Code. | Campaign |
| campaign_created_date | DATE | Campaign Created Date | Campaign created date. | Campaign |
| campaign_description | TEXT | Campaign Description | Campaign Description. | Campaign |
| campaign_id | TEXT | Campaign ID | Campaign ID. | Campaign |
| campaign_modified_date | DATE | Campaign Modified Date | Campaign modified date. | Campaign |
| campaign_name | TEXT | Campaign Name | Campaign Name. | Campaign |
| 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 | |
| link_alias | TEXT | Link Alias | Name of link contained in message. | Link |
| 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 |
| link_id | TEXT | Link ID | Link ID. | Link |
| 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 |
| link_total_clicks | NUMERIC | Link Total Clicks | Indicates total number of clicks on link in message. | Link |
| link_unique_clicks | NUMERIC | Link Unique Clicks | Indicates number of unique clicks on link. | Link |
| link_url | TEXT | Link URL | Indicates URL included in an event or configuration. | Link |
| list_category | TEXT | List Category | ID of the folder that an item is located in. | List |
| list_classification | TEXT | List Classification | Specifies the classification for a list. Valid values include: ExactTargetList, PublicationList, SuppressionList.; | List |
| list_description | TEXT | List Description | Describes and provides information regarding the list. | List |
| list_id | TEXT | List ID | List ID | List |
| list_name | TEXT | List Name | List Name | List |
| 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.; | List |
| month | TEXT | Month | Number of the month | |
| send_bcc_email | TEXT | Send Bcc Email | Indicates email addresses to receive blind carbon copy of a message. | Send |
| send_bounce_rate | PERCENT | Email Bounce rate | Emails bounced divided by emails sent. | Send |
| send_bounces | NUMERIC | Email Bounces | Number of times when an email bounced as soft bounce, hard bounce or other bounce. | Send |
| send_click_rate | PERCENT | Emails Click Rate | Unique email clicks divided by emails delivered. | Send |
| send_created_date | DATE | Send Created Date | Date and time of the object's creation. | Send |
| send_delivery_rate | PERCENT | Emails Delivery Rate | Emails delivered divided by emails sent. | Send |
| 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 |
| send_email_name | TEXT | Send Email Name | Specifies the name of an email message associated with a send. | Send |
| send_existing_undeliverables | TEXT | Send Existing Undeliverables | Indicates whether bounces occurred on previous send. | Send |
| send_existing_unsubscribes | TEXT | Send Existing Unsubscribes | Indicates whether unsubscriptions occurred on previous send. | Send |
| send_forwarded_emails | NUMERIC | Forwarded Emails | Number of emails forwarded for a send. | 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 |
| send_from_name | TEXT | Send From Name | Specifies the default email message From Name. Deprecated for email send definitions and triggered send definitions. | Send |
| send_hard_bounces | NUMERIC | Email Hard Bounces | Indicates number of hard bounces associated with a send. | Send |
| send_id | TEXT | Send ID | Send ID | Send |
| send_invalid_addresses | NUMERIC | Email Invalid Addresses | Specifies the number of invalid addresses associated with a send. | 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 |
| send_is_multipart | BOOLEAN | Send Is Multipart | Indicates whether the email is sent with Multipart/MIME enabled. | Send |
| send_limit | NUMERIC | Send Limit | Indicates limit of messages to send as part of a send definition within a predefined send window. | Send |
| send_missing_addresses | NUMERIC | Email Missing Addresses | Specifies number of missing addresses encountered within a send. | Send |
| send_modified_date | DATE | Send Modified Date | Indicates the last time object information was modified. | Send |
| send_number_delivered | NUMERIC | Emails Delivered | Number of sent emails that did not bounce. | Send |
| 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 |
| 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 |
| 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 |
| 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 |
| send_open_rate | NUMERIC | Emails Open Rate | Unique email opens divided by emails delivered. | Send |
| send_other_bounces | NUMERIC | Email Other Bounces | Specifies number of Other-type bounces in a send. | Send |
| send_partner_key | TEXT | Send Partner Key | Unique identifier provided by partner for an object. | Send |
| send_preview_url | TEXT | Send Preview Url | Indicates URL used to preview the message associated with a send. | Send |
| send_soft_bounces | NUMERIC | Email Soft Bounces | Indicates number of soft bounces associated with a specific send. | Send |
| send_status | TEXT | Send Status | Defines status of object. Status of an address. | Send |
| send_subject | TEXT | Send Subject | Contains subject area information for a message. | Send |
| send_unique_clicks | NUMERIC | Send Unique Clicks | Indicates number of unique clicks on message. | Send |
| send_unique_opens | NUMERIC | Emails Unique Opens | Indicates number of unique opens resulting from a triggered send. | Send |
| send_unsubscribes | NUMERIC | Send Unsubscribes | Indicates the number of unsubscribe events associated with a send. | Send |
| send_window_close | TEXT | Send Window Close | Defines the end of a send window for a send definition. | Send |
| send_window_open | TEXT | Send Window Open | Defines the beginning of a send window for a send definition. | Send |
| sent_date | DATE | Send Sent Date | Indicates date on which a send took place. | Send |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| triggered_send_bcc_email | TEXT | Triggered Send BCC Email | Indicates email addresses to receive blind carbon copy of a message. | Triggered_Send_Definition |
| triggered_send_bounces | NUMERIC | Triggered Send Bounces | Indicates number of bounces resulting from a triggered send. | Triggered_Send_Summary |
| triggered_send_clicks | NUMERIC | Triggered Send Clicks | Indicates the number of clicks resulting from a triggered send. | Triggered_Send_Summary |
| triggered_send_conversions | NUMERIC | Triggered Send Conversions | Indicates the number of conversions results from a triggered send. | Triggered_Send_Summary |
| triggered_send_created_date | DATE | Triggered Send Created Date | Date and time of the object's creation. | Triggered_Send_Definition |
| triggered_send_email_subject | TEXT | Triggered Send Email Subject | Contains subject area information for a message. | Triggered_Send_Definition |
| 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. | Triggered_Send_Summary |
| 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. | Triggered_Send_Summary |
| triggered_send_ftaf_requests | TEXT | Triggered Send FTAF Requests | Indicates number of Forward To A Friend requests received as part of a triggered send | Triggered_Send_Summary |
| triggered_send_is_multipart | BOOLEAN | Triggered Send Is Multipart | Indicates whether the email is sent with Multipart/MIME enabled | Triggered_Send_Definition |
| 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_Definition |
| triggered_send_modified_date | DATE | Triggered Send Modified Date | Indicates the last time object information was modified. | Triggered_Send_Definition |
| 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. | Triggered_Send_Summary |
| 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 | Triggered_Send_Summary |
| 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. | Triggered_Send_Summary |
| triggered_send_opens | NUMERIC | Triggered Send Opens | Indicates number of opens from a triggered send. | Triggered_Send_Summary |
| triggered_send_opt_outs | NUMERIC | Triggered Send Opt Outs | Indicates number of subscribers who opted out of receiving messages after receiving a triggered send | Triggered_Send_Summary |
| triggered_send_queued | NUMERIC | Triggered Send Queued | Indicates number of messages queued for sending. | Triggered_Send_Summary |
| triggered_send_sent | NUMERIC | Triggered Send Sent | Indicates number of messages sent. Indicates the message was sent to a subscriber. | Triggered_Send_Summary |
| triggered_send_status | TEXT | Triggered Send Status | Defines status of object. Status of an address. | Triggered_Send_Definition |
| triggered_send_survey_responses | NUMERIC | Triggered Send Survey Responses | Indicates number of responses to a survey question contained in a triggered send. | Triggered_Send_Summary |
| triggered_send_unique_clicks | NUMERIC | Triggered Send Unique Clicks | Indicates number of unique clicks on message. | Triggered_Send_Summary |
| triggered_send_unique_conversions | NUMERIC | Triggered Send Unique Conversions | Indicates number of unique conversions resulting from a triggered send. | Triggered_Send_Summary |
| triggered_send_unique_opens | NUMERIC | Triggered Send Unique Opens | Indicates number of unique opens resulting from a triggered send. | Triggered_Send_Summary |
| triggered_send_window_close | DATE | Triggered Send Window Close | Defines the end of a send window for a send definition. | Triggered_Send_Definition |
| triggered_send_window_open | DATE | Triggered Send Window Open | Defines the beginning of a send window for a send definition. | Triggered_Send_Definition |
| 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_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 |