CoolaData provides you with a real-time query API to retrieve all of the data related to a specific user, to enable you to provide customized responses on your app based on the user’s characteristics.

To retrieve all of the user’s real-time data, use the following query:

select * from RTcooladata where user_id=<internal_user_id>|customer_user_id=<customer_user_id>

To retrieve a user’s internal user ID use the property name “user_id” on queries from CoolaData.

The following table specifies all the response parameters:

userProperties{}All user scope properties as last saved (see last event timestamp for last update time)
userCreationTimestamp23-10-2015The time the first event by this user was received
lastSessionProperties{referring_domain=, is_new=1, tracker_version=2.1.12, tracker_type=javascript, session_ip=, referring_url=, session_screen_size=1440x900, session_dua=Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.71 Safari/537.36}All session scope properties sent by the user or from CoolaData's enrichment process as last saved (see last event timestamp for last update time)
lastSessionId6216554409976259594The last session's session ID (not included in lastSessionProperties)
userId6216552964336012458CoolaData's internal user ID
lastEventTimestamp7-11-2015The time the last event by this user was received
lastKnownSessionId6216554409976259594Same as lastSessionId
lastSessionTimestampN/AThe last session's start time

You can also query specific columns from this response by specifying them in the select clause.

Print Friendly, PDF & Email