Improvement 

Destination Performance

Improvement 

We have been updating how Grouparoo works with destinations in order to be more performant and responsive to their unique needs. Here are a few recent improvements:

  • Settings for plugins to define how many threads can communicate with a destination at a time
  • Patterns for responding to reaching an API limit and dynamically reacting
  • Support for batching updates to send many profiles at a time
  • In steady-state, only communicate with desitnation if there is a change in the data
  • Hardened handling of intermittent errors from destinations
  • Improved UI to track destination exports and their progress/status

Other updates

New 

Batch Imports and Updated Dashboard

New 

We've revamped a bunch of how Grouparoo works under the hood, simplifying how our data imports work and also improving performance. As such, we've also given the Grouparoo dashboard a refresh to better explain the current state of how Grouparoo is managing your data.

Updated Grouparoo dashboard

New 

Mailchimp as a Source

New 

You can now add Mailchimp as a Source. Some of our users were asking for a way to identify users in Mailchimp using a property besides email, so now you can import users from Mailchimp into Grouparoo and identify them using any unique identifier that exists in Mailchimp. You can also pull in open rates and click rates on a profile.


New 

Grouparoo can run off of SQLite

New 

Now you can choose between SQLite and Postgres for the database system underlying Grouparoo. You can make these modifications in your environment variables by setting your DATABASE_URL to a SQLite database.

SQlite Environment Variable

Fix 

Connection Pooling

Fix 

The MySQL and Postgres have had connection sharing across background workers for a while. Every now and then, some users saw an issue where a connection was stale.

Now, these plugins connect to their respective databases with connection pools. This increases the reliability and has been seen to fix these issues.


New 

Version Notification and Reporting

New 

On the /about page, we now badge the version of your installed plugins. They will be successful (green) if your installed version matches the latest-tagged version of that package on NPM, and warning (orange) if they don't.

Versioned /about page

In this way, you can get a quick snapshot about if you are running the latest version of Grouparoo or not.

You will also get a notification automatically if you are out of date.

Version notification

New 

Snowflake Source

New 

Snowflake can now be set up as a Grouparoo source, enabling you to create profile properties from your Snowflake data warehouse.

It supports custom queries as well as a the simplified table source.

Types of Snowflake sources

New 

Salesforce Destination

New 

We have added Salesforce as a destination. You can now create Salesforce Objects from your profiles and Groups.

It is a very generic integration because many people use Salesforce in many different ways. Because of this, you can configure it however you want.

For example, you can sync your profiles to create Contacts with linked Accounts. Groups can the decide what Campaigns they are in. It will automatically keep everything up to date.

Configuring Salesforce Destination
See more
New 

Setup Assistance

New 

We have created a setup checklist in Grouparoo to help people getting things going for the first time. It walks you through creating a working sync system.

By the end of it, you'll have users on teams, a source, properties, groups, and a destination.

Grouparoo Setup Steps

We hope this helps people get off to strong start managing their customer data.


Fix 

Faster Previews

Fix 

When creating sources on larger datasets, the web page was often timing out. It turns out it was from selecting rows to show as the preview, which takes a long time in many SQL systems.

While it is nice to show a good sample of rows, it's not worth it. We updated the logic to pick the first few rows and now everything is fast again.


New 

Marketo Destination

New 

We have added Marketo as a Grouparoo destination. This means you can sync your profiles and groups to this enterprise marketing automation tool. We handle rate-limiting and other challenging things with the connection.

How Grouparoo connects to Mailchimp
See more
Improvement 

Phone Number Property

Improvement 

All profile property rules have types. Some of the existing types include string, email, integer, float, and date. We have added the phoneNumber type to Grouparoo.

Knowing the type allows Grouparoo to help ensure data validity, provide better options for filtering and group defining, as well as make smarter mappings to destinations.

As part of this, for example, we also now support setting the phone property in Zendesk.


New 

Zendesk Destination

New 

We have added Zendesk as a Grouparoo destination. One of our most popular requests, we are exciting to be helping our friends in operations get more data to support their customers.

Zendesk destination concepts

We particularly love the use case of shared group definitions between your email and support tools. Your "High Value" customer group in email can now seamlessly have their tickets routed to higher SLA Zendesk queues as well.


New 

Redshift Source and Destination

New 

We have added Redshift as both a source and a destination.

