ZohoAnalytics: Pivot Campaigns vs Contacts
- Joel Lipman
- Zoho
- Hits: 1879
A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts.
Why?
Simply the client wanted a report on customers on each row and then the campaigns as columns.
What we want:
Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3 ---------------- --------------- -------------- -------------- -------------- Joel Google Ads Accepted Invited Sent Me Web Invited Accepted Sent Myself Walk-In Accepted Sent Invited
- Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3
- ---------------- --------------- -------------- -------------- --------------
- Joel Google Ads Accepted Invited Sent
- Me Web Invited Accepted Sent
- Myself Walk-In Accepted Sent Invited
How?
There may be ways of doing this using the GUI and a "Pivot View" report but I always resort to a query when I get confused with the GUI: