Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

*The new derived field for interactions entering a Q is called “Q Offered” to better match traditional WFM verbiage around “offered”. The API return for “entered” is the same as “Q Offered” in the system derived field.

Connections

Historical

  • Production Main - https://api.fathomvoice.com/V2/wfm/community/realTime/

  • Production Condo IZ1 - https://api-current.iz1.sharpen.cx/V2/wfm/community/realTime/

  • Stage (only for pre-production testing with Sharpen) - http://api-stage.sharpencx.com/V2/wfm/community/historical

Real Time

Returned Data

wfm-community-historical

...

(formulas for Abandoned Count and Entered Count (also known as Q Offered) were taken from THIS PAGE on 4/12/21. Any subsequent modifications to the system derived fields (by Sharpen or the customer) will not be reflected in the API endpoint)

The formula for enteredCount (knows as “Q Offered” in insights Derived Fields

Code Block
languagesql
SUM(
  CASE WHEN (
    queueID != "" 
    AND (
      answerTime != endTime 
      OR (
        answerTime IS NULL 
        AND endTime IS NOT NULL
      ) 
      OR (
        answerTime = endTime 
        AND waitTime > 0
      )
    ) 
    AND (
      commType != "phoneCall" 
      AND (
        transferType != "callback" 
        OR transferType IS NULL
      )
    )
  ) 
  OR (
    queueID != "" 
    AND transferType = "exitNoAgen"
  ) THEN 1 ELSE 0 END
)

The new formula for abandonedCount

Additional Notes

  • UTC….

  • historical api limits query timeframe to a max of 6 hours

...