# I want to report people added to a segment between two dates

**URL:** <https://forum.mautic.org/t/i-want-to-report-people-added-to-a-segment-between-two-dates/12571>\
**Category:** General Discussion\
**Created:** [February 4, 2020, 5:54am UTC](https://forum.mautic.org/t/i-want-to-report-people-added-to-a-segment-between-two-dates/12571 "2020-02-04T05:54:15Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rgbguy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rgbguy/32/652_2.png) [@rgbguy](https://forum.mautic.org/u/rgbguy)\
**Post date:** [February 4, 2020, 5:54am UTC](https://forum.mautic.org/t/i-want-to-report-people-added-to-a-segment-between-two-dates/12571/1 "2020-02-04T05:54:16Z")

</div>

Okay I have chosen the data source -\> Contacts: Segment Membership  
I go to the data table and I can see no way of sorting a specific segment by a specific set of dates.

This seems like it should be do able maybe I am missing something.

Does anyone know whether it’s possible to filter by date added to a segment?

---

<div class="post-metadata">

**Author:** ![malcolm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/malcolm/32/39_2.png) [@malcolm](https://forum.mautic.org/u/malcolm)\
**Post date:** [August 19, 2020, 5:38am UTC](https://forum.mautic.org/t/i-want-to-report-people-added-to-a-segment-between-two-dates/12571/2 "2020-08-19T05:38:46Z")

</div>

I’m trying to do exactly the same thing. Did you ever figure out a solution? None of the date fields seem to be about when they were added.

Cheers  
Malcolm

---

<div class="post-metadata">

**Author:** ![pilar](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/pilar/32/609_2.png) [@pilar](https://forum.mautic.org/u/pilar)\
**Post date:** [July 11, 2021, 6:58am UTC](https://forum.mautic.org/t/i-want-to-report-people-added-to-a-segment-between-two-dates/12571/3 "2021-07-11T06:58:51Z")

</div>

Did any find the solution to this?  
I am trying to see the growth of segments between dates and I don’t know where to find this information

---

<div class="post-metadata">

**Author:** ![malcolm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/malcolm/32/39_2.png) [@malcolm](https://forum.mautic.org/u/malcolm)\
**Post date:** [July 19, 2021, 4:59am UTC](https://forum.mautic.org/t/i-want-to-report-people-added-to-a-segment-between-two-dates/12571/4 "2021-07-19T04:59:28Z")

</div>

I haven’t yet.

---

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [July 19, 2021, 9:01am UTC](https://forum.mautic.org/t/i-want-to-report-people-added-to-a-segment-between-two-dates/12571/5 "2021-07-19T09:01:41Z")

</div>

Hi There is a solution for this if you are prepared to go into the mysql database itself.  
If you look in the lead\_lists\_lead table you will be able to query that to get what you want.

Here is a simple query which will just give you the count of leads added to a specific segment over a specific period of time:

select count(lead\_id) from lead\_lists\_leads where date\_added \>= “2021-07-01%” and date\_added \<= “2021-07-18%” and leadlist\_id = 33;