Analytics Questions - OpenText

Unknown
Unknown
edited April 2018 in Product

Recently OpenText has begun asking for a monthly database export for the purpose of analytics. I asked them what exactly they were looking to find in the hopes that our API endpoints would suffice so we do not have to do this monthly export of their very large site.

  • Date – Time stamp of online post creation.
  • Item Link (or Object ID) – Object ID of post / URL to post
  • Comment Summary – Text from the post
  • Response Accepted Y/N (ex. Accepted Answer) – indicator/flag showing that a post's response was accepted as the correct answer
  • Product Line/Category – The product name or category under which the post was created.
  • Responder – Names/Screen names in the thread of those who responded to the initial post

  • Poster/Author – Name/Screen name of the post's creator

  • Average Time to Answer (Hrs.) – Number of hours after the initial post in which a response was marked "Accepted Answer."

  • Average Time to IR (Hrs.) – Number of hours after the initial post to which a response was posted in the thread.
  • Unique Count of Answers by User Name – Number of marked "accepted Answer" attributed to a responder.
  • Median Time to Answer (Hrs.) – the Calculated median in the number of hours after the initial post to which a response was posted in the thread.
  • Median Time to IR (Hrs.) – Calculated median in the number of hours after the initial post to which a response was posted in the thread.

They would be open to these being possible via either the Analytics endpoints or the other API endpoints.

If an analytic, such as average time to answer, already exists under the Q&A section, but they would want to make API calls so that this info is extracted into some sort of centralized location, is that possible through the Analytics API endpoint? Essentially, is it easier to rebuild a table like that since we already have one?

Comments

  • Unknown
    Unknown

    Does anyone want to help me take a stab at this?

  • Vanilla Forums
    Vanilla Forums

    I'm a little confused by the list above. The first half (down to "Poster/Author ") reads like meta data from a post, the second half like actual analytics graphs. Like, how do you graph 'Date'? What am I misunderstanding?

  • Unknown
    Unknown
    edited April 2018

    @Linc said:
    I'm a little confused by the list above. The first half (down to "Poster/Author ") reads like meta data from a post, the second half like actual analytics graphs. Like, how do you graph 'Date'? What am I misunderstanding?

    I think you're right, and the meta data part could very well be why they are asking for the DB export in the first place.

    I am not entirely clear how they organizing it but from what I understand they try to pull these analytics into some sort of centralized datamart on their end. If there's particular questions I could ask them that would allow us to help them I could ask those.

  • Vanilla Forums
    Vanilla Forums

    I think the latter half (graphs) should be achievable either as new charts in the Dashboard (these would be good for CAB) or as an analytics query.

    The first half all seem like things that can be retrieved from the standard API.

    I guess my question is: Have the attempted to do all these actions over our existing API and run into roadblocks? Or are they just getting dumps because it's easier than writing the script to use the API?

    Right now they are just explaining their database usage without affirming it's something they tried and failed to do otherwise, or what roadblocks they met with.

  • Unknown
    Unknown
    edited April 2018

    Date – Time stamp of online post creation.

    Item Link (or Object ID) – Object ID of post / URL to post
    Comment Summary – Text from the post
    Response Accepted Y/N (ex. Accepted Answer) – indicator/flag showing that a post's response was accepted as the correct answer
    Product Line/Category – The product name or category under which the post was created.
    Responder – Names/Screen names in the thread of those who responded to the initial post
    Poster/Author – Name/Screen name of the post's creator

    I feel like they want this for each post.

  • Unknown
    Unknown

    I am going to try and get more info. Basically, all that happened was they were asking for a database dump and I said "why do you need that" and this is what he told me. So I said maybe we can help them find a way via API so that we don't have to do that annoying DB dump every month.

Categories