Skip to main content
Rhonda
Contributor ⭐️⭐️⭐️
May 17, 2024
Solved

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

  • May 17, 2024
  • 3 replies
  • 78 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. 

    Best answer by rhall

    @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.

     

     

    3 replies

    rhallAnswer
    Expert ⭐️
    May 17, 2024

    @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.

     

     

    Rhonda
    RhondaAuthor
    Contributor ⭐️⭐️⭐️
    May 17, 2024

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

    why are there signatures at the end of every post?
    Expert ⭐️
    May 17, 2024

    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.