2 min read

What Proportion of Active Users Are Tagged?

In this analysis we’ll try to determine the proportion of active users that have been tagged by our target customer survey. I gathered the “active” user counts by collecting users that took the most common action in each product. For publish that was “Post Created”, for Analyze it was “Report Module Added”, and for Reply it was “Conversation Closed”.

TLDR

  • Around 69% of active Publish users are untagged.
  • Around 59% of active Analyze users are untagged.
  • Around 61% of active Reply users are untagged

Data Collection

We’ll use the SQL query below to retrieve data from Bigquery.

# connect to bigquery
con <- dbConnect(
  bigrquery::bigquery(),
  project = "buffer-data"
)

# define sql query
sql <- "
  select
    i.company_type
    , event
    , count(distinct t.user_id) as users
  from dbt_buffer.segment_tracks t
  left join dbt_buffer.segment_identifies i
    on t.user_id = i.user_id
  where t.original_timestamp > timestamp_add(current_timestamp() , interval -30 day)
  and event in ('post_created', 'report_module_added', 'conversation_closed')
  group by 1, 2
  order by 3 desc
"
  
# query BQ
tags <- dbGetQuery(con, sql)

Let’s see the overall proportion of active users that have responded to the target customer survey.

company_type users percent
NA 125,473 68.4%
agency 11,804 6.4%
online-store 7,874 4.3%
publisher 7,505 4.1%
personal 6,966 3.8%
no-answer 6,753 3.7%
none 5,831 3.2%
physical-store 5,755 3.1%
b2b 3,398 1.9%
saas 2,053 1.1%

We can see that around 68% of users that have triggered a Segment event have not been tagged by the target customer survey.

Publish

Now let’s only look at Publish customers.

company_type users percent
NA 123,613 68.6%
agency 11,443 6.3%
online-store 7,655 4.2%
publisher 7,412 4.1%
personal 6,884 3.8%
no-answer 6,549 3.6%
none 5,788 3.2%
physical-store 5,649 3.1%
b2b 3,334 1.8%
saas 1,974 1.1%

Around 69% of active Publish users don’t have a company type associated with them.

Analyze

Around 59% of active Analyze users do not have a company type associated with them.

company_type users percent
NA 873 58.5%
agency 258 17.3%
online-store 69 4.6%
no-answer 68 4.6%
physical-store 52 3.5%
publisher 52 3.5%
personal 50 3.4%
b2b 31 2.1%
none 27 1.8%
saas 12 0.8%

Reply

Around 61% of active Reply users do not have a company type associated with them.

company_type users percent
NA 987 61.0%
online-store 150 9.3%
no-answer 136 8.4%
agency 103 6.4%
saas 67 4.1%
physical-store 54 3.3%
publisher 41 2.5%
b2b 33 2.0%
personal 32 2.0%
none 16 1.0%