Leads by Source Campaign (in current year)

Dynamics CRM

 

Dynamics CRM is a widely used cloud CRM from Microsoft, focused on Sales, Marketing, and Service (help desk) sectors.

Allows to see the number leads generated by each campaign run in the current year

Query Text

SELECT "campaign_leads"."name", COUNT(*) AS "Leads Count"
  FROM lead
LEFT OUTER JOIN campaign AS "campaign_leads" ON lead."campaignid" = "campaign_leads"."campaignid"
WHERE (date(date(lead."createdon"), 'start of year') = date('now', 'localtime', 'start of year'))
GROUP BY "campaign_leads"."name"
ORDER BY "campaign_leads"."name" DESC
  

Open Query