We can't troubleshoot unless you say in what way it doesn't work.
Then the user should go to the Editor, select the "All Macros" Smart Group (or a Group of interest), and sort by "Use Count". That information isn't directly available via AppleScript.
But you could take a look at some of the other recently-posted macros that list macro information -- one of those might do what you want by querying the database which stores that info. And keep an eye out for @DanThomas's forthcoming Macro Explorer, there's a usage count column in the screenshot.