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

Aurora: Visits by User Type

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

Unique Visitors via API

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

Querying registration and visit dates and from Community API v2

Recent Discussions

Boosting a User

Google Tag Manager and Google Analytics Setup in Aurora platform

In Aurora, add additional <script> and <meta> tags

Incremental data for attachments in messages and replies

Incremental data for users data