# How to create the Subscription Retention Funnel in GA4

The **Affiliation** custom dimension helps you analyze subscription data and answer specific questions depending on your business needs. The `affiliation` parameter is exclusive to Littledata and without creating a custom dimension for this parameter, you won't be able to see the values in reports or use them in explorations.

If you'd rather watch a video guide on how to create a Subscription Retention Funnel:

{% embed url="<https://www.youtube.com/watch?v=dR_WhnTNYaI>" %}

In this article, we'll show you how to build the Subscription Retention Funnel, which relies on the **Affiliation** custom dimension, and its purpose is to improve your understanding of the Recurring purchases behaviour.

{% hint style="success" %}
To learn all that you need to know about creating funnels, here's our general tutorial about [Funnels in Google Analytics 4](/google-analytics/behavior/funnels-in-google-analytics-4.md)!
{% endhint %}

#### How to create the report?

1. Go into your Google Analytics 4 Account and click on **Explore**

![ga4 exploration tab](/files/v3dcJoSFVrbTVndTQsDm)

2. You'll create a blank exploration and select **Funnel exploration** for the technique

![funnel technique](/files/oKxogFf6wwsrN6uT3kot)

3. Click on **Steps**, and here is the configuration for the 4 steps

![step configuration for the funnel](/files/0rUQcVOkmSnEyqyaouyz)

After adding the configuration for every step, click on **Apply** and then your report will look like this:

![main report after adding the funnel steps](/files/AL2E5KA8bFNr2fIDBO0G)

{% hint style="info" %}
This report will show you how many people actually follow through to the subscription order number 2, number 3, etc.
{% endhint %}

#### Build user segments

In order to utilise GA4's superpowers, you can build user segments.

1. Click on the **Plus (+)** near Segments, and then on **User segment**. Here is the configuration of the Segment:

![adding user segments - google / cpc](/files/38C8D2Z8EcyC5YFN3GDX)

2. After adding the desired configuration, click on **Save and apply**
3. Now you'll repeat this process, only that you select `organic` instead of `google/cpc`

![adding user segments - organic](/files/Vd2ar7Vth4P8c0xY3EwH)

Now you can see how these two perform against each other and your report will look like this:

![final report](/files/yMxVtHgMDYjR2Vc9dFx5)

{% hint style="success" %}
We'd recommend to select a longer timeframe so you can actually see a sequence of orders, instead of seeing just one.
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.littledata.io/google-analytics/subscriptions/subscription-retention-funnel-ga4.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.