The most common usage will be as a source. You can use your Redshift data warehouse to populate profiles with properties to be used for group definitions and sent to destinations. Redhsift has two sources:

  • Query: write your own SQL
  • Table: no-code property creation

The Redshift destination, like MySQL and Postgres, allows you to write Grouparoo properties and group membership in order to leverage them in business intelligence and other tools.


New 

Grouparoo Project Generator

New 

We have provided an example Grouparoo app for a while, but now we've made it easier to generate one of these with a simple command: npx grouparoo generate

From npx grouparoo --help

Usage: grouparoo [options] [command]

Options:
  -V, --version    output the version number
  -h, --help       display help for command

Commands:
  generate [path]  generate a new Grouparoo project
  upgrade [path]   upgrade an existing Grouparoo project
  help [command]   display help for command

New 

Profile Property Arrays

New 

Previously, profile properties could only be a single value. For example, lastPurchaseCategory = "Toys".

Now sources allow you to create arrays, or lists of values. For example, purchaseCategories = ["Toys", "Sports", "Electronics"].

These can be leveraged in group definitions. In this case, you can define group membership if someone has ever purchased something in the Sports category.

Destinations that support lists will also be able to sync the full property.


Improvement 

Run Progress

Improvement 

We are now giving more information about how your data is importing via schedules and other runs. Each run can now see the percentage complete.

Create a property rule from your events

Using this, you can track how things are going.


New 

Hubspot Destination

New 

You can now connect your Grouparoo profiles and groups to Hubspot. With this destination, you can empower your sales teams on the Hubspot platform with anything from your data warehouse.

Grouparoo will make contacts with properties and add the to lists inside the Hubspot environment.

Hubspot destination concepts
See more
Improvement 

Event Stream

Improvement 

Real-time visibility into the events coming into the system is important to knowing things are working as expected. To help with that, we have added a stream and other statistics on the event system.

Grouparoo event stream

Stream away!


New 

Events

New 

This is a big update to add the concept of events. Grouparoo loves connecting to sources like data warehouses, but events (like pageviews) are still important.

Now, there is an API and a Javascript client to report pageviews and identify users. These events are saved in the Grouparoo database and linked to profiles. It's smart enough to merge profiles if it turns out the user was actually the same one.

Once you have those events, you can create a source that makes profile properties from them. For example, let's add how many page views a user has had. And another one for what they last looked at. Of course, you can use those when creating groups and syncing to destinations.

Create a property rule from your events

With events, we are excited to help you get an even picture of your customer.


New 

BigQuery Source

New 

You can now connect your BigQuery data warehouse to Grouparoo, using it as a source for your profile properties.

This implementation adds all the same features as our other SQL sources like MySQL and Postgres. For example, you can write a custom SQL query to add a property. There is also the table source that allows importing data without knowing SQL.

Two new types of sources: query and table

You can also use all the built-in datasets that Google provides. That's pretty neat.

See more
New 

Sailthru Destination

New 

We have added Sailthru as a destination. This means you can export your profile and group data to this email automation tool. One great thing to do there is to use their Lifecycle Optimizer to run campaigns when someone enters a group.

A few companies have noted that they had some challenges integrating with Sailthru nuances, so we are glad to add, iterate, and harden this plugin.

See more
Improvement 

Typeahead

Improvement 

To help fill out more fields, we've added typeaheads to several places in the user experience.

Now, when you are searching profiles or creating groups, it will use values from those profile properties to make it easier.

Also, when setting up sources and destinations, plugins can choose to provide typeahead selectors.


New 

Google Sheets Source

New 

We have added the ability to connect your Google Sheets to import data into Grouparoo. To some degree, we made Grouparoo so you don't need all these spreadsheets. And yet, sometimes it's still the best way to make things happen. Now they can become a "real" part of your data infrastructure.

Data preview of new source from Google Sheets

Don't forget: with great power comes great responsibility!

See more
Improvement 

Experience Updates

Improvement 

We updated the data model and experience to make things work better. A few of the changes:

  • Create drafts of the objects
  • Groups things together with a better UX
  • Better mapping for destinations

Thanks for the feedback!


New 

Mailchimp Destination

New 

We now support the ability to sync your profiles and groups to Mailchimp. You select the list you want to populate, the merge variables to set, and which tags should be set.

How Grouparoo connects to Mailchimp

Mailchimp has been one of the most popular destination requests from startups and we are excited for you try it out.

See more