In the steps below, we’ll assign the right value to each of these components, using customer names as our unique identifier to find the MRR of each customer.
For your reference, here’s what a VLOOKUP function looks like: VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) That’s where the VLOOKUP function comes in. And while you could manually look up each and every contact in your CRM to find their MRR, and then manually match those values to their corresponding contacts in your HubSpot data, the whole process would be ridiculously time-consuming and impractical. There’s only one problem: Your MRR data lives in your CRM. That way, you can tie your revenue back to your site pages and do some analysis to see which pages are having the biggest impact on your bottom line. Then it hits you: In addition to knowing which of those contacts have closed, you want to know how much MRR (monthly recurring revenue) each of them brings in. You’re also paying attention to whether or not any of those contacts have converted into customers. Let’s say you’re looking through your HubSpot data and are checking out which of your site pages your contacts have viewed. Since HubSpot and most CRMs both use email addresses to uniquely identify the contacts in their databases, HubSpot customers can use “email address” as their unique identifier to execute a VLOOKUP. Unique identifiers include product codes, stock keeping units (SKUs), and customer contacts. the identifier is only associated with one record in your database). The secret to how VLOOKUP works? Unique identifiers.Ī unique identifier is a piece of information that both of your data sources share, and - as its name implies - it is unique (i.e. In practical terms, this means you can take the revenue data from your second spreadsheet and integrate it with the customer data in your first spreadsheet in order to reveal the bigger picture about your business’s performance.īelow, you’ll see a five-step guide to performing this VLOOKUP example, followed by a video tutorial for using VLOOKUP to organize a list of blog posts. In this example, VLOOKUP enables you to easily see revenue by customer without searching, copying, and pasting for each individual cell.
You could use the VLOOKUP formula to transfer revenue data from a separate spreadsheet and match it with the appropriate customer based on a common identifier like customer ID or email address.
0 kommentar(er)
