# Data

**URL:** https://community.hubspot.com/c/revops-data-hub/64.md?page=25

[Latest](https://community.hubspot.com/latest.md) · [Categories](https://community.hubspot.com/categories.md) · [Tags](https://community.hubspot.com/tags.md)

**Page:** 26

---

## [Get Your Free Copy of The Marketing Ops Playbook](https://community.hubspot.com/t/get-your-free-copy-of-the-marketing-ops-playbook/44211)

<div class="topic-metadata">

**Author:** [@jbogaert](https://community.hubspot.com/u/jbogaert)\
**Replies:** 3\
**Last updated:** [February 29, 2024, 1:49am UTC](https://community.hubspot.com/t/get-your-free-copy-of-the-marketing-ops-playbook/44211 "2024-02-29T01:49:51Z")

</div>

Hi everyone! The Marketing Ops Playbook is temporarily made available for FREE. Get your free copy here Here’s a little bit more information about the Marketing Ops Playbook: The Marketing Operations Playbook is me…

---

## [Conferences management](https://community.hubspot.com/t/conferences-management/99956)

<div class="topic-metadata">

**Author:** [@IZabarsky](https://community.hubspot.com/u/IZabarsky)\
**Replies:** 3\
**Last updated:** [February 27, 2024, 6:10pm UTC](https://community.hubspot.com/t/conferences-management/99956 "2024-02-27T18:10:04Z")

</div>

Hi, I want to start tracking our conferences inside HubSpot - to fill and analyze how many leads came from this conference and if some leads converted to deals, How many participants from our company (user) were at the…

---

## [Line Items Billing](https://community.hubspot.com/t/line-items-billing/100805)

<div class="topic-metadata">

**Author:** [@TeamRapp](https://community.hubspot.com/u/TeamRapp)\
**Replies:** 2\
**Last updated:** [February 26, 2024, 9:53pm UTC](https://community.hubspot.com/t/line-items-billing/100805 "2024-02-26T21:53:56Z")

</div>

Is there is a way to setup weekly billing with line items? If not, are there any suggestions on ways anyone has setup this for client’s who are wanting to do weekly billing? Thanks!

---

## [track the average follow up rate](https://community.hubspot.com/t/track-the-average-follow-up-rate/100770)

<div class="topic-metadata">

**Author:** [@CDiVincenzo](https://community.hubspot.com/u/CDiVincenzo)\
**Replies:** 2\
**Last updated:** [February 23, 2024, 12:56pm UTC](https://community.hubspot.com/t/track-the-average-follow-up-rate/100770 "2024-02-23T12:56:37Z")

</div>

Hey RevOps folks!!! A question for you: how do you track the average follow up rate? We want to track how long it takes for AEs to follow up with prospects in every deal stage, and how many touches they do. In this ca…

---

## [A way to complete deal properties based on company properties?](https://community.hubspot.com/t/a-way-to-complete-deal-properties-based-on-company-properties/100702)

<div class="topic-metadata">

**Author:** [@BLaverack9](https://community.hubspot.com/u/BLaverack9)\
**Replies:** 4\
**Last updated:** [February 22, 2024, 12:37pm UTC](https://community.hubspot.com/t/a-way-to-complete-deal-properties-based-on-company-properties/100702 "2024-02-22T12:37:28Z")

</div>

Hello! Essentially currently certain information our Ops team need to onboard deals (e.g. specific systems the company uses) are stored on a Company. I’d really like the information to also be available within a deal s…

---

## [Importing contact info for first time](https://community.hubspot.com/t/importing-contact-info-for-first-time/100673)

<div class="topic-metadata">

**Author:** [@Paddle\_LLC](https://community.hubspot.com/u/Paddle_LLC)\
**Replies:** 2\
**Last updated:** [February 21, 2024, 4:32pm UTC](https://community.hubspot.com/t/importing-contact-info-for-first-time/100673 "2024-02-21T16:32:11Z")

</div>

I am importing contact info from an excel cvs worksheet to HS. It appears that any contact properties that are NOT in HS yet have to be set up BEFORE I import and then must be manually mapped. Is there not a way to have …

---

## [Can I create workflows to send emails to Users (not Contacts)?](https://community.hubspot.com/t/can-i-create-workflows-to-send-emails-to-users-not-contacts/46097)

<div class="topic-metadata">

**Author:** [@MBooker](https://community.hubspot.com/u/MBooker)\
**Replies:** 3\
**Last updated:** [February 20, 2024, 12:14pm UTC](https://community.hubspot.com/t/can-i-create-workflows-to-send-emails-to-users-not-contacts/46097 "2024-02-20T12:14:20Z")

</div>

Good morning, Friends! We are in the process of creating many new and exciting changes in our HubSpot envirnment, and would like the ability to send emails to our affected Users from within HubSpot itself. For example -…

---

## [Format data issue when trying to add 1 business day](https://community.hubspot.com/t/format-data-issue-when-trying-to-add-1-business-day/80626)

<div class="topic-metadata">

**Author:** [@CSic](https://community.hubspot.com/u/CSic)\
**Replies:** 4\
**Last updated:** [February 20, 2024, 11:38am UTC](https://community.hubspot.com/t/format-data-issue-when-trying-to-add-1-business-day/80626 "2024-02-20T11:38:17Z")

</div>

I wanted to see if anyone has found a resolution for format data function in workflows, using add time to a date property, where the date property is set to M-F only? We have full enterprise account. Ex: My workflow se…

---

## [How to Use Automation to Keep a Tight Sales Pipeline](https://community.hubspot.com/t/how-to-use-automation-to-keep-a-tight-sales-pipeline/36913)

<div class="topic-metadata">

**Author:** [@aromo](https://community.hubspot.com/u/aromo)\
**Replies:** 1\
**Last updated:** [February 19, 2024, 2:35pm UTC](https://community.hubspot.com/t/how-to-use-automation-to-keep-a-tight-sales-pipeline/36913 "2024-02-19T14:35:50Z")

</div>

Keeping a tight sales pipeline is important. An ideal case scenario in all sales funnels is one in which we know where our prospects stand in every step of our sales process so that we have a clear picture of where our …

---

## [Why the Contact Owner Property does not sync one way](https://community.hubspot.com/t/why-the-contact-owner-property-does-not-sync-one-way/100405)

<div class="topic-metadata">

**Author:** [@rulpats](https://community.hubspot.com/u/rulpats)\
**Replies:** 1\
**Last updated:** [February 19, 2024, 7:23am UTC](https://community.hubspot.com/t/why-the-contact-owner-property-does-not-sync-one-way/100405 "2024-02-19T07:23:52Z")

</div>

I plan to sync the ‘contact owner’ field for the first time with SFDC. I don’t want Hubspot to overwrite the Salesforce owner value. But I see only a ‘two-way’ sync rule available for this property. The 'Prefer Salesforc…

---

## [Why does it take so long to sync contacts from Hubspot to another app?](https://community.hubspot.com/t/why-does-it-take-so-long-to-sync-contacts-from-hubspot-to-another-app/100345)

<div class="topic-metadata">

**Author:** [@PBellemare](https://community.hubspot.com/u/PBellemare)\
**Replies:** 2\
**Last updated:** [February 18, 2024, 12:26pm UTC](https://community.hubspot.com/t/why-does-it-take-so-long-to-sync-contacts-from-hubspot-to-another-app/100345 "2024-02-18T12:26:24Z")

</div>

Why does it take so long to sync contacts from Hubspot to another app? It’s been almost an hour since I started the synchronization and still no contacts have been transferred. I see the 3 roulettes turning as if the tra…

---

## [Difficulty reporting historical MQL numbers since 'Became MQL date' is dynamic!](https://community.hubspot.com/t/difficulty-reporting-historical-mql-numbers-since-became-mql-date-is-dynamic/55826)

<div class="topic-metadata">

**Author:** [@SJoshi94](https://community.hubspot.com/u/SJoshi94)\
**Replies:** 2\
**Last updated:** [February 16, 2024, 7:25am UTC](https://community.hubspot.com/t/difficulty-reporting-historical-mql-numbers-since-became-mql-date-is-dynamic/55826 "2024-02-16T07:25:01Z")

</div>

Background: Every time someone downloads a BOFU form (Request a demo, pricing etc) on our website we MQL them (lifecycle stage = MQL) and assign them to our sales team. Concern: ‘Became a MQL date’ is a dynamic field …

---

## [How should I track med operations at my clinic?](https://community.hubspot.com/t/how-should-i-track-med-operations-at-my-clinic/100238)

<div class="topic-metadata">

**Author:** [@AUlusan](https://community.hubspot.com/u/AUlusan)\
**Replies:** 5\
**Last updated:** [February 15, 2024, 1:15pm UTC](https://community.hubspot.com/t/how-should-i-track-med-operations-at-my-clinic/100238 "2024-02-15T13:15:08Z")

</div>

So I have been using hubspot for my clinic to store customer data, track sales and etc… recently I wanted to track each customer’s each session at the clinic. For example, sometimes the deal won includes 5 sessions of a …

---

## [Consolidated notification email to contact owners](https://community.hubspot.com/t/consolidated-notification-email-to-contact-owners/99945)

<div class="topic-metadata">

**Author:** [@PAtlan](https://community.hubspot.com/u/PAtlan)\
**Replies:** 4\
**Last updated:** [February 14, 2024, 10:30am UTC](https://community.hubspot.com/t/consolidated-notification-email-to-contact-owners/99945 "2024-02-14T10:30:23Z")

</div>

Hi, In my contact onboarding process, i want to notify users that they have been attributed a new contact. I can’t use the generic notification mechanism because this only concerns a subset of my contacts (i.e. they ha…

---

## [ConnectWise and Hubspot Contacts Integration](https://community.hubspot.com/t/connectwise-and-hubspot-contacts-integration/62079)

<div class="topic-metadata">

**Author:** [@waj](https://community.hubspot.com/u/waj)\
**Replies:** 1\
**Last updated:** [February 14, 2024, 9:23am UTC](https://community.hubspot.com/t/connectwise-and-hubspot-contacts-integration/62079 "2024-02-14T09:23:03Z")

</div>

Hi, I am trying to sync contacts from ConnectWise to Hubspot via the connectwise manage app. There is only one sync filter that can be applied on the connectwise and I am unable to get the right number of contacts to s…

---

## [Default Leads object automation](https://community.hubspot.com/t/default-leads-object-automation/100072)

<div class="topic-metadata">

**Author:** [@Becky238](https://community.hubspot.com/u/Becky238)\
**Replies:** 4\
**Last updated:** [February 13, 2024, 5:21pm UTC](https://community.hubspot.com/t/default-leads-object-automation/100072 "2024-02-13T17:21:16Z")

</div>

There is a default automation in the Leads object that moves a contact to a specific Lead stage when an email is sent to them. In our case, when a contact comes in, an initial ICP check is done and if they don’t pass it,…

---

## [Create a list](https://community.hubspot.com/t/create-a-list/100051)

<div class="topic-metadata">

**Author:** [@LGoler](https://community.hubspot.com/u/LGoler)\
**Replies:** 1\
**Last updated:** [February 13, 2024, 2:20pm UTC](https://community.hubspot.com/t/create-a-list/100051 "2024-02-13T14:20:37Z")

</div>

I’m trying to do a data enrichment project and need to create a list of companies/contacts within our ICP (Tiers 1&2) where the contact has no title shown. Can someone tell me the steps to take to create the list? Thank …

---

## [Regex\_replace to format phone numbers](https://community.hubspot.com/t/regex-replace-to-format-phone-numbers/93717)

<div class="topic-metadata">

**Author:** [@EmmaAtKiwi](https://community.hubspot.com/u/EmmaAtKiwi)\
**Replies:** 14\
**Last updated:** [February 13, 2024, 7:08am UTC](https://community.hubspot.com/t/regex-replace-to-format-phone-numbers/93717 "2024-02-13T07:08:45Z")

</div>

Hi! Maybe you’ll know the answer to this Ops Hub question @karstenkoehler… I want to format contact phone numbers from 8004567890 or 18004567890 to +1 (800) 456-7890. I created a workflow and added the Format Data step…

---

## [Became a late stage negotiating state](https://community.hubspot.com/t/became-a-late-stage-negotiating-state/99953)

<div class="topic-metadata">

**Author:** [@rulpats](https://community.hubspot.com/u/rulpats)\
**Replies:** 5\
**Last updated:** [February 12, 2024, 3:28pm UTC](https://community.hubspot.com/t/became-a-late-stage-negotiating-state/99953 "2024-02-12T15:28:02Z")

</div>

We have created custom additional value for the “lifecycle stage” which is “late stage negotiating.” I want to create a date field that updates like other stages. It will get populated when the field gets updated and get…

---

## [Hubspot emails sent with from Owner (Salesforce Integration User)](https://community.hubspot.com/t/hubspot-emails-sent-with-from-owner-salesforce-integration-user/99696)

<div class="topic-metadata">

**Author:** [@ckokayi](https://community.hubspot.com/u/ckokayi)\
**Replies:** 7\
**Last updated:** [February 9, 2024, 11:12am UTC](https://community.hubspot.com/t/hubspot-emails-sent-with-from-owner-salesforce-integration-user/99696 "2024-02-09T11:12:40Z")

</div>

For Contacts records that are being synched to SF, The record owner is set to the SF Integration user. Thus when a marketing email is sent out it has the from address as SF Integration User - so the user is seeing the em…

---

## [Increasing number field by 1 with Custom Code](https://community.hubspot.com/t/increasing-number-field-by-1-with-custom-code/99474)

<div class="topic-metadata">

**Author:** [@ABrandt](https://community.hubspot.com/u/ABrandt)\
**Replies:** 4\
**Last updated:** [February 8, 2024, 6:33pm UTC](https://community.hubspot.com/t/increasing-number-field-by-1-with-custom-code/99474 "2024-02-08T18:33:39Z")

</div>

Hello Community, I’m making a workaround in order to be able to count the number marketing emails delivered but after a certain condition/date. Since the native HubSpot field Number of marketing emails delivered is a n…

---

## [Q&A Follow-Up | Becoming a HubSpot Admin: The 5 Stages of the HubSpot Admin](https://community.hubspot.com/t/q-a-follow-up-becoming-a-hubspot-admin-the-5-stages-of-the-hubspot-admin/52628)

<div class="topic-metadata">

**Author:** [@MattBolian](https://community.hubspot.com/u/MattBolian)\
**Replies:** 1\
**Last updated:** [February 2, 2024, 1:31am UTC](https://community.hubspot.com/t/q-a-follow-up-becoming-a-hubspot-admin-the-5-stages-of-the-hubspot-admin/52628 "2024-02-02T01:31:50Z")

</div>

Hi y’all, Thanks everyone for attending the new live event series called Becoming a HubSpot Admin. It was a BLAST and I loved the energy coming off the chat. We couldn’t get to all of your questions during the Q&A and …

---

## [Custom Behavioral Events in Workflows](https://community.hubspot.com/t/custom-behavioral-events-in-workflows/99049)

<div class="topic-metadata">

**Author:** [@MHarp](https://community.hubspot.com/u/MHarp)\
**Replies:** 3\
**Last updated:** [January 31, 2024, 10:21pm UTC](https://community.hubspot.com/t/custom-behavioral-events-in-workflows/99049 "2024-01-31T22:21:34Z")

</div>

We created a custom behavioral event called “Attended Event” to report transfer Zoom Meeting attendance records into Hubspot so we could report on our customer’s attendance within their weekly groups. For the most part, …

---

## [Custom code error](https://community.hubspot.com/t/custom-code-error/98093)

<div class="topic-metadata">

**Author:** [@rulpats](https://community.hubspot.com/u/rulpats)\
**Replies:** 2\
**Last updated:** [January 30, 2024, 11:56am UTC](https://community.hubspot.com/t/custom-code-error/98093 "2024-01-30T11:56:27Z")

</div>

I get a custom code error whenever a sync between Hubspot and SF occurs. Could you explain why this happens and what exactly needs to be done by the SFDC admin team to resolve this? To be specific I could drill down th…

---

## [Hubspot Netsuite Sync Connector no Custom Fields](https://community.hubspot.com/t/hubspot-netsuite-sync-connector-no-custom-fields/77743)

<div class="topic-metadata">

**Author:** [@nate\_skyline](https://community.hubspot.com/u/nate_skyline)\
**Replies:** 12\
**Last updated:** [January 29, 2024, 7:40pm UTC](https://community.hubspot.com/t/hubspot-netsuite-sync-connector-no-custom-fields/77743 "2024-01-29T19:40:00Z")

</div>

Hi there, So I’ve been having a back and forth with Hubspot support about a week or two now. We’ve been discussing the Netsuite integration app in Hubspot and we’re not able to get custom fields from Netsuite to show up…

---

## [Tracking multiple zoom registrations after a date](https://community.hubspot.com/t/tracking-multiple-zoom-registrations-after-a-date/98816)

<div class="topic-metadata">

**Author:** [@rulpats](https://community.hubspot.com/u/rulpats)\
**Replies:** 2\
**Last updated:** [January 27, 2024, 5:31pm UTC](https://community.hubspot.com/t/tracking-multiple-zoom-registrations-after-a-date/98816 "2024-01-27T17:31:17Z")

</div>

Hi team, I am trying to get a list of names where I could find the number of webinars attended equals 2 after a particular date (Nov 1). So I am using AND filter to combine both. The issue is the Zoom webinar occurred …

---

## [Opportunity Stage field in SF](https://community.hubspot.com/t/opportunity-stage-field-in-sf/98455)

<div class="topic-metadata">

**Author:** [@rulpats](https://community.hubspot.com/u/rulpats)\
**Replies:** 6\
**Last updated:** [January 26, 2024, 6:32pm UTC](https://community.hubspot.com/t/opportunity-stage-field-in-sf/98455 "2024-01-26T18:32:42Z")

</div>

We have one field named as ‘opportunity stage’ in Hubspot. I could not see its mapping with SF. I was wondering if this is a default property and how does it work. It is updating as per the opportunity stage in SF. Th…

---

## [Inactive NetSuite Items Synced to HubSpot](https://community.hubspot.com/t/inactive-netsuite-items-synced-to-hubspot/98653)

<div class="topic-metadata">

**Author:** [@dlapointeus](https://community.hubspot.com/u/dlapointeus)\
**Replies:** 1\
**Last updated:** [January 25, 2024, 11:05pm UTC](https://community.hubspot.com/t/inactive-netsuite-items-synced-to-hubspot/98653 "2024-01-25T23:05:15Z")

</div>

Hi - we are troubleshooting a data sync integration with NetSuite. We currently have 2 issues. The first is that we are seeing quite a few sales orders failing. When looking at this closer, it looks like the product sync…

---

## [Custom code in Workflow to calculate number of emails?](https://community.hubspot.com/t/custom-code-in-workflow-to-calculate-number-of-emails/98552)

<div class="topic-metadata">

**Author:** [@ABrandt](https://community.hubspot.com/u/ABrandt)\
**Replies:** 2\
**Last updated:** [January 25, 2024, 6:26pm UTC](https://community.hubspot.com/t/custom-code-in-workflow-to-calculate-number-of-emails/98552 "2024-01-25T18:26:12Z")

</div>

Hello community, While HubSpot provides a Number of times contacted field natively, this field is not very granular in that: It counts all types of activties indiscrimnantly. The number can only grow as its not calcul…

---

## [Connectwise Hubspot Sync](https://community.hubspot.com/t/connectwise-hubspot-sync/59689)

<div class="topic-metadata">

**Author:** [@NPatrin](https://community.hubspot.com/u/NPatrin)\
**Replies:** 1\
**Last updated:** [January 25, 2024, 1:55pm UTC](https://community.hubspot.com/t/connectwise-hubspot-sync/59689 "2024-01-25T13:55:39Z")

</div>

Our sales team has been using Hubspot for some time and we have decided now is the time to sync our databases. I have run into the issue that a lot of clients are labelled differently in the databases. Does anyone have a…

[Previous page](https://community.hubspot.com/c/revops-data-hub/64.md?page=24)

[Next page](https://community.hubspot.com/c/revops-data-hub/64.md?page=26)
