AnsweredAssumed Answered

Marking Anonymous Leads with Additional Information

Question asked by f0b526d952f661e4f12d4f7397e38fcfa0bc7b8f on Feb 24, 2016
Latest reply on Feb 24, 2016 by Josh Hill

I'm using the Web Page Activity Report to send daily emails to my Executive team showing all of the anonymous lead activity on our website. Currently, I have the report sorted by page views (descending) so that the most active leads are at the top. I only show the top 15 by email and the rest are sent in an Excel attachment.


With this report, I'm trying to find a way to make this easy for the executives who want to sort by Domestic v. International, but there's no field for that. So far all I've come up with is:


1) Sort by country so that US falls to the bottom of the list (but then I lose fast visibility of the top 15 most active leads on my website)

2) Ask them to download and pivot or mark by country each day (which is a pain in the *** and a waste of upper management's time)

3) Make two reports - one international and one domestic - so that they're automatically separated (but then they'd have to integrate the reports together to see the full picture)

4) Magic


Options 1-3 are not ideal solutions. If I were able to run a program that took all anonymous leads and added an extra field that marked them "international" or "domestic" and then I could add that field to my report and then sort based on TWO criteria like in Excel (first level I want to sort by international v domestic, second level by page views) would be ideal, but I don't know if it's possible. Any recommendations?