Group forum members based on topics viewed?

[Henry_Cooper]

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

[robmc (Robert McIntosh)]

This is the sort of analysis you can do with Data Explorer - do you have this installed?

Discourse Data Explorer

Summary Discourse Data Explorer allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting. Install Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately. 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 par…

[Henry_Cooper]

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?

[bts (Brendan Schlagel)]

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?

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 query, or have one to share, please start a new topic in the Data & reporting category and tag it with the sql-query tag. For an alternative searchable list of queries that were in this topic, see @SidV’s query list on GitHub.