bernhardalber Posted April 26, 2023 Report Share Posted April 26, 2023 Hi, we're currently building a frontend for our publishers and in order to display stats to them we need to query the hourly_stats by zone_id. I can't find the link between zone_id and user_id anywhere. Can anyone tell me where I find that? Thanks! Quote Link to comment Share on other sites More sharing options...
bernhardalber Posted April 26, 2023 Author Report Share Posted April 26, 2023 You have to make around 5 db calls with the solution i found rv_accounts->rv_affiliates->rv_zones->rv_data_summary_hourly Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.