Hi, Wonder if I could get a bit of help, I want to create a new column within a query table and am going round in circles, I want a new column to be that of "Acquisition Type" and if a Lead Source is Facebook it goes down as Social, if Adwords its PPC.
This is is the original query I have, where can I go from here please - Im stuck!
SELECT
de."Lead Source" AS "Lead Source",
COUNT(1) AS TOTAL
FROM "Deals (Zoho CRM)" AS de
WHERE de."Created Time" BETWEEN '2020-01-01 00:00:00' AND '2030-01-01 00:00:00'
GROUP BY de."Lead Source"