How can we know the number of subscriptions for each user in a specific city and period of time?

You can use the subscription page and apply the city and subscription creation date filters to view only the subscriptions created in 2024 (for example) for each city. And then you could export the excel file and filter it based on your needs.