Hello,
Pertaining to Mailchimp integration.
Once a MC Campaign has been sent, we are able to see the results in CRM. From the results, we can create a New Group from contacts who Clicked the Mailchimp Campaign.
When we create that new Group, here are the fields displayed in the list:
Here is the SQL
SELECT DISTINCT Comp_CompanyID, comp_name, addr_city,
comp_phonefullnumber, comp_emailaddress, comp_website, comp_secterr,
UPPER(comp_name) as UpperCase_comp_name FROM vSearchListCompany
WHERE Comp_CompanyId in(select DISTINCT McOp_CompanyId
from MailChimpOpens where McOp_CampaignId = 829)
AND Comp_CompanyID IS NOT NULL ORDER BY UPPER(comp_name)
We would like to add fields to the list. Is this possible? How?
Thank you!