# 根据浏览的主题对论坛成员进行分组？
**URL:** https://meta.discourse.org/t/group-forum-members-based-on-topics-viewed/98066
**Category:** Support
**Created:** [2018年九月26日 02:28 UTC](https://meta.discourse.org/t/group-forum-members-based-on-topics-viewed/98066 "2018-09-26T02:28:22Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Henry\_Cooper](https://meta.discourse.org/u/Henry_Cooper)
#### Post date: [2018年九月26日 02:28 UTC](https://meta.discourse.org/t/group-forum-members-based-on-topics-viewed/98066/1 "2018-09-26T02:28:22Z")
I am thinking about setting up a re targetting campaign where I will send specific emails to users who viewed specific topics on my forum.
For example someone views a topic about camping tips, I then send them an email where I refer them to a blog on my website about ‘10 tips you must know about camping’
I know that sending emails with discourse is going to be hard, but could I somehow group members based on topics that they have viewed, and then export their emails, and add them to the email marketing campaign?
I know I can just do something similar with facebook re targeting ads (which I will do for sure), but was wondering if this could be a possible alternative.
Thanks in advance
---
### Author:  [@robmc](https://meta.discourse.org/u/robmc)
#### Post date: [2018年九月26日 10:18 UTC](https://meta.discourse.org/t/group-forum-members-based-on-topics-viewed/98066/2 "2018-09-26T10:18:32Z")
This is the sort of analysis you can do with [Data Explorer](https://meta.discourse.org/t/32566?silent=true) - do you have this installed?
> [@Discourse Data Explorer](https://meta.discourse.org/t/data-explorer-plugin/32566):
>
> discourse2Summary Discourse [Data Explorer](https://meta.discourse.org/t/32566?silent=true) allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting.open_bookInstall Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately.information_source If you’re looking for examples or support for any custom queries, you can find lots of topics in our #Data & reporting category under the #sql-query tag. If there’s not one to suit your pa…
---
### Author:  [@Henry\_Cooper](https://meta.discourse.org/u/Henry_Cooper)
#### Post date: [2018年九月26日 19:09 UTC](https://meta.discourse.org/t/group-forum-members-based-on-topics-viewed/98066/3 "2018-09-26T19:09:50Z")
This seems like the perfect plugin!
the only problem is I don’t know how to make/write queries. Is there any easy way around that, or will I just have to learn?
---
### Author:  [@bts](https://meta.discourse.org/u/bts)
#### Post date: [2018年九月26日 19:24 UTC](https://meta.discourse.org/t/group-forum-members-based-on-topics-viewed/98066/4 "2018-09-26T19:24:03Z")
This topic has a ton of useful example queries. Chances are some may be pretty close to what you’re looking for, and by playing around a bit you’ll start to get a feel for how the queries are constructed:
> [@(Superseded) What cool data explorer queries have you come up with?](https://meta.discourse.org/t/what-cool-data-explorer-queries-have-you-come-up-with/43516):
>
> This topic became too long to be easily searched and has been broken down into separate topics. If you have any questions about how to write a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query, or have one to share, please start a new topic in the #Data & reporting category and tag it with the #sql-query tag. +1information_source For an alternative searchable list of queries that were in this topic, see @SidV’s [query list on GitHub](https://github.com/SidVal/discourse-data-explorer/blob/queries/querys.md).
---
### Author:  [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [2022年十月5日 18:54 UTC](https://meta.discourse.org/t/group-forum-members-based-on-topics-viewed/98066/10 "2022-10-05T18:54:49Z")