Connect Salesforce Marketing Cloud to Looker Studio in Minutes
Directly connect Salesforce Marketing Cloud to Looker Studio in an easy-to-use format
About the Salesforce Marketing Cloud Google Data Studio Connector
The Salesforce Marketing Cloud Google Data Studio Connector pulls Metrics and Dimensions for Salesforce Marketing Cloud. The Insights are retrieved at the campaign level.
Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.
Prerequisites
To set up the connector, the user should have:
- An Salesforce Marketing Cloud account (Visit our privacy policy and terms of use)
- Google account for Salesforce Marketing Cloud to Looker Studio integration.
- A Windsor account. Start your free trial now.
How to connect Salesforce Marketing Cloud to Looker Studio?
Do you plan to connect and visualize your Salesforce Marketing Cloud in Google Data Studio? Follow the Tutorial Below:
You need to select Salesforce Marketing Cloud as a Data Source and grant access to Windsor.ai. Select the fields on the right to later use in your data source. For example, you can include metrics such as Cost per Click, Cost per Action or Total Spend. Go to “Select Destination” and choose Google Data Studio. Once done, select “connect” and authorize access to your data source.
Salesforce Marketing Cloud metrics & dimensions available for streaming into Looker Studio
name type description Send Campaign Code TEXT Campaign Code. Campaign Created Date DATE Campaign created date. Campaign Description TEXT Campaign Description. Campaign ID TEXT Campaign ID. Campaign Modified Date DATE Campaign modified date. Campaign Name TEXT Campaign Name. Date DATE Date of the object's creation. Link Alias TEXT Name of link contained in message. Link Click Rate NUMERIC Link click rate based on unique link clicks and the number of times a link was shown. Link ID TEXT Link ID. Link Shown NUMERIC Number of times a link was shown based on unique opens of an email where the link is included. Link Total Clicks NUMERIC Indicates total number of clicks on link in message. Link Unique Clicks NUMERIC Indicates number of unique clicks on link. Link URL TEXT Indicates URL included in an event or configuration. List Category TEXT ID of the folder that an item is located in. List Classification TEXT Specifies the classification for a list. Valid values include: ExactTargetList, PublicationList, SuppressionList.; List Description TEXT Describes and provides information regarding the list. List ID TEXT List ID List Name TEXT List Name List Type TEXT 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.; Send Bcc Email TEXT Indicates email addresses to receive blind carbon copy of a message. Email Bounce rate PERCENT Emails bounced divided by emails sent. Email Bounces NUMERIC Number of times when an email bounced as soft bounce, hard bounce or other bounce. Emails Click Rate PERCENT Unique email clicks divided by emails delivered. Send Created Date DATE Date and time of the object's creation. Emails Delivery Rate PERCENT Emails delivered divided by emails sent. Email Duplicates NUMERIC Represent the number of duplicate email addresses associated with a send (exists only when a send occurs to multiple lists). Send Email Name TEXT Specifies the name of an email message associated with a send. Send Existing Undeliverables TEXT Indicates whether bounces occurred on previous send. Send Existing Unsubscribes TEXT Indicates whether unsubscriptions occurred on previous send. Forwarded Emails NUMERIC Number of emails forwarded for a send. Send From Address TEXT Indicates From address associated with a object. Deprecated for email send definitions and triggered send definitions. Send From Name TEXT Specifies the default email message From Name. Deprecated for email send definitions and triggered send definitions. Email Hard Bounces NUMERIC Indicates number of hard bounces associated with a send. Send ID TEXT Send ID Email Invalid Addresses NUMERIC Specifies the number of invalid addresses associated with a send. Send Is Always On BOOLEAN 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 Indicates whether the email is sent with Multipart/MIME enabled. Send Limit NUMERIC Indicates limit of messages to send as part of a send definition within a predefined send window. Email Missing Addresses NUMERIC Specifies number of missing addresses encountered within a send. Send Modified Date DATE Indicates the last time object information was modified. Emails Delivered NUMERIC Number of sent emails that did not bounce. Email Number Errored NUMERIC Number of emails not sent as part of a send because an error occurred while trying to build the email. Send Number Excluded NUMERIC Indicates the number recipients excluded froman email send because of a held, unsubscribed, master unsubscribed, or global unsubscribed status. Send Number Sent NUMERIC 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 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. Emails Open Rate NUMERIC Unique email opens divided by emails delivered. Email Other Bounces NUMERIC Specifies number of Other-type bounces in a send. Send Partner Key TEXT Unique identifier provided by partner for an object. Send Preview Url TEXT Indicates URL used to preview the message associated with a send. Email Soft Bounces NUMERIC Indicates number of soft bounces associated with a specific send. Send Status TEXT Defines status of object. Status of an address. Send Subject TEXT Contains subject area information for a message. Send Unique Clicks NUMERIC Indicates number of unique clicks on message. Emails Unique Opens NUMERIC Indicates number of unique opens resulting from a triggered send. Send Unsubscribes NUMERIC Indicates the number of unsubscribe events associated with a send. Send Window Close TEXT Defines the end of a send window for a send definition. Send Window Open TEXT Defines the beginning of a send window for a send definition. Send Sent Date DATE Indicates date on which a send took place. Triggered Send BCC Email TEXT Indicates email addresses to receive blind carbon copy of a message. Triggered Send Bounces NUMERIC Indicates number of bounces resulting from a triggered send. Triggered Send Clicks NUMERIC Indicates the number of clicks resulting from a triggered send. Triggered Send Conversions NUMERIC Indicates the number of conversions results from a triggered send. Triggered Send Created Date DATE Date and time of the object's creation. Triggered Send Email Subject TEXT Contains subject area information for a message. Triggered Send FTAF Emails Sent NUMERIC Indicates Forward To A Friend emails sent as a result of a triggered send. Triggered Send FTAF Opt Ins NUMERIC 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 FTAF Requests TEXT Indicates number of Forward To A Friend requests received as part of a triggered send Triggered Send Is Multipart BOOLEAN Indicates whether the email is sent with Multipart/MIME enabled Triggered Send Limit NUMERIC Indicates limit of messages to send as part of a send definition within a predefined send window. Triggered Send Modified Date DATE Indicates the last time object information was modified. Triggered Send Not Sent Due To Error NUMERIC Indicates number of triggered send messages not sent due to error. Triggered Send Not Sent Due To Opt Out NUMERIC Indicates number of sends not completed due to a subscriber's decision to opt out of receiving messages Triggered Send Not Sent Due To Undeliverable NUMERIC Indicates number of sends not completed due to a subscriber's undeliverable status. Triggered Send Opens NUMERIC Indicates number of opens from a triggered send. Triggered Send Opt Outs NUMERIC Indicates number of subscribers who opted out of receiving messages after receiving a triggered send Triggered Send Queued NUMERIC Indicates number of messages queued for sending. Triggered Send Sent NUMERIC Indicates number of messages sent. Indicates the message was sent to a subscriber. Triggered Send Status TEXT Defines status of object. Status of an address. Triggered Send Survey Responses NUMERIC Indicates number of responses to a survey question contained in a triggered send. Triggered Send Unique Clicks NUMERIC Indicates number of unique clicks on message. Triggered Send Unique Conversions NUMERIC Indicates number of unique conversions resulting from a triggered send. Triggered Send Unique Opens NUMERIC Indicates number of unique opens resulting from a triggered send. Triggered Send Window Close DATE Defines the end of a send window for a send definition. Triggered Send Window Open DATE Defines the beginning of a send window for a send definition.
Easily connect Salesforce Marketing Cloud to Looker Studio
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.