Customer Email Subscription between dates Report

Topic summary

A user is attempting to generate a report showing customers who subscribed to their newsletter within a specific date range (November 22 - December 3, 2024) using Shopify Segments.

Current Approach:

  • Using filters: email_subscription_status = 'SUBSCRIBED' AND customer_added_date BETWEEN 2024-11-22 AND 2024-12-03
  • Includes a screenshot showing the segment configuration

Issue Identified:
The customer_added_date field tracks when customers registered/were created, not when they subscribed to the newsletter.

Question:
Looking for a “customer subscribed date” field or alternative method to accurately filter by newsletter subscription date rather than account creation date.

Status: Awaiting community guidance on whether such a field exists in Shopify Segments or if an alternative solution is available.

Summarized with AI on November 2. AI used: claude-sonnet-4-5-20250929.

Hi,

I’m trying to get the number of customers that has been subscribed to our newsletter between a range of dates. To do that, I’m using the following parameters in Segments:

email_subscription_status = ‘SUBSCRIBED’ AND customer_added_date BETWEEN 2024-11-22 AND 2024-12-03

However, I guess that customer added date is when they have registered and this is not what I’m looking for. I would need like “customer subscribed date”. It is possible?

Thank you!

1 Like