How to see the results of advertising campaigns in the context of lead statuses.
Requirement: the presence of UTM-tags in Leads.
Go to the tab "Cross table". Select next parameters:
- In the field “Rows” – the “Utm campaign”
- In the field “Columns” – the “Lead Status”
- In the Ratios – the “Count”
Select in the “Ratios” - “Share by count”.
The largest number of Good leads was brought by companies with an Compaign “Empty value” – 6.1% of all leads, or (6 pcs.).
These companies brought the largest number of all leads - 39.4% of all companies (or 39).
The least amount of junk leads (0%) came from compaign 3.
Copy spreadsheet to
ExcelMore about custom ratios
here.
