Use data studio to create datasets that power revenue reports -- without needing to sync all your revenue data to HubSpot CRM records. 

Steps

1. Create an external data source to pull data from your revenue system into data studio. Data studio connects  with common systems like Stripe, NetSuite, and QuickBooks.
2. Create a dataset starting with contacts data and add the revenue data as a secondary source.
3. Add the calculations you will need in your report, such as customer lifetime value or overdue invoices. You can create the formulas yourself or ask AI to help.
4. Save the dataset and choose Use in > Report.

Combine behavioral data from multiple sources with CRM data for more precise targeting. For example, use in-person event registrations stored in Airtable to produce a targeted segment of only contacts who have attended at least one event.

Steps

1. Create an external data source for each source of engagement data, such as the Airtable table.
2. Create a dataset starting with contacts data and then add all of the secondary sources.
3. Add columns to your dataset summarizing the signals, such as count of events attended.
4. Apply filters to reduce the list to only engaged contacts.
5. Save the dataset and choose Use in > Segment to create a segment.

Use data studio to build custom automation without needing to manage integrations, spreadsheets, or CRM properties. For example, create a personalized email campaign based on product usage data stored in Snowflake.

Steps

1. Create an external data source for the Snowflake table where usage data is aggregated by customer email address.
2. Create a dataset starting with contacts data and add the Snowflake data as a secondary source.
3. Add any columns from Snowflake or formulas you will want to use in your workflow. For example, you might categorize users by "High", "Medium" or "Low" usage of your product.
4. Save the dataset and choose Use in > Workflow to start building out your workflow. Inside workflows, columns from the workflow can be accessed from within workflow actions or branches.

Use data studio to connect and combine data from any source that integrates with Google Sheets. For example, if you use an app that has a Google Sheets integration but doesn't have a HubSpot integration, you can use data studio to connect the data. When the sheet updates, data studio will automatically update with the refreshed data.

Steps

1. Create an external data source for the Google sheet.
2. Create a dataset and select your sheet.
3. Select columns to include.
4. Save the dataset and choose Sync to CRM.
5. Select whether you want to sync the data once or on a scheduled basis, then map columns from the dataset to CRM objects to finish creating the sync.

Use subscription data to inform sales teams of upsell or cross-sell opportunities, provide a 360-degree view to success teams, and help marketing teams create nurture campaigns.

Steps

1. Create an external data source for Recurly.
2. Create a dataset starting with company data.
3. Add subscription data as a secondary source.
4. Select columns to include.
5. Save the dataset and choose Sync to CRM.
6. Map your dataset data to a custom object (for example, product subscriptions). Once the sync processes, this data will be available throughout HubSpot.

Connect your external data sources (apps or sheets) to data studio and combine with HubSpot contacts and deals to create a dataset. Use formula builder to transform dataset fields before activating the dataset in reporting or sync these transformed fields to CRM.

Connect to S3 bucket, Snowflake or BigQuery and sync data to data studio. Create datasets to explore the tables and files from these sources or combine them with HubSpot data sources to provide marketing and sales access to insights.

Connect Stripe and sync subscription data to data studio. Create a dataset to combine HubSpot contacts and with Stripe subscriptions. Filter this dataset to get contacts that are on certain subscription plans (Stripe data).

Activate the dataset to create a segment and enroll the contacts in a marketing campaign via workflow branching on subscription plans to showcase value in that tier.

Connect your external data source and create a dataset combining HubSpot contacts and HubSpot companies with the external data. Create a new smart column and use the Data Agent's web research.

For example, use the prompt:

Is this company hiring, and if so which roles are they hiring for?

Scale and streamline your customer renewal processes by having HubSpot CRM automatically create a renewal deal when a previous deal is closed. This code snippet will create a new deal with a new close date, deal amount, and deal discount, and associate the deal to company whose deal was just closed.

If you're creating a lot of new deal objects in HubSpot, you probably understand the pain of always having to manually remove the "– New Deal" from the title. Luckily, with this code snippet a custom code actions can do that for you whenever a new deal is created. Simply enroll newly created deals, and if the title includes "– New Deal", the workflow will promptly remove it.

Global organizations that get their leads from multiple international sources, know how hard it is to report and analyze data populated in different languages. Through this code snippet, you can leverage the translation service DeepL and build a workflow that automatically translates the contact properties of your choice. The result? A unified database for anyone.

If your company has different portals for different teams, you know how hard it is to maintain that source of truth, while ensuring that each team has the right data to work with. With this code snippet, you can create a workflow that automatically syncs newly created contact from your central portal to another in one direction. That way your source of truth stays intact, while your team's data is always up to date.

If you're looking to optimize and automate the lead assignment for a sales team that covers many territories, then this code snippet might help. Firstly, build a HubDB table and use it to store your territory management logic (e.g. postal code X is covered by owner Y). Then create a custom code action and paste the code snippet. For any newly created lead, it will take the postal code as input, and reference the HubDB table to assign it with the right owner.

This custom code action can be used to trigger a web push notification for a specific contact on a web browser. It does so by leveraging Firebase Cloud Messaging, which is a service offered by Google to let you relay server messages to registered devices and web apps

Often when you collect/store phone numbers in your database, you will find that they may be inconsistent and not formatted in the correct manner. This code snippet can be used to automatically format phone numbers into an international format that includes the international dial code prefix with your workflow.

Ever wanted to automatically delete (or archive) some contact records? With this code snippet you can make your workflow delete any record that is enrolled. Whether those are unwanted records that were created by an integration or spam contacts that have bounced.

You may have found that when you're manually associating a contact to a company, their deals don't automatically go with them. With this code snippet, you can make sure that all of your contact's deals are automatically associated with their company too. Note: this code action will only associate the first 500 deals because it doesn't paginate the API response of all known deals associated with the contact.

When a deal is marked closed-won or lost, there likely are still some unresolved tasks that need to be completed manually. HubSpot can already automatically generate tasks when a deal is opened, and with this code snippet, it can automatically complete tasks when a deal is closed.

Having standardized phone numbers in your CRM can be a real must for your customer-facing team members. But not only will the increased readability improve the efficiency of your teams, it'll also improve the operations of your systems. Data inconsistencies can create duplicates, break integrations or hamper reporting. With this custom code action, you can make sure that any 10-digit U.S. phone number is properly formatted as (XXX) XXX-XXXX, making your phone number easily readable and dependable.

As opposed to having an evenly distributed lead assignment among your sales team members, you can use this code action to assign your leads in a weighted fashion. With this action you can decide what percentage of leads should go to each one of your sales reps, which is ideal when you have some high performing reps that you want to assign more leads to, or if you have new reps that are still ramping up.

One common issue you'll find when trying to keep your data clean is multiple contact records that reference the same contact. Annoying, right? With this code action, you can catch and merge duplicate contact records to create one singular record for every contact in your CRM.