Best way to aggregate statistical percentages for custom data?

Question

question

brandon@uprootstudios.com asked May 25, '19

Best way to aggregate statistical percentages for custom data?

Hi, sorry if the title seems ambiguous, here's a better explanation:

In our title, there is a section where players can choose 3 out of 12 items in a grid. If a large enough amount of players make a choice, we want to be able to have the statistical/heuristic data for the entire grid so we can generate some sort of graphic/heatmap to show the most-commonly-chosen grid items (maybe by downloading the data once a month and putting the values in excel or similar?).

Is there a "best way" to implement this? Perhaps a custom playstream event when a player finished choosing grid locations and the body of the event is just: "TilesChosen": "0,4,5" or similar?

Thanks!

Player Data PlayStream

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-05-27T04:38:41Z

Seth Du answered May 27, '19

To be honest, the best solution can be maintaining an external database, for example, using SnowFlake.

Since the data may not grow too large, if this ‘Selection’ action won’t be performed frequently, I believe you can maintain it in Title data with 12 KVP like:

Key:

most_chosen_item

Data:

{
  “item1”: n,
  “item2”: n,
  “item3”: n,
  …
  “item12”: n
}

Call the Cloud Script to get current value and add player’s choice at once and be aware that normally speaking, title data will be up-to-date on all shards within a few seconds. But if the data is particularly large, it could take a bit longer.

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

brandon@uprootstudios.com commented · May 27, 2019 at 05:57 AM

What would be considered frequent? I'd assume most players would update their grid choices 3-10 times per-day (more-or-less). If our game was to scale to hundreds/thousands of players, would that be too many API calls?

0 ·

Seth Du ♦ brandon@uprootstudios.com commented · May 27, 2019 at 08:42 AM

It should be fine as long as it is not like player statistics which needs to be refreshed per match.

0 ·

Answer 2 · 2019-05-27T01:21:38Z

brandon@uprootstudios.com answered May 27, '19

If using custom data, can custom event data be downloaded?

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Seth Du ♦ commented · May 27, 2019 at 04:39 AM

SnowFlake is capable of handling all events

0 ·

question