Salesforce Marketing Cloud Looker Studio connector by Windsor.ai

salesforce Field Reference logo
+

About the Connector

The connector pulls metrics and dimensions from Salesforce Marketing Cloud. The insights are retrieved at campaign level.

Once user successfully logs into the connector its possible to choose the metrics and dimensions to create a report on.

Prerequisites

The user should have access to their Salesforce Marketing Cloud Subdomain, Client ID and Client Secret in order to use this connector. More information on where to find them here.

Available Metrics and Dimensions

NameTypeDescription
Send Campaign CodeTEXTCampaign Code.
Campaign Created DateDATECampaign created date.
Campaign DescriptionTEXTCampaign Description.
Campaign IDTEXTCampaign ID.
Campaign Modified DateDATECampaign modified date.
Campaign NameTEXTCampaign Name.
DateDATEDate of the object's creation.
TEXTName of link contained in message.
NUMERICLink click rate based on unique link clicks and the number of times a link was shown.
TEXTLink ID.
NUMERICNumber of times a link was shown based on unique opens of an email where the link is included.
NUMERICIndicates total number of clicks on link in message.
NUMERICIndicates number of unique clicks on link.
TEXTIndicates URL included in an event or configuration.
List CategoryTEXTID of the folder that an item is located in.
List ClassificationTEXTSpecifies the classification for a list. Valid values include: ExactTargetList, PublicationList, SuppressionList.;
List DescriptionTEXTDescribes and provides information regarding the list.
List IDTEXTList ID
List NameTEXTList Name
List TypeTEXTIndicates 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.;
Send Bcc EmailTEXTIndicates email addresses to receive blind carbon copy of a message.
Email Bounce rateNUMERICEmails bounced divided by emails sent.
Email BouncesNUMERICNumber of times when an email bounced as soft bounce, hard bounce or other bounce.
Emails Click RateNUMERICUnique email clicks divided by emails delivered.
Send Created DateDATEDate and time of the object's creation.
Emails Delivery RateNUMERICEmails delivered divided by emails sent.
Email DuplicatesNUMERICRepresent the number of duplicate email addresses associated with a send (exists only when a send occurs to multiple lists).
Send Email NameTEXTSpecifies the name of an email message associated with a send.
Send Existing UndeliverablesTEXTIndicates whether bounces occurred on previous send.
Send Existing UnsubscribesTEXTIndicates whether unsubscriptions occurred on previous send.
Forwarded EmailsNUMERICNumber of emails forwarded for a send.
Send From AddressTEXTIndicates From address associated with a object. Deprecated for email send definitions and triggered send definitions.
Send From NameTEXTSpecifies the default email message From Name. Deprecated for email send definitions and triggered send definitions.
Email Hard BouncesNUMERICIndicates number of hard bounces associated with a send.
Send IDTEXTSend ID
Email Invalid AddressesNUMERICSpecifies the number of invalid addresses associated with a send.
Send Is Always OnBOOLEANIndicates 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 MultipartBOOLEANIndicates whether the email is sent with Multipart/MIME enabled.
Send LimitNUMERICIndicates limit of messages to send as part of a send definition within a predefined send window.
Email Missing AddressesNUMERICSpecifies number of missing addresses encountered within a send.
Send Modified DateDATEIndicates the last time object information was modified.
Emails DeliveredNUMERICNumber of sent emails that did not bounce.
Email Number ErroredNUMERICNumber of emails not sent as part of a send because an error occurred while trying to build the email.
Send Number ExcludedNUMERICIndicates the number recipients excluded froman email send because of a held, unsubscribed, master unsubscribed, or global unsubscribed status.
Send Number SentNUMERICNumber 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 TargetedNUMERICIndicates 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.
Emails Open RateNUMERICUnique email opens divided by emails delivered.
Email Other BouncesNUMERICSpecifies number of Other-type bounces in a send.
Send Partner KeyTEXTUnique identifier provided by partner for an object.
Send Preview UrlTEXTIndicates URL used to preview the message associated with a send.
Email Soft BouncesNUMERICIndicates number of soft bounces associated with a specific send.
Send StatusTEXTDefines status of object. Status of an address.
Send SubjectTEXTContains subject area information for a message.
Send Unique ClicksNUMERICIndicates number of unique clicks on message.
Emails Unique OpensNUMERICIndicates number of unique opens resulting from a triggered send.
Send UnsubscribesNUMERICIndicates the number of unsubscribe events associated with a send.
Send Window CloseTEXTDefines the end of a send window for a send definition.
Send Window OpenTEXTDefines the beginning of a send window for a send definition.
Send Sent DateDATEIndicates date on which a send took place.
Triggered Send BCC EmailTEXTIndicates email addresses to receive blind carbon copy of a message.
Triggered Send BouncesNUMERICIndicates number of bounces resulting from a triggered send.
Triggered Send ClicksNUMERICIndicates the number of clicks resulting from a triggered send.
Triggered Send ConversionsNUMERICIndicates the number of conversions results from a triggered send.
Triggered Send Created DateDATEDate and time of the object's creation.
Triggered Send Email SubjectTEXTContains subject area information for a message.
Triggered Send FTAF Emails SentNUMERICIndicates Forward To A Friend emails sent as a result of a triggered send.
Triggered Send FTAF Opt InsNUMERICIndicates number of subscribers opting in to receiving messages as a result of a Forward To A Friend action from a triggered send.
Triggered Send FTAF RequestsTEXTIndicates number of Forward To A Friend requests received as part of a triggered send
Triggered Send Is MultipartBOOLEANIndicates whether the email is sent with Multipart/MIME enabled
Triggered Send LimitNUMERICIndicates limit of messages to send as part of a send definition within a predefined send window.
Triggered Send Modified DateDATEIndicates the last time object information was modified.
Triggered Send Not Sent Due To ErrorNUMERICIndicates number of triggered send messages not sent due to error.
Triggered Send Not Sent Due To Opt OutNUMERICIndicates number of sends not completed due to a subscriber's decision to opt out of receiving messages
Triggered Send Not Sent Due To UndeliverableNUMERICIndicates number of sends not completed due to a subscriber's undeliverable status.
Triggered Send OpensNUMERICIndicates number of opens from a triggered send.
Triggered Send Opt OutsNUMERICIndicates number of subscribers who opted out of receiving messages after receiving a triggered send
Triggered Send QueuedNUMERICIndicates number of messages queued for sending.
Triggered Send SentNUMERICIndicates number of messages sent. Indicates the message was sent to a subscriber.
Triggered Send StatusTEXTDefines status of object. Status of an address.
Triggered Send Survey ResponsesNUMERICIndicates number of responses to a survey question contained in a triggered send.
Triggered Send Unique ClicksNUMERICIndicates number of unique clicks on message.
Triggered Send Unique ConversionsNUMERICIndicates number of unique conversions resulting from a triggered send.
Triggered Send Unique OpensNUMERICIndicates number of unique opens resulting from a triggered send.
Triggered Send Window CloseDATEDefines the end of a send window for a send definition.
Triggered Send Window OpenDATEDefines the beginning of a send window for a send definition.