Looker is launching a Marketo action, allowing customers to send customer lead lists to Marketo from within Looker. This action will allow Looker customers send Looker data to Marketo on a one-off or scheduled basis.
Note: Your Looker instance must be on Looker 5.6.
To enable the action in Looker, go to your Admin panel and the Actions Tab under the Platform header [your-instance.looker.com/admin/actions]. (Admin > Platform > Actions)
Select “Enable” on the Action you would like to enable.
In your Marketo console Admin > LaunchPoint [http://developers.marketo.com/rest-api/authentication/]:
Enable the Marketo API
Note the Server Host URL, Client Id, and Client Secret.
IMPORTANT: You must remove /rest
from the end of the address. Only enter the part of the endpoint that looks like https://123-ABC-456.mktorest.com
.
Copy your Marketo authentication information and paste into the Looker Actions Page.
marketo:<marketo field name>
and should use the REST API name that Marketo gives the field. IMPORTANT: You must use the REST API name of the field, not the display name or SOAP API name.
Great, now you’ve setup your API keys and LookML so that Looker can communicate with Marketo!
In Looker, view a Look, explore data or view a dashboard to see the data you want to send to Marketo.
Then start to send the data now or schedule the data to be sent later or periodically.
In the Send or Schedule window’s Destination field, select “Marketo”.
In the CampaignId field, specify the Marketo Campaign Id for the lead list file.
Click Send.
Your data will be in your Marketo!
Hey there,
Quick question, if the person is removed from the Looker report, is the person removed from the list in Marketo? Or will it just not sync anymore?
Thx a lot
Hey @Marceau_Bouleng this data action is for adding records to Marketo, so the absence of a particular name won’t register on the Marketo side. If you have any additional questions, please contact us at our Help Center.
2 posts were split to a new topic: Marketo action update existing record?
This action is not currently supported by Looker. Looker is unable to respond to bugs or feature requests for this action. All actions are open source, so users may attempt to remedy any issues and implement a custom action."