Hi everyone! I've been trying to get my team to adopt Helicone for our LLM usage tracking, and I wanted to show some value right away. The dashboards are great, but I needed something specific: a simple report showing which internal users were using the most tokens/cost in the last week.
I was a bit overwhelmed by the docs at first, but I figured out how to use the logs API to pull this data myself. It was actually easier than I thought! I basically fetched the logs for the last 7 days, grouped them by the custom property we set for 'user_id', and then summed up the total cost.
Now I can run this script weekly and share it with our project leads. It's helping us see who the power users are and start conversations about optimizing prompts. Next, I'm thinking of trying to break it down by project or feature flag. Has anyone else built custom reports like this? I'd love to hear what you're tracking or if you have any tips for making the data pull more efficient 😅