This article will help you dissect and analyze the data contained in your prospect report using pivot tables.
Once you have downloaded your Prospect Report from the admin dashboard, you can then start organising the data to get a better sense of the trends. You can do this using the pivot table function in Excel.
For example, you could create a pivot table to see which campaigns have been most effective in driving traffic to your Feed. With this information, you can get a clear understanding of which communications have caught your target audience's attention, as well as which might need attention. Here is a video showing you how to create a pivot table.
If you have any questions about this please get in touch via customer support chat or by emailing support@theambassadorplatform.com.