Skip to main content
Solved

Identify users who create or reply to posts within a certain time period

  • 17 May 2024
  • 3 replies
  • 30 views

Hi :-)
I’m running an engagement contest in June that will recognize users who create 1 post or reply to two posts. Is there an easy way to identify these users?

It looks like I can create a Segment that measures activity within a certain time period and counts number of posts or replies but the count is for all time, not within the defined time period. 

3 replies

Userlevel 5

@Rhonda this is super easy if you have access to the BI connector to CC Data Lake Silver Layer BETA. You will also need SQL to use this, but it allows you access to practically everything you need.

However, without that (and it is a BETA) you may want to try exporting your time range using the Export feature. I have quickly tested this and it seems to give the info you need, but will require a tiny bit of Excel work after you’ve downloaded it.

 

 

Userlevel 1

thanks @rhall :-) I hadn’t considered the Export option. 

Userlevel 5

Make sure you use the “post” option. The “user” options gives you figures, but it appears to limit the users by registration date. So you only get the figures for users who registered during that period.

Reply