Census changelog www.getcensus.com

Census's Salesforce connector supports a powerful option: You can tell Census not to overwrite a field if there's a value already present, on a per-field basis

This is a really useful option when you want Census to let humans in those destinations to override the value. For example, let's say you have a Census sync updating Contacts in Salesforce. You want to provide a name from the database, but you know a sales rep may fix that contact's name once they get on a call. In that case, Don't Overwrite Existing is the perfect fit. Census will set the value, but won't overwrite again so any changes made will take precedence.

This has been a Salesforce only feature for almost a year but today we're excited to finally expand this to additional connections, starting with Zendesk and Intercom! Give it a shot and let us know which connector you'd like to see next!

We are happy to announce that you can now sync your warehouse data to Klaviyo so you can:

• Build more granular segments 🎯
• Send better & timely behavioral emails ⏱
• More personalized emails at scale 🤗

This connector is available on the connection page in your dashboard.

If you have any questions, don't hesitate to use the live chat or ping us at support@getcensus.com

Last week was a big week here at Census virtual HQ!

We announced our Series A funding (which is startup speak for "This just got real!"). We also announced the new Census Startup Program to give other startups access to Census when they're just starting to build out their own Modern Data Stack.

And very related to the Modern Data Stack, we also announced that we are partnering with Fivetran to help every company build theirs, even the non-startups!

So it was already a big news week. But it wasn't just the PR team working hard this week, we also snuck in a few more improvements for our lovely Census users:

• Invites can now be accepted by a different email address - This should help prevent team invites from getting dropped.
• Front Integration improvements - We've been working with the team at Front to harden our Front integration. We can also now support API keys directly instead of OAuth if you have specific permissions concerns, reach out to Census support for more details!
• Fixed the Warehouse Connection tester when used with our new SSH Tunneling support!

We now support sending Events to Mixpanel from your warehouse. This is especially useful if you clean or enrich your events data before sending them to tools like Mixpanel. Or if you use solutions such as Snowplow.

We also support sending data to User Profile to improve the reporting you can in Mixpanel, for example, building cohorts based on user Segment.

To get started, simply connect Mixpanel using the Oauth process on our connections page in your Dashboard

We now support enriching user profiles in Amplitude. This is a great way to improve Amplitude reports and insights by segmenting your users even further, using demographic, firmographic, or user attributes for example.

To get started, simply connect Amplitude by providing us with an API key in connections page in your Dashboard. 💫

We now integrate with Databricks. 🎉

You can read more on our announcement blog post or if you are eager to get started, head to the connections tab and add Databricks as a Data warehouse. It's that simple.

As always, if you have any questions, don't hesitate to use the in-app chat.

We're sneaking in one new frequently requested destination at the end of the week: NetSuite!

NetSuite has been an exciting destination for us for a while. It's our goal to help you keep customer data in sync across the entire customer journey. With today's release of the NetSuite integration, Census can keep your data in sync all the way from the ad network, through sales, marketing, product, and success, all the way to the bank!

We're excited to see what new business automation our customers set up with NetSuite in the mix. If you want to get NetSuite connected to your org, send us a note!

You can now connect to Redshift & Postgres via an SSH tunnel. When you setup a connection just check the box at the bottom of the modal to enter the information about your SSH bastion.

Once you hit Save, you'll be able to copy the generated public key and complete setup in your infrastructure.

We've got two quick improvements to Marketo destinations today.

First up, we've added support for a much wider range of Matching Keys for Update or Create syncs. You can now use the majority of standard Marketo fields as well as text and numeric custom fields as a matching key, making it a whole lot easier to configure Marketo syncs using your existing data.

And next up, you can now add Contact syncs to Static Lists in Marketo by either ID or Name. Just set it as part of the other mapped fields for the Contact.

Give these new Marketo features a try and let us know what else you'd like to see!

Across all the services Census supports, there's a variety of ways to handle "lists" of things. Today, we're taking a step forward in standardizing how we treat lists. Our aim is to make it easy for you to provide a single or multiple values and control how Census mixes them with data already in the destination.

As an example, take a look at how we now handle Zendesk Tags.

The database value you provide can be a single value, or a list (either via your Data Warehouse's native Array type or by providing a JSON formatted string representation). You can also specify exactly how Census should mix the value or values you provide with data already in the service, either adding to it or replacing it completely. Note that note all services are as flexible as Zendesk in this case, but we'll always let you know what will happen either way.

We're slowly rolling this out across all our services that support lists so keep an eye out for an array coming to your favorite destination soon!