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 |
| date | DATE | Date | Date of the object's creation. | General |
| 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 |
| 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 |
| 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 |
| today | DATE | Today | Today's date |