{"id":620,"date":"2021-01-16T08:31:19","date_gmt":"2021-01-16T07:31:19","guid":{"rendered":"https:\/\/merlinleonard.com\/en\/?p=620"},"modified":"2024-11-21T14:59:04","modified_gmt":"2024-11-21T13:59:04","slug":"marketo-office-hours-data-quality-marketo-2","status":"publish","type":"post","link":"https:\/\/merlinleonard.com\/en\/marketo-office-hours-data-quality-marketo-2\/","title":{"rendered":"Data Quality & Marketo"},"content":{"rendered":"

This session was dedicated to Data Quality & Marketo<\/strong>.\u00a0Sylvain guides us through the main campaigns implemented at Merlin\/Leonard, to fight this eternal plague.<\/p>\n

If you still have doubts about dealing with this hydra, this article should convince you<\/a>.<\/p>\n

Data Quality Marketo at the form level<\/h2>\n

Protection of Marketo forms against generic emails<\/h3>\n

You can decide to only accept emails with a professional domain with a little magic (and scripting) in the Marketo <\/a>forms.<\/p>\n

Protection of forms against bogus phone numbers<\/h3>\n

Similarly, it is possible to prevent a person from entering a phone number such as “0102030405”, or any other suspicious string of characters.<\/p>\n

Competitor management<\/h2>\n

Convenient so that your competitors don’t download all your content, or sign up for your events. They are recognized and managed in a particular way. It’s up to you to define it \ud83d\ude09<\/p>\n

Data Quality Marketo at the campaign level<\/h2>\n

Enriching civility<\/h3>\n

It is possible to automatically deduce the civility of a person, who has just entered a form, from his first name. This works well for 75% of “safe” first names (not like Dominique)<\/p>\n

Likewise, we can deduce for example the decisional character of a person from his “job title”, or his department.<\/p>\n

So much data that we don’t have to ask the visitor or the CRM user.<\/p>\n

Country correction<\/h3>\n

Eternal subject, the bad values in the lists of values. Quite often, the same “bad” values come up. Identify them as soon as they are entered inMarketo and replace them with the right value.<\/p>\n

This type of campaign is valid for any field with “stopped” data for which the acceptable values are in a fixed list.<\/p>\n

Data Quality Marketo at the level of data enrichment<\/h2>\n

Professional \/ personal email management with CaptainVerify<\/h3>\n

This is a multi-step system that we have at Merlin\/Leonard. When a person enters a form, we call CaptainVerify to get information on the validity of the email entered (invalid \/ email trap \/ personal email \/ generic email…) then we historicize this email in a Personal Email field if it falls in this case. The next step below, allows to get the pro email.<\/p>\n

Enrichment with Dropcontact.io<\/h3>\n

For some interesting contacts (hot, or attached to certain campaigns), a call to Dropcontact.io will enrich the contact + account form with a lot of data.<\/p>\n

The idea is once again to avoid asking the visitor for information that can be collected elsewhere.<\/p>\n

Data Quality Marketo at the database level<\/h2>\n

Deleting contacts in Marketo and Salesforce<\/h3>\n

We have a campaign running to detect deletions of people in Salesforce and replicate them in Marketo so we don’t have inconsistencies.<\/p>\n

Deduplication with Cloudingo<\/h3>\n

Cloudingo can detect similar contacts or accounts up to a certain threshold and automate the merging of these contacts or accounts. No more duplicate detection and manual deduplication!<\/p>\n

Import of contacts in Marketo or Salesforce<\/h3>\n

I show you the best practices of list imports in Marketo or Salesforce.<\/p>\n

Marketo Office Hours<\/h2>\n

Every Friday morning, Sylvain opens the microphone to welcome the French Marketo community and answer their questions.<\/p>\n

Want to participate in Marketo Office Hours? Register now below and let’s share best practices with the French Marketo community!<\/p>\n","protected":false},"excerpt":{"rendered":"

This session was dedicated to Data Quality & Marketo.\u00a0Sylvain guides us through the main…<\/p>\n","protected":false},"author":2,"featured_media":3128,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_yoast_wpseo_focuskw":"","_yoast_wpseo_linkdex":0,"_yoast_wpseo_content_score":90,"inline_featured_image":false,"footnotes":""},"categories":[24,25],"tags":[31,44,47],"technology":[],"class_list":["post-620","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-videos","category-virtual-roundtables","tag-data-quality","tag-marketing-strategy","tag-marketing-office-hours"],"acf":{"rsrc_module":null,"meta_duration":50,"meta_difficulty":"dif-medium","post_subtitle":"Marketo Office Hours - 15\/01\/21","modules":[{"acf_fc_layout":"mod_video","mod_video__embedcode":"