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)
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?