Microsoft Azure PlayFab logo
    • Multiplayer
    • LiveOps
    • Data & Analytics
    • Add-ons
    • For Any Role

      • Engineer
      • Designer
      • Executive
      • Marketer
    • For Any Stage

      • Build
      • Improve
      • Grow
    • For Any Size

      • Solo
      • Indie
      • AAA
  • Runs on PlayFab
  • Pricing
    • Blog
    • Forums
    • Contact us
  • Sign up
  • Sign in
  • Ask a question
  • Spaces
    • PlayStream
    • Feature Requests
    • Add-on Marketplace
    • Bugs
    • API and SDK Questions
    • General Discussion
    • LiveOps
    • Topics
    • Questions
    • Articles
    • Ideas
    • Users
    • Badges
  • Home /
  • PlayStream /
avatar image
Question by Dawid Fatyga · 6 days ago · CloudScriptTitle DataPlayStreamanalytics

Aggregate custom events into a Histogram from Cloud Script (or anything that runs e.g daily)

Hi,

I am trying to do something (seemingly) simple, but I could not find a good working solution yet: I have a custom event that is fired when player finishes each level, with the level name and the number of moves they made.

I would like to to have a script that would:

1. run a daily/hourly (after each custom event, does not matter)

2. query the playstream and calculate a histogram of moves for that level

3. store the results in Title Data

I know how to do 1 and 3, but I cannot find info about 2.

So far I have seen people recommending to use Snowflake for this (https://community.playfab.com/questions/13765/how-to-retrieve-history-of-player-login-time-and-v.html), but then I found that Snowflake integration was shut down (https://community.playfab.com/questions/35883/data-warehouse-for-storage-and-analysis.html), however links suggested in the answer do not work any more.

Thanks in advance for help!

Dawid

P.s It this cannot be done, I think I will resort to simply calculating the histogram online as the event is sent, as in "read title data + modify + write". This will not be as precise solution as with the query playstream (as there I could deduplicate by user ID), but it should be good enough.

Comment

People who like this

0 Show 0
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

1 Reply

· Add your reply
  • Sort: 
avatar image

Answer by SethDu · 6 days ago

It is possible that you may implement Kusto C# SDK in Azure Function to query those customized event and create a scheduled task to execute this function hourly.

Please navigate to Connecting Kusto C# SDK to Insights - PlayFab | Microsoft Docs to know more details about Kusto SDK.

Comment

People who like this

0 Show 0 · Share
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Navigation

Spaces
  • General Discussion
  • API and SDK Questions
  • Feature Requests
  • PlayStream
  • Bugs
  • Add-on Marketplace
  • LiveOps
  • Follow this Question

    Answers Answers and Comments

    2 People are following this question.

    avatar image avatar image

    Related Questions

    Sending analytics events to Gcloud bucket 2 Answers

    Automation>Rules question 1 Answer

    Execute Cloud Script With Arguments 1 Answer

    Cloud code on gamelobby_ended 2 Answers

    entity_catalog_item_created play stream event doesn't work 1 Answer

    PlayFab

    • Multiplayer
    • LiveOps
    • Data & Analytics
    • Runs on PlayFab
    • Pricing

    Solutions

    • For Any Role

      • Engineer
      • Designer
      • Executive
      • Marketer
    • For Any Stage

      • Build
      • Improve
      • Grow
    • For Any Size

      • Solo
      • Indie
      • AAA

    Engineers

    • Documentation
    • Quickstarts
    • API Reference
    • SDKs
    • Usage Limits

    Resources

    • Forums
    • Contact us
    • Blog
    • Service Health
    • Terms of Service
    • Attribution

    Follow us

    • Facebook
    • Twitter
    • LinkedIn
    • YouTube
    • Sitemap
    • Contact Microsoft
    • Privacy & cookies
    • Terms of use
    • Trademarks
    • Safety & eco
    • About our ads
    • © Microsoft 2020
    • Anonymous
    • Sign in
    • Create
    • Ask a question
    • Create an article
    • Post an idea
    • Spaces
    • PlayStream
    • Feature Requests
    • Add-on Marketplace
    • Bugs
    • API and SDK Questions
    • General Discussion
    • LiveOps
    • Explore
    • Topics
    • Questions
    • Articles
    • Ideas
    • Users
    • Badges