Get visits and unique visitors from Bulk API

Question

Hi all,I'm using the Lithium Bulk Data API (documented here:&nbsp;https://lithosphere.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=bulkdata) to extract metrics about our community. However, some of the metrics that I'm looking to extract do not match up with the results I'm seeing in LSI.E.g. "visits" and "unique visitors" in LSI do not match the numbers that I'm getting from the Bulk API.To get visits from the Bulk API I've used the following filtering conditions:&nbsp; ['action.key']=='view' and counted distinct 'visitor.id's.Does anyone know how to get visits and unique visitors from the Bulk API to match what's in LSI?Thanks!

damiani · Answer

Hello Carl,
Our DATA team provided the details around how to calculate these two metrics using Bulk Data API:&nbsp;Unique Visitors:&nbsp;In LSI, we are using HyperLogLog++ (HLL++) approximation algorithm, to calculate UniqueVisitors. To replicate it using Bulk Data API, you've to filter out "action.key=view" and apply HLL on "visitor.id"; This implementation is available in ElasticSearch.&nbsp;Visitors:&nbsp;In LSI, we are counting visits by using "action.key=view" and unique count of "visit.id". This implementation is available in ElasticSearch.&nbsp;Please, let us know if you need any further clarification.&nbsp;
Kind regards,Damian

dileepk · Answer

DamianI&nbsp; &nbsp;&nbsp;action.key=view&nbsp; &nbsp;its not working for me. I need a number of visit count.&nbsp; This is my API call&nbsp;https://api.lithium.com/lsi-data/v1/data/export/community/**********?fromDate=201908291205&amp;toDate=201908301205&amp;fields=community_app,action.is_solution_view,action.span.seconds,labels,message.type,tags,visitor.id,action.key=viewBut i did not get the number of visit count . Also you can check the Response&nbsp;Kind Regards:Dileep&nbsp;

Forum Discussion

Get visits and unique visitors from Bulk API

Related Content

how to get #visits & #unique visitors thru API ?

Unique Visitors via API

Best practice for Visitor Landing Page? (hiding components for anonymous users)

Khoros Cookies Datasheet (Community, Care, Marketing, Khoros Bot)

Querying registration and visit dates and from Community API v2

Recent Discussions

API v1 docs gone since Atlas migration to Aurora

Does anyone know how to change the display title of Custom Fields in Aurora?

Can someone walk me through authenticating and using Postman with Aurora?

Seeking Advice on Restricting Access to a posts to those who have the permalink.

TinyMceEditor is undefined