Skip to content

Latest commit

 

History

History
99 lines (91 loc) · 2.7 KB

looker-tickets_zendesk_schema.md

File metadata and controls

99 lines (91 loc) · 2.7 KB

looker-tickets_zendesk_schema

  • Model

    • looker-tickets.zendesk.csat_boosted_tree_classifier
    • Labels: predicted_csat_category INT64
    • Features: looker-tickets.zendesk.new_tickets

      Priority STRING
      Is_Escalated BOOL
      Is_FRT_Slo_Breach BOOL
      Is_Autosolved BOOL
      Is_Cloud_Support_Case_Used BOOL
      Cloud_Platform STRING
      Product STRING
      Agent_Time_Zone STRING
      Requester_Time_Zone STRING
      Requester_Region STRING
      Average_Solve_Time_Hours FLOAT64
      Average_Customer_Mrr FLOAT64

  • Routines

    • looker-tickets.zendesk.cosine_similarity

  • Tables

    • looker-tickets.zendesk.AvaKeyWords

      Type STRING
      Name STRING
      Definition STRING
      Keywords STRING
      Content STRING
      Embedding FLOAT
      array_length INTEGER

    • looker-tickets.zendesk.confidence_score

      agent_name STRING
      tickets INTEGER
      avg_sentiment_integer FLOAT
      confidence_score FLOAT

    • looker-tickets.zendesk.conversations_complete

      ticket_id INTEGER
      array_length INTEGER
      embeddings FLOAT

    • looker-tickets.zendesk.vector_similarity_scores

      ticket_id INTEGER
      Name STRING
      Type STRING [Issue, Resolution]
      similarity FLOAT

    • looker-tickets.zendesk.tickets_complete

      Ticket_ID INTEGER
      Created_Date DATE
      Priority STRING
      Status STRING
      Is_Escalated BOOLEAN
      Is_Autosolved BOOLEAN
      Is_Requester_From_Doit BOOLEAN
      Is_Getcre BOOLEAN
      Is_Public BOOLEAN
      Is_FRT_Slo_Breach BOOLEAN
      Is_Cloud_Support_Case_Used BOOLEAN
      Cloud_Platform STRING
      Practice_Area STRING
      Skill_Group STRING
      Product STRING
      Subject STRING
      Agent_User_ID FLOAT
      Agent_Name STRING
      Agent_Pod STRING
      Agent_Region STRING
      Agent_Time_Zone STRING
      Requester_ID INTEGER
      Requester_Name STRING
      Requester_Email STRING
      Requester_Organization_Name STRING
      Requester_Region STRING
      Requester_Time_Zone STRING
      Rating STRING
      Rating_Comment STRING
      Rating_Comment_Length FLOAT
      Rating_Offered INTEGER
      Agent_Score INTEGER
      RND_T FLOAT
      Sentiment FLOAT
      Sentiment_Heuristic STRING
      Sentiment_Integer FLOAT
      Average_Solve_Time_Hours FLOAT
      Average_FRT_Hours FLOAT
      Average_Customer_Mrr FLOAT
      Count INTEGER
      total_comment_length INTEGER
      comment_count INTEGER
      conversation_duration_days INTEGER
      embedding_length INTEGER
      Best_Matched_Issue STRING
      Best_Matched_Resolution STRING
      Best_Issue_Similarity FLOAT
      Best_Resolution_Similarity FLOAT