jaymay

{
"industry": {
"manufacturing": {
"full_resolution_time_in_minutes_mean": 8707.52279122116,
"first_reply_time_in_minutes_median": 285,
"first_reply_time_in_minutes_mean": 1491.2547945205479,
"satisfaction_rating": 0.9559394409937889,
"one_touch_percentage": 0.3623462630085147,
"nps": null,
"active_agent_comments_average": 7.0513157894736835,

jaymay

select 
e.author_id, 
u.name, 
ui.value as email,
u.roles, 
count(distinct e.parent_id) num_distinct_updates_wo_reassigment
from classic.events e
inner join users u on e.author_id = u.id
inner join user_identities ui on e.author_id = ui.user_id
where e.account_id = 361618 

jaymay

select a.plan_type, 
count(*) total_accounts,
sum(if(p.satisfaction_ratings_last_90_days > 1000, mrr.mrr_amt, 0)) / sum(mrr_amt) perc_eligible_satisfaction_prediction,
sum(if(r.num_shared_macros > 10, mrr.mrr_amt, 0)) / sum(mrr_amt) perc_eligible_macro_suggestion,
sum(if(co.num_hc_articles > 10, mrr.mrr_amt, 0)) / sum(mrr_amt) perc_eligible_content_suggestion
from accounts_settings s
inner join accounts a using (account_id, run_at)
inner join fdw_mrr mrr using (account_id, run_at)
left join count_objects co using (account_id, run_at)
left join ticket_rules r using (account_id, run_at)

jaymay

SELECT 
    agent_id,
    agent_type,
    is_owner,
    agent_name,
    agent_email,
    subquery.*
FROM
    (SELECT 
        account_id,

jaymay

SELECT a.subdomain, s.*
FROM accounts a
INNER JOIN subscriptions s USING (account_id , run_at)
WHERE account_id IN (846669 , 846684, 846676) 
AND run_at = 20151029

jaymay

select result.account_id as account_id, plan_type, ticket_create_session_w_article_view, total_tickets_created, total_articles_viewed
from (
  select account_id, sum(if(tickets_created > 0 and articles_viewed > 0, 1, 0)) ticket_create_session_w_article_view, sum(tickets_created) total_tickets_created, sum(articles_viewed) total_articles_viewed
  from (
    select 
    account_id, session, sum(if(type = 'create', 1, 0)) tickets_created, sum(if(type = 'child_view', 1, 0)) articles_viewed
    from (
      select 
      Sessionize(unix_time, user_id, 1800) as session, account_id, user_id, type
      from (

jaymay

select a.plan_type, sum(api.num_installs) installs
from accounts a
left outer join app_installs api on a.account_id = api.account_id and a.run_at = api.run_at and a.timespan = api.timespan
inner join apps ap on api.app_id = ap.id 
where a.run_at = 20150601
and ap.name like ('talkdesk')
and a.account_type = 'customer'
group by a.plan_type

jaymay

select case when u.roles in (2,3) then 'agent'
       else 'user'
       end role, 
       asr.target_audience,
       count(*) num_views,
       count(distinct unique_token) unique_tokens
from default.stats_hc_events hc 
left outer join classic.users u on u.id = hc.user_id
inner join classic.account_survey_responses asr on asr.account_id = hc.account_id
where dt between 20150601 and 20150607 and hc.child_type = 'Article' and hc.type = 'child_view'

jaymay

$(document).ready(function() {

  // stuff here
 
  // identify a user's attributes
     var dimensionValue = HelpCenter.user.role;
     ga('set', 'dimension1', dimensionValue);
 
     var dimensionValue = HelpCenter.account.subdomain;
     ga('set', 'dimension2', dimensionValue);

jaymay

select results.industry, 
percentile_approx(avg_duration/60, 0.5) avg_duration_minutes, 
percentile_approx(avg_wait_time/60, 0.5) avg_wait_time_minutes,
count(*) num_accounts,
sum(count) num_calls
  from
  (
    select 
    asr.industry, 
    v.account_id,