Post Approved

This message has been approved and is visible within the community.

Forum Discussion

Anonymous's avatar
Anonymous
12 years ago

REST API vs Admin Metrics discrepancy

Hi,   We were trying to use REST API for retrieving metrics rather than using Advanced Metrics because it's too troublesome when it involves multiple forum boards metrics. However, we notice the...
JakeR's avatar
JakeR
Khoros Alumni (Retired)
12 years ago

I would hazard a guess that it is a difference in time settings between the account pulling the metrics and the default time settings for your community. 

 

If you are making server-side calls, you may want to check the time on your machine making the calls.  If you are making client-side calls, check your time settings on your machine (or your team member's machine).

 

You can refer to this thread for more info (it may be helpful): http://lithosphere.lithium.com/t5/developers-discussion/Difference-in-Metrics/m-p/43936/highlight/true#M1226

 

You can also refer to a section within this TKB article that says the following: http://lithosphere.lithium.com/t5/support-knowledge-base/Using-Lithium-Metrics/ta-p/39756

 

The metrics panel mentions that the data is based off of my profile time zone. What does this mean? - This means that the data you see will reflect what you have set in your profile. In other words, if your profile is set to use the Pacific time zone (GMT-8) then you will see different information than someone who is using the Eastern time zone (GMT-5). If you both ran a report for 3/01/2012 you may see different data. For the Eastern time user, they would see data from 12 am Eastern to 12 am Eastern, which is 9 pm to 9 pm in the Pacific time zone, while the Pacific user would see 12 am Pacific to 12 am Pacific, which is 3 am to 3 am Eastern. As you can imagine, this would lead to some discrepancies. Fortunately, you can easily update your profile to match others if needed by navigating to My Settings -> Preferences -> Preferences Options -> Update your time zone and save changes.

 

 

Anonymous's avatar
Anonymous
12 years ago

Hi Jake,

Thanks for looking into this and also the links you provided.

As the REST API server is based on UTC timezone, and my profile was based on PST, thus I've changed it to GTM UK ( which is also +0000 UTC).

But the data I got are still differrent.

REST API gave me 2597 net topics for 1-28 Feb.
Advanced Metrics gave me 2682 though.

Am i missing anything here?

  • Anonymous's avatar
    Anonymous
    12 years ago
    Anyone can help ?
    • YuriK's avatar
      YuriK
      Khoros Alumni (Retired)
      12 years ago
      Hey Cleolee,

      The rest API supports ISO 8601 format. To make sure you're not having time zone issues, you should specify the offset in the API call. (something like
      2012-07-16T19:20+01:00) (http://www.w3.org/TR/NOTE-datetime)

      Also you could have some issues with Daylight savings time which you would need to account for.

      Hope this helps,

      Yuri
      • kvyvial's avatar
        kvyvial
        Contributor
        12 years ago

        Hi,

         

        I am having the same issue. I have tried setting my time zone in the API query but I still see a discrepancy. Am I setting the properties correctly?

         

        Community User Time Zone: Central (GMT-6) - It's CDT right now so I used -5 instead.

        Knowledge Base Article Views Metric (from dashboard): 828

        Knowledge Base Article Views Metric (from Rest API): 695

         

        API Query Sample

        http://community.companyname.com/communityname/restapi/vc/boards/id/MyCommunity_TKB/metrics/name/tkb_article_views?date_start=2013-07-08T05:00:00-05:00&date_end=2013-07-14T04:59:59-05:00

         

        I have also tried changing my user settings in community to use GMT time and I still see a discrepancy.

         

        Thanks,

        Kate