[Tool] SGMT - SteamGifts Group Management Tool: Open-source tool I've been working on

Sounds nice, but I would guess it will run rather slow until caching is implemented.

I've made some modifications to the tool.
It now runs as a Service, and keeps all it's data in MySql.
Subsequently, most commands take less than 1 second to execute.
In the near future, I'm planning on deploying it on a remote server (probably in AWS) for easier access.

Added response examples.

this tool is great lol

This looks interesting...

Have a bump for the good work

Cool!

Added new feature: Ability to see most popular giveaways per month

Wow, I was just thinking about asking you how you were able to run the QGG group, and now I know. :)

That's impressive

Tool location has moved to http://www.sgmt.name:8080/SGMT/

Anyone using it - please be advised you need to change your links.

Update:
Added a new feature, this time designed to help group users rather than group admins:
CheckGameGiveaways - Shows the number of entries (of group users ONLY) every time a game was given away in the group. Response example: https://imgur.com/a/6ZzxQU5

The reason for this is:
When you give away a game in the group, you want to know how many entries it got last time it was given away in the group.
A SteamGifts search will give you the number of entries for each giveaway, but from all groups it was given away to.
For example: A game may appear to have 24 entries last time it was given away, but out of those 24, only 2 were from the group I'm giving it away to now. So if I create a GA only for the group - I will only get 2 entries at most (and not 24).

I've taken the first step for my group to be integrated (sent an invite to sgmt.support).
Just a question: would it be possible to enable GroupUsersSummary to return in-group ratios? (total GA value given / total GA value won and total GAs sent / total GAs won)
In any case, thanks a lot for that tool. It will save me a lot of time.

Nice! thanks for sharing with the community!

thanks mate great tool

This seems to be a valuable tool. Thank you for sharing.

I sent an invite to sgmt.suport on Steam, but I'm not sure if I also need to give you a heads up here – so I do, just in case :)

I was always amazed that people can create programs like that.

Programming for me is like black magic.

Tool was recently updated with more efficient behavior.
SteamGifts data is now updated hourly. i.e. All SteamGifts-based info the tool shows will have at most 1 hour delay.

Have a bump!

I'm not sure if any other group (except mine) is using the tool at the moment, but just in case, here's an update:
Due to recent limitations added on SteamGifts this tool has been working on and off for the past week.
But it's finally stabilized, and I've added various optimizations to minimize access to SteamGifts.
This can have minor impact on the accuracy of the tool (for example if within 1 hour 1 user will leave a giveaway while another will join - this will not be registered).

It's been a while since the last update, but I finally got annoyed enough to do some changes in the tool.
So the current changes are as follows:

• UserCheckRules now has the ability to check if user created a shared free game giveaway (marked ** in SG). This very specific feature is aimed to allow automatic testing of one of the rules in the QGG group.
• This ability is now based on SteamGifts own list instead of being based on barter VG list (as it was before)
• This list is scraped using the new-ish json API of SteamGifts

What this basically means, beyond the specific feature mentioned above (which is not very useful for 99% of all cases), is that SGMT tool can now know for every game if it was bundled, given away for free, or neither.
And new features can be developed based on that (if anyone asks me to).
Examples:

• Check if all giveaways created are unbundled
• Check if every group member created at least 1 unbundled giveaway per month
• Check if any no-value giveaways were created in the group
• etc.

Update:
It's been a while since my last update, and this time the update was forced upon me.
It's all started 7 years ago, when I first created the tool...

initially the tool was deployed on a single smallest AWS server, which hosted both the tool and the DB, and was free.
However as more data and more groups were collected, I was forced to move to a bigger server (that cost money).
I moved to the cheapest spot instance I could find.
However I soon found out the hard way, that spot instances don't last.
And at the first spot instance replacement, I lost my entire DB contents, and needed to rebuild it from scratch.

That's when I decided to move my DB to a manager MySql.
While the service itself remained on a spot instance.
Until that single spot instance was not enough to load the data of a group, so I had to use 2 spot instances.
One for scraping & collecting the data.
And the other for UI and serving data to users.

So my expenses grew from a couple of bucks a month.
Which I could cover by AWS usage credits.
To 25$ a month for a long while
to $40+ a month in recent months.
While the spot instances became less and less reliable, and forced me to redeploy my code after each replacement (and also made the tool unavailable).

So this week, after redeploying the service every day of the week, I finally broke down and decided to migrate to AWS lambda.
lambda is not trivial, and it's been a while since I worked with Python (I used to work with it all the time back when I first wrote the tool. But did not touch it at all in recent years).
And my task was double: Migrate from a deployed service to a lambda, and migrate from Python 2 to Python 3.
Fortunately, with the current state of AI and chatbots, something that would have taken me weeks if not months, in the past, I was now able to accomplish in a couple of days.

So I'm happy to announce that SGMT (or at least the user-facing functionality) is now running on an AWS lambda.
Which both reduces my monthly AWS bill.
And reduces the failures and downtime of the SGMT tool.

One thing that does change, is the address under which the tool can be found.
I've updated the addresses both here, and in the QGG group recruitment page.
However, if anyone is using the links directly - they need to remove ":8080", replace http with https, and remove the "/" at the end of the address (if there is one).

Update:
I have used this opportunity to update the UI as well.
It no longer looks like a UI written by someone who never saw a website in his life :))