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!