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 ca…

This is the sort of analysis you can do with Data Explorer - do you have this installed? [image] Discourse Data Explorer Plugin discourse2 Summary Discourse Data Explorer allows you to make SQL queries against your live database, allowing for up-to-the-m…

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?

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: [image] (Superseded) What cool data explorer queries have you come up …

Group forum members based on topics viewed?

Support

robmc (Robert McIntosh) September 26, 2018, 10:18am 2

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

Topic		Replies	Views
Extracting email addresses for a group Support	10	2671	September 14, 2015
Howto/doc on 'data explorer' Support	15	897	October 30, 2024
See who viewed topic Data & reporting sql-query	10	3879	May 14, 2021
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	83481	October 22, 2025
Complex user activity report requirement Data & reporting sql-query	22	1956	August 5, 2021

Group forum members based on topics viewed?

Related topics