Anyone know of a way to download a csv or xlxs file of group user stats in steam gifts? Copying and pasting 10 pages of data, that I have to format 20 times is not convenient. Want to reward the best givers for the week.

Hacks, workarounds, etc are fine...just something other than I'm doing.

8 years ago

Comment has been collapsed.

Deleted

This comment was deleted 3 years ago.

8 years ago
Permalink

Comment has been collapsed.

Ive got a solution. Free

8 years ago
Permalink

Comment has been collapsed.

Summon ArchiBot for the job maybe?

8 years ago
Permalink

Comment has been collapsed.

Show me the source of what you're doing, and the output of what you want it to look like.

8 years ago
Permalink

Comment has been collapsed.

Just looking simply for

User Wins Win $ Sent Sent $

if I can execute this report for my group once a week, I can do the difference week to week.

Sorry...here is the source, would need all pages.
https://www.steamgifts.com/group/IOnyY/l33tkeys/users

8 years ago
Permalink

Comment has been collapsed.

That list is non-deterministic, and doesn't comply with being history-capable. It also doesn't take in account many factors such as whitelist/shared giveaways which have different modifier, so if you want to base on that then it'll hit you in the back sooner than you think. Viral from Arise also based initially on that, and it turned out to be more hassle than done manually.

If you need to track giveaways for your group, then you need ArchiBoT and something like this, capable of tracking giveaways.

This way by recording e.g. ends_at date you'd be able to tell how many giveaways user created in last month or how much he won, with a simple SQL query. That data could be then reused in nice and fancy way, as it's done in my Touhou Giveaways.

But that thing takes time, and costs money. If you're willing to spend 100$+ for having such fuctionality and ArchiBoT tracking your group giveaways then let me know.

8 years ago*
Permalink

Comment has been collapsed.

whitelist/shared giveaways which have different modifier

isn't that simply splitting by amount of groups (and wl counting as one)?

8 years ago
Permalink

Comment has been collapsed.

Nope, it's far more than that, I just pointed out example. Take stats of any smaller group, then compare with giveaways and you'll see that results are completely different than expected ones.

Yes, you can say that stats are working in specific way and everybody should follow that way, it's completely OK, and in this case you don't need anything else to work with. But many (if not all) groups have their own rules, such as Arise having value of 3 for non-bundled giveaways, 1 for bundled giveaways, and 0 for shared ones. If you try to adapt that logic to fixed stats scheme of SG, you'll see that it's completely broken - not only shared giveaway add to the value, but also value is completely off gift-based. So unless you want to keep track of those things yourself (which is pretty much disrespect of your own time, my group wouldn't exist without my bot), you need automated bot such as ArchiBoT which will count all of that in the way you want, and not in the way that SG does.

Because of no SG API, I'm not sure if there exists any other tool apart from mine which is capable of doing that. SGTools can track giveaway to some degree, but still lacks some things that ArchiBoT has, not to mention that it has totally different objective in mind.

8 years ago*
Permalink

Comment has been collapsed.

I see that it's not suitable for custom rules or anything more complex. I just wondered about the basic calculation. From what I saw isn't a 30p GA shared in 3 groups simply adding 10p value and 0.3 in amount to each group of the user's stats?

8 years ago
Permalink

Comment has been collapsed.

It should be, but I'm not sure how whitelist works with that.

Also such division is totally wrong as groups have different sizes and number of entries, I'd simply divide it based on entries that exist only in one group or another, not 1/2. Or even better - like in my group, reward with ratio if winner is in my group and not any other one.

8 years ago*
Permalink

Comment has been collapsed.

And also, Not sure that I ever implied that I was looking to purchase anything. I've given away 2000 games, which costs money, which costs me time working...ive also only won 23. I am a generous with my money, could you be generous with your time?

What about putting something together for me so that I can reward people who are also generous givers. How about free of charge?

8 years ago
Permalink

Comment has been collapsed.

Sorry, you will need to find somebody else then. For me (and many others) time is more valuable than giveaways. Not to mention that it's not only the time but also knowledge that is required to make it working.

8 years ago
Permalink

Comment has been collapsed.

Generosity has no boundaries.

8 years ago
Permalink

Comment has been collapsed.

And actually the "this" link is exactly what I would love to have. but no need to track based on date. Only need a run as needed basis.

8 years ago
Permalink

Comment has been collapsed.

sweet, a really generous person did it for free in 20 minutes. Now, i will offer to everyone. Free.

I think you meant to do that...you just forgot.

8 years ago
Permalink

Comment has been collapsed.

excel only

8 years ago
Permalink

Comment has been collapsed.

Do you know Deron?

8 years ago
Permalink

Comment has been collapsed.

I Don't know excel

8 years ago
Permalink

Comment has been collapsed.

You could parse the group user page for those info if you know simple programming

8 years ago
Permalink

Comment has been collapsed.

I'm dumb.

8 years ago
Permalink

Comment has been collapsed.

I can give you a Python script to base on. Add me on Steam if you want to try it.

8 years ago
Permalink

Comment has been collapsed.

Closed 8 years ago by braduc1980.