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% |