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”.
- Around 69% of active Publish users are untagged.
- Around 59% of active Analyze users are untagged.
- Around 61% of active Reply users are untagged
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.
We can see that around 68% of users that have triggered a Segment event have not been tagged by the target customer survey.
Now let’s only look at Publish customers.
Around 69% of active Publish users don’t have a company type associated with them.
Around 59% of active Analyze users do not have a company type associated with them.
Around 61% of active Reply users do not have a company type associated with them.