Looker Actions - Marketo
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.
Enable the Marketo Action
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
/restfrom the end of the address. Only enter the part of the endpoint that looks like
Copy your Marketo authentication information and paste into the Looker Actions Page.
Tell Looker how columns in Looker map to fields in Marketo
- For every dimension/measure that you want Looker to be able to send to Marketo, you must map it in the LookML to a Marketo field using tags.
- The tag should follow the form
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.
- You can read how to find Marketo API field names here.
- You can add as many tags as you’d like to a Looker field, as long as it has the Marketo field.
Send data to Marketo
Great, now you’ve setup your API keys and LookML so that Looker can communicate with Marketo!
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.
Your data will be in your Marketo!