Reporting on New Clients by Postcode
Submitted by Guest on Fri, 08/08/2014 - 12:13
Hi All,
I'm wanting to be able to filter our New Client reporting system (or perhpas there is a seperate report all together) in order to be able to group new clients by postcode.
This will enable me to see what area's our new clients are coming from and hence, what advertising is working best for us and where to further target etc.
All info would be appreciated.
Cheers,
Jess
Re: Reporting on New Clients by Postcode
Jess - the Customer Acquisition Export Report (see http://www.openvpms.org/customisation/customer-acquisition-export-report ) will generate a CSV file that you can open with Excel or Open Office Calc and sort on postcode. You could also add a chart or a set of countif statements that would count the numbers on various postcode sets.
Regards, Tim G