MadKudu fields: MQL and PQL

  • Updated on Nov 12, 2024
  • Published on Oct 10, 2024
  • 3 minute(s) read
Prev Next

in Salesforce

JSON to use with Salesforce API 

{
"Lead": [
{
"fullName": "Lead.mk_marketing_lead_engagement_segment__c",
"label": "MK Marketing Lead Engagement Segment",
"externalId": "false",
"required": "false",
"type": "Text",
"length": 255
},
{
"fullName": "Lead.mk_marketing_lead_engagement_score__c",
"label": "MK Marketing Lead Engagement Score",
"externalId": "false",
"required": "false",
"type": "Number",
"precision": 18,
"scale": 0
},
{
"fullName": "Lead.mk_marketing_lead_engagement_signals__c",
"label": "MK Marketing Lead Engagement Signals",
"type": "LongTextArea",
"length": 1024,
"visibleLines": 10
},
{
"fullName": "Lead.mk_marketing_lead_engagement__c",
"label": "MK Marketing Lead Engagement",
"required": "False",
"type": "Text",
"formula": "IMAGE("https://cdn.madkudu.com/images/fire.png","",0,0)+CASE(mk_marketing_lead_engagement_segment__c ,
'very high', IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20) + IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20) + IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20),
'high', IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20) + IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20),
'medium', IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20),
IMAGE("https://cdn.madkudu.com/images/snowflake.png", "Snowflake", 20, 20))"
},
{
"fullName": "Lead.mk_marketing_lead_grade_segment__c",
"label": "MK Marketing Lead Grade Segment",
"externalId": "false",
"required": "false",
"type": "Text",
"length": 255
},
{
"fullName": "Lead.mk_marketing_lead_grade_score__c",
"label": "MK Marketing Lead Grade Score",
"externalId": "false",
"required": "false",
"type": "Number",
"precision": 18,
"scale": 0
},
{
"fullName": "Lead.mk_marketing_lead_grade__c",
"label": "MK Marketing Lead Grade",
"required": "False",
"type": "Text",
"formula": "IMAGE("https://cdn.madkudu.com/images/star.png","",0,0)+CASE(mk_marketing_lead_grade_segment__c, 
'A', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_a_s.png", "A", 20, 20), 
'B', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_b_s.png", "B", 20, 20), 
'C', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_c_s.png", "C", 20, 20), 
'D', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_d_s.png", "D", 20, 20), 
IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_e_s.png", "E", 20, 20))"
},
{
"fullName": "Lead.mk_product_user_engagement_segment__c",
"label": "MK Product User Engagement Segment",
"externalId": "false",
"required": "false",
"type": "Text",
"length": 255
},
{
"fullName": "Lead.mk_product_user_engagement_score__c",
"label": "MK Product User Engagement Score",
"externalId": "false",
"required": "false",
"type": "Number",
"precision": 18,
"scale": 0
},
{
"fullName": "Lead.mk_product_user_engagement_signals__c",
"label": "MK Product User Engagement Signals",
"type": "LongTextArea",
"length": 1024,
"visibleLines": 10
},
{
"fullName": "Lead.mk_product_user_engagement__c",
"label": "MK Product User Engagement",
"required": "False",
"type": "Text",
"formula": "IMAGE("https://cdn.madkudu.com/images/fire.png","",0,0)+CASE(mk_product_user_engagement_segment__c ,
'very high', IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20) + IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20) + IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20),
'high', IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20) + IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20),
'medium', IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20),
IMAGE("https://cdn.madkudu.com/images/snowflake.png", "Snowflake", 20, 20))"
},
{
"fullName": "Lead.mk_product_user_grade_segment__c",
"label": "MK Product User Grade Segment",
"externalId": "false",
"required": "false",
"type": "Text",
"length": 255
},
{
"fullName": "Lead.mk_product_user_grade_score__c",
"label": "MK Product User Grade Score",
"externalId": "false",
"required": "false",
"type": "Number",
"precision": 18,
"scale": 0
},
{
"fullName": "Lead.mk_product_user_grade__c",
"label": "MK Product User Grade",
"required": "False",
"type": "Text",
"formula": "IMAGE("https://cdn.madkudu.com/images/star.png","",0,0)+CASE(mk_product_user_grade_segment__c, 
'A', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_a_s.png", "A", 20, 20), 
'B', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_b_s.png", "B", 20, 20), 
'C', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_c_s.png", "C", 20, 20), 
'D', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_d_s.png", "D", 20, 20), 
IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_e_s.png", "E", 20, 20))"
}
],
"Contact": [
{
"fullName": "Contact.mk_marketing_lead_engagement_segment__c",
"label": "MK Marketing Lead Engagement Segment",
"externalId": "false",
"required": "false",
"type": "Text",
"length": 255
},
{
"fullName": "Contact.mk_marketing_lead_engagement_score__c",
"label": "MK Marketing Lead Engagement Score",
"externalId": "false",
"required": "false",
"type": "Number",
"precision": 18,
"scale": 0
},
{
"fullName": "Contact.mk_marketing_lead_engagement_signals__c",
"label": "MK Marketing Lead Engagement Signals",
"type": "LongTextArea",
"length": 1024,
"visibleLines": 10
},
{
"fullName": "Contact.mk_marketing_lead_engagement__c",
"label": "MK Marketing Lead Engagement",
"required": "False",
"type": "Text",
"formula": "IMAGE("https://cdn.madkudu.com/images/fire.png","",0,0)+CASE(mk_marketing_lead_engagement_segment__c ,
'very high', IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20) + IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20) + IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20),
'high', IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20) + IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20),
'medium', IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20),
IMAGE("https://cdn.madkudu.com/images/snowflake.png", "Snowflake", 20, 20))"
},
{
"fullName": "Contact.mk_marketing_lead_grade_segment__c",
"label": "MK Marketing Lead Grade Segment",
"externalId": "false",
"required": "false",
"type": "Text",
"length": 255
},
{
"fullName": "Contact.mk_marketing_lead_grade_score__c",
"label": "MK Marketing Lead Grade Score",
"externalId": "false",
"required": "false",
"type": "Number",
"precision": 18,
"scale": 0
},
{
"fullName": "Contact.mk_marketing_lead_grade__c",
"label": "MK Marketing Lead Grade",
"required": "False",
"type": "Text",
"formula": "IMAGE("https://cdn.madkudu.com/images/star.png","",0,0)+CASE(mk_marketing_lead_grade_segment__c, 
'A', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_a_s.png", "A", 20, 20), 
'B', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_b_s.png", "B", 20, 20), 
'C', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_c_s.png", "C", 20, 20), 
'D', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_d_s.png", "D", 20, 20), 
IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_e_s.png", "E", 20, 20))"
},
{
"fullName": "Contact.mk_product_user_engagement_segment__c",
"label": "MK Product User Engagement Segment",
"externalId": "false",
"required": "false",
"type": "Text",
"length": 255
},
{
"fullName": "Contact.mk_product_user_engagement_score__c",
"label": "MK Product User Engagement Score",
"externalId": "false",
"required": "false",
"type": "Number",
"precision": 18,
"scale": 0
},
{
"fullName": "Contact.mk_product_user_engagement_signals__c",
"label": "MK Product User Engagement Signals",
"type": "LongTextArea",
"length": 1024,
"visibleLines": 10
},
{
"fullName": "Contact.mk_product_user_engagement__c",
"label": "MK Product User Engagement",
"required": "False",
"type": "Text",
"formula": "IMAGE("https://cdn.madkudu.com/images/fire.png","",0,0)+CASE(mk_product_user_engagement_segment__c ,
'very high', IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20) + IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20) + IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20),
'high', IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20) + IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20),
'medium', IMAGE("https://cdn.madkudu.com/images/fire.png", "Fire", 20, 20),
IMAGE("https://cdn.madkudu.com/images/snowflake.png", "Snowflake", 20, 20))"
},
{
"fullName": "Contact.mk_product_user_grade_segment__c",
"label": "MK Product User Grade Segment",
"externalId": "false",
"required": "false",
"type": "Text",
"length": 255
},
{
"fullName": "Contact.mk_product_user_grade_score__c",
"label": "MK Product User Grade Score",
"externalId": "false",
"required": "false",
"type": "Number",
"precision": 18,
"scale": 0
},
{
"fullName": "Contact.mk_product_user_grade__c",
"label": "MK Product User Grade",
"required": "False",
"type": "Text",
"formula": "IMAGE("https://cdn.madkudu.com/images/star.png","",0,0)+CASE(mk_product_user_grade_segment__c, 
'A', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_a_s.png", "A", 20, 20), 
'B', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_b_s.png", "B", 20, 20), 
'C', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_c_s.png", "C", 20, 20), 
'D', IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_d_s.png", "D", 20, 20), 
IMAGE("https://cdn.madkudu.com/images/lead_grades/grade_e_s.png", "E", 20, 20))"
}
]
}


Related articles