Campaign Send Activity



MailChimp is a cloud-based email marketing solution, that allows designing and sending marketing emails.

Campaign Send Activity

Query Text

SELECT C."Title" Company_Name, S."Email", LM."First Name", LM."Last Name", S."Status" "Email Status"
  FROM "SentTo" S
  INNER JOIN "Campaigns" C ON S."CampaignId" = C."Id"
  INNER JOIN "ListMembers" LM ON S."ListMemberId"=LM."Id"
  ORDER BY C."Title"


Open Query