Firstly i need the write query in mailchimp entegration for salesforce contacts and leads, in this case i will get 1 checkbox situation. with formula but in leads i dont have lookup for account rather i have but any times its coming null but i saw one thing, if my leads have account i can see like this. Here to Lead under account object, in this case can i get account field ? with formula or without just i need the get and actually i dont wanna write apex update code because too many records have and i cant use 2000 up OFFSET.
There are fields for converted records on the lead object. Which are not visible on the layout but you can use them in the formula or SOQL.
Here are those fields
SELECT Id, ConvertedAccountId, ConvertedContactId, ConvertedOpportunityId FROM Lead