> For the complete documentation index, see [llms.txt](https://help.littledata.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.littledata.io/google-analytics/subscriptions/subscription-retention-funnel-ga4.md).

# 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 behavior.

{% 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 utilize 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 %}