Grouparoo can now import data from MongoDB!
@grouparoo/mongo plugin can be added to your project to import Profiles and Properties from your MongoDB application database. MongoDB is the first NoSQL database supported by Grouparoo, and all of the same Source features available for relational databases are available for MongoDB - including aggregation Properties, query Properties, and scheduled imports.
Learn how to install plugins by visiting the Grouparoo documentation.
Grouparoo has launched a new section in our documentation: Tutorials!
This new section will be focused on providing you with real-world, step-by-step examples that you can follow to become more familiar with Grouparoo.
We currently have a single tutorial on Declarative Sync, which walks through a basic e-commerce example that syncs data between a SQLite product database Source and Mailchimp as the Destination.
SQLite is a lightweight database that holds its data in a single
.sqlite file on disk. Up until now, Grouparoo has supported SQLite as its application database, but not as a Source or Destination for your customer data.
This new plugin will make it easier to get up and running with real-world examples, as we'll demonstrate in future tutorials and blog posts. Stay tuned!
The Grouparoo UI packages,
@grouparoo/ui-enterprise now install faster and require fewer dependencies on your machines!
npm install, you were also building the webpack bundle. Now, we do this all for you on our build servers. This leads to larger download sizes, but a faster overall install experience as there is no "build" step. Under the hood, we rely on next.js to build and package our UIs.
There are many variations of things that could go "wrong" when working with the many destinations that Grouparoo supports. For example, there a recoverable errors like rate limiting. However, there is sometimes expected behavior that is still interesting to note. For these cases, we have added an
info error level.
For example, the Salesforce destination has an "Enrich" mode. This means that it should only update users that are already in the system. In these cases, the plugin returns an
info error. This is useful for observability in that it helps the user debug what happened.
Facebook custom audiences can now be a Grouparoo destination. This means that you can sync your customer information to Facebook in order to target ads or exclude them from campaigns.
A common use case is to automate teaching Facebook about your high-value users. This custom audience can be then used to create a lookalike audience for similar users.
Grouparoo now allows users of a Query Source (Postgres, MySQL, Redshift, BigQuery, etc) to provide a custom query to determine which profiles to import. Just provide the query that returns the Profiles to be updated, and let Grouparoo know which Property the query refers to.
SELECT id FROM users would work, and all Profiles would be updated. However, you can often be smarter with your Schedule to keep things fast. For example, if your custom query to calculate LTV would only update when a purchase is made, you might
SELECT DISTINCT(user_id) FROM purchases where MAX(created_at) > (NOW() - interval 2 day) GROUP BY user_id to only re-import Profiles which have had a recent purchase.
We have added Sendgrid as a destination. Sendgrid is a very popular transactional email tool in the developer community, and they're starting to build more CRM-esque features into their offering. Our integration allows you to easily connect your product database (Postgres, MySQL) or data warehouse (Snowflake) to Sendgrid with just a few clicks or lines of code.
These templates are then read and processed by Grouparoo when the server starts. This makes it trivial to import and export data from your various data sources and destinations by just writing a few lines of JSON.
You can work the way you are already working. You check your config files into Git. And you can even run tests to ensure your data is moving around as you'd expect.
We have added Iterable as a destination. You can now create Iterable Users and Lists dynamically with Grouparoo. Iterable is one of the more popular marketing automation tools out there, so we're excited to be able to help our users connect with Iterable.