bob-mccormick

bob-mccormick  

If we use 'select count(*) from bookmarks,' it will only give the bookmarks at the current logged-in user level.

If we want all users bookmarks, we can use 'select * from bookmarks where subscriber.id = '${user.id}'.

1. Create an endpoint.
2. Get all users using the users API with cursor (recommended) or offset.
3. Then pass each user ID in the bookmarks query.
4. This endpoint will provide all the data in one place.

Hi bob-mccormick.
Yes, you are right. These are sample theoretical queries to construct community analytics metrics, to run against the data which is exported using Bulk API and stored in your SQL data store. 

I have received a larger example CSV file, bulkapi_simulated_data_xyz_community_20220418.xlsx,  that includes 39 event types, which is MUCH better than the 4 event types in the publicly available example file.