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 /
  • General Discussion /
avatar image
Question by rob-2 · Jan 15, 2020 at 06:05 PM · dataanalytics

Identifying PlayFab player segments in Snowflake

Hi there!

We have recently begun messing around with PlayFab's AB testing. Out data team uses Snowflake integration and would like to dig into how players in certain AB test segments behave but, we are having some difficulty identifying which PlayFab player segments a player belongs to in Snowflake:

From the documentation it seems we should be able to identify what segments a user is in by looking at player_action_executed events that contain the TriggeringSegmentMembershipChange property.

As the player_action_executed event is fired by a variety of triggers we have a large number to query but we have been unable to find any that contain the TriggeringSegmentMembershipChange property which seems strange.

We use an older sdk (2.58.181218) so are wondering if the documentation does not apply to our version.

It would be good to know:

  1. Is player_action_exectued/TriggeringSegmentMembershipChange the correct event/property to use to determine a player's segments in Snowflake (for our PlayFab sdk version)?
  2. If so, would it be possible to provide an example of a Snowflake query that would return an instance of an player_action_exectued event that contains the TriggeringSegmentMembershipChange property?

Many thanks.

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
Best Answer

Answer by Citrus Yan · Jan 16, 2020 at 06:33 AM

The event “player_action_executed” is triggered when an action linked to a segmentation change or event rule executes on a player. The TriggeringSegmentMembershipChange property indicates whether the “player action” was triggered by segmentation change: SegmentMembershipChange, therefore, it’s not the correct event/property to use to determine a player’s segments in Snowflake.

I don’t know exactly how you want to analyze in Snowflake. Nevertheless, for now ( due to the fact that GetPlayersInSegment currently does not support AB Test segments), in order to identify PlayFab player ABTest segments, you may need to call GetPlayerSegments to tell which ABTest segment that the player currently belongs to, the response looks like this:

"data": {
        "Segments": [
            {
                "Id": "xxx",
                "Name": "ABTest - A",
                "ABTestParent": "xxx"
            },
            {
                "Id": "xxx",
                "Name": "All Players"
            }
        ]
    }
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

    Unable to aggregate by average 0 Answers

    Data warehouse for storage and analysis 1 Answer

    How can you connect to PlayFab using the Kusto.Explorer tool? 1 Answer

    How to aggregate remaining virtual currency held by all users? 1 Answer

    Event Archive S3 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