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, a...
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
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!

 

  • 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

      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