# Data explorer challenge: Generate list of members by location

**URL:** <https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [January 12, 2017, 3:11pm UTC](https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648 "2017-01-12T15:11:45Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![tobiaseigen](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tobiaseigen/32/539204_2.png) [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)\
**Post date:** [July 19, 2023, 6:00pm UTC](https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648/7 "2023-07-19T18:00:50Z")

</div>

Nice! Thanks for the (very belated) offer of a query to solve my problem. Maybe it will be helpful to others. I no longer work at Namati where we were trying to target a post to members in Pakistan. The way we solved this type of problem in the end was by creating an insight dashboard in WordPress, which we had set up to accompany Discourse using the [WP Discourse](https://github.com/discourse/wp-discourse) wordpress plugin and SSO. In the dashboard we created a view allowing us to filter by location and many other criteria besides.

We could then export that list to a spreadsheet and grab the usernames or email addresses to use in various ways in Discourse. My preferred way was to send a PM to each user directly to let them know about an opportunity specific to them.

---

_[View the full topic](https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648)._