Marketo: Difference between revisions
Jkuehlthau (talk | contribs) (→Origin) |
Jkuehlthau (talk | contribs) No edit summary |
||
(4 intermediate revisions by the same user not shown) | |||
Line 13: | Line 13: | ||
SELECT * FROM Leads WHERE Sugarcrm_id = 'b7e70c80-20cd-9209-24bf-57ae4b05b711' | SELECT * FROM Leads WHERE Sugarcrm_id = 'b7e70c80-20cd-9209-24bf-57ae4b05b711' | ||
</source> | </source> | ||
The same is true for using some fields in ORDER BY. This is because the Marketo API doesn't actually support some fields in these operations so the CData connector downloads all of the data and does the WHERE or ORDER BY locally, thus taking a very long time. See: http://cdn.cdata.com/help/DKE/ado/RSBMarketo_p_SupportEnhancedSQL.htm | |||
=Mapping= | |||
==Multi-select Dropdown== | |||
The format seems to be a semicolon seperated list: "Cloud Storage;Backup / Disaster Recovery;Colocation". | |||
=Importing Unsubscribed Contacts= | |||
If you want to import unsubscribed Contacts, then you have to import the contact and then import an opt-out list from Excel: | |||
#Import the Unsubscribed records from Origin into Hubspot. | |||
#Export a list of unsubscribed email addresses from Origin to Excel. | |||
#Import the Excel file into HubSpot. https://knowledge.hubspot.com/articles/kcs_article/contacts/import-an-opt-out-list | |||
Contacts can be re-opted in in a number of ways: https://knowledge.hubspot.com/articles/kcs_article/contacts/remove-an-opt-out-of-email-status |
Latest revision as of 20:16, 2 August 2019
Connector Setup
I used this guide, https://developers.marketo.com/blog/quick-start-guide-for-marketo-rest-api/, to setup an API Role, User and Service and then get the Client ID and Client Secret for that Service.
Origin
The CData website has a help page for the Marketo Connector: http://cdn.cdata.com/help/DKE/ado/default.htm. The SQL examples are helpful.
I've found that I can use some fields in a where clause quickly and others are extremely slow. Id runs in a few seconds.
SELECT * FROM Leads WHERE Id = '104'
Sugarcrm_id runs in 283 seconds.
SELECT * FROM Leads WHERE Sugarcrm_id = 'b7e70c80-20cd-9209-24bf-57ae4b05b711'
The same is true for using some fields in ORDER BY. This is because the Marketo API doesn't actually support some fields in these operations so the CData connector downloads all of the data and does the WHERE or ORDER BY locally, thus taking a very long time. See: http://cdn.cdata.com/help/DKE/ado/RSBMarketo_p_SupportEnhancedSQL.htm
Mapping
Multi-select Dropdown
The format seems to be a semicolon seperated list: "Cloud Storage;Backup / Disaster Recovery;Colocation".
Importing Unsubscribed Contacts
If you want to import unsubscribed Contacts, then you have to import the contact and then import an opt-out list from Excel:
- Import the Unsubscribed records from Origin into Hubspot.
- Export a list of unsubscribed email addresses from Origin to Excel.
- Import the Excel file into HubSpot. https://knowledge.hubspot.com/articles/kcs_article/contacts/import-an-opt-out-list
Contacts can be re-opted in in a number of ways: https://knowledge.hubspot.com/articles/kcs_article/contacts/remove-an-opt-out-of-email-status