> Does it have an API to access the user profile and group data ad-hoc?
We’ve seen a few approaches here. 1) Yes, there are APIs 2) The Postgres database this runs on is in your data center, so you can read it directly 3) You can write back to your own product database as a “destination”
> Can you stream data in?
We support events via an API. We’ll store the vents and allow your to create profile properties from them. I’m very interested in creating a Kafka or other message bus sort of integration too that brings in data and/or triggers recalculations. No one has needed that yet, though, so it’s just on our eventual list.
> Can it trigger a destination sync when the underlying data changes?
We have schedules, table queries, and events to know profile data has changed. When it changes, it then recalculates groups. Then properties or groups change that are being sent to a destination, it automatically exports there. “Hey Mailchimp, the user changed their first name and should now be tagged as VIP.”
> Can it do profile merging (visitor -> known customer stitching)?
We have the concept of anonymous id before login. When we realize two profiles are the same (usually after logging in from another device or something), the profiles are merged and everything recalculated.
> How can you do reporting/analytics?
This hasn’t been a focus so far outside of our ETL mechanics. You can see who has been imported and exported and with what and when and all of that.
Things get more interesting around properties and their values, but we haven’t gotten there yet. We’ve seen some success at pointing tools like Metabase at the Grouparoo database.
Redshift is available now. We've talked about S3, but were looking for input on what kind of formats to read/write. Email me or make an issue [1] with what you were hoping for.
> Does it have an API to access the user profile and group data ad-hoc?
We’ve seen a few approaches here. 1) Yes, there are APIs 2) The Postgres database this runs on is in your data center, so you can read it directly 3) You can write back to your own product database as a “destination”
> Can you stream data in?
We support events via an API. We’ll store the vents and allow your to create profile properties from them. I’m very interested in creating a Kafka or other message bus sort of integration too that brings in data and/or triggers recalculations. No one has needed that yet, though, so it’s just on our eventual list.
> Can it trigger a destination sync when the underlying data changes?
We have schedules, table queries, and events to know profile data has changed. When it changes, it then recalculates groups. Then properties or groups change that are being sent to a destination, it automatically exports there. “Hey Mailchimp, the user changed their first name and should now be tagged as VIP.”
> Can it do profile merging (visitor -> known customer stitching)?
We have the concept of anonymous id before login. When we realize two profiles are the same (usually after logging in from another device or something), the profiles are merged and everything recalculated.
> How can you do reporting/analytics?
This hasn’t been a focus so far outside of our ETL mechanics. You can see who has been imported and exported and with what and when and all of that.
Things get more interesting around properties and their values, but we haven’t gotten there yet. We’ve seen some success at pointing tools like Metabase at the Grouparoo database.