question

rob-2 avatar image
rob-2 asked

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.

dataanalytics
10 |1200

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

1 Answer

·
Citrus Yan avatar image
Citrus Yan answered

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"
            }
        ]
    }
10 |1200

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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

Error rendering WebPanel (widgets/consolidation-widget.ftl): org.hibernate.hql.internal.ast.QuerySyntaxException: AvailableConsolidation is not mapped [from AvailableConsolidation up where up.node = :node]