Forum Discussion

Danzidpp's avatar
Danzidpp
Contributor
2 months ago
Solved

Need Help Finding Khoros API for Usage Data

Hi there,

I’m new to Khoros and trying to set up a simple dashboard to track usage data like Unique Visitors per Month, Total Visitors, Net Topics per Month, Accepted Solution Views, Page Views, and so on.

I’ve been looking around but can’t seem to find the right API endpoint or documentation for this kind of data. Any help to get this data is really appreciated!

Thanks a lot for your help!

Best,
Danzi

API
Bulk Data API
Community API
Rest API
REST API v2 & LiQL
  • CarolineS's avatar
    CarolineS
    2 months ago

    I wasn't the one who set up our integration into Tableau, but I can at least point you to the documentation.

    • Bulk API v3, for communities on Aurora: https://developer.khoros.com/khorosauroradevdocs/docs/bulk-data-api-v-30
    • Bulk API v2, for communities on Classic
      • Overview documentation (there are a few documents, which you can access via the nav on the left on this page): https://community.khoros.com/kb/khoros-communities-classic-docs/using-the-khoros-bulk-data-api/178715?guideId=guide%3A52
      • Dev docs: https://developer.khoros.com/khoroscommunitydevdocs/reference/bulk-data-api-v2

3 Replies

Sort By
  • CarolineS's avatar
    CarolineS
    Boss
    2 months ago

    I wasn't the one who set up our integration into Tableau, but I can at least point you to the documentation.

    • Bulk API v3, for communities on Aurora: https://developer.khoros.com/khorosauroradevdocs/docs/bulk-data-api-v-30
    • Bulk API v2, for communities on Classic
      • Overview documentation (there are a few documents, which you can access via the nav on the left on this page): https://community.khoros.com/kb/khoros-communities-classic-docs/using-the-khoros-bulk-data-api/178715?guideId=guide%3A52
      • Dev docs: https://developer.khoros.com/khoroscommunitydevdocs/reference/bulk-data-api-v2
  • Danzidpp's avatar
    Danzidpp
    Contributor
    2 months ago

    CarolineS,thanks for getting back to me! I'm more interested in using the Bulk API method instead of manually downloading reports. I’m basically trying to do the same thing, but in Power BI. This is my first time using Khoros, so I’d really appreciate it if you could walk me through how you did it—like which endpoint you used, any documentation you followed, or anything I should watch out for. Thanks so much for your help!

  • CarolineS's avatar
    CarolineS
    Boss
    2 months ago

    One way this can be done is to ingest the output of the Bulk Data API into a BI tool (e.g. Tableau) and create dashboards in the BI tool.

    I think the other option is to download CSVs monthly (or however often) from Community Analytics and add them to an Excel file / Google sheet where you also display pretty graphs.

    Not sure there's an API-based way to do it other than Bulk Data, but I may be wrong!