Help with Constant Contact field mapping to integrate

SOLVE
JStruble
Member

I just upgraded to the Operation Hub Starter so I can integrate the lists from Constant Contact to HubSpot using the field mapping.  The Lists in HubSpot are neatly mapped out – data from drop down menus will populate a List.

 

I assumed I would be able to sync each list in Constant Contact to HubSpot.  However, even with the upgrade, it appears I can only sync to one list.  Through the chat function, a HS technician suggested I download all contacts from Constant Contact and reference a tag to trigger the correct list the contacts are to join in HubSpot. 

 

The field mapping is a joke! 

 

In Constant Contact, I cannot select list name or tag. I could create a customized field in Constant Contact.  However, that would only be a one-way sync to HubSpot. 

 

In HubSpot the field mapping doesn't allow me to select any dropdown menu options from the selected field. I considered creating a new field in HS that is the same customized one in Constant Contact to see if that triggers contacts to go into the correct List in HubSpot.  However, this is counterintuitive to the well-thought customization with drop down menus.  Plus, it will create duplicate data entry to add the information and I know my admin will make mistakes. I joined HS to avoid duplicate data entry.

 

Can anyone provide help on how contacts from my lists in HubSpots can seamlessly sync with my lists in Constant Contact?  I would be extremely grateful!

0 Upvotes
1 Accepted solution

Accepted Solutions
natsumimori
Solution
Community Manager

@JStruble 

 

I reached out to the internal team and wanted to share the following information:

  • Currently, it's possible to set one filter on Constant Contact side and HubSpot side. That said, we aren't able to set fitler with multiple lists. If you'd like to set the filter with list, you will want to create one list for this purpose.
  • This integration enables you to sync certain contacts, however, it doesn't sync lists with each other. So for example, if you wanted to create an exact same list between Constant Contacts and HubSpot, this is not possible with this integration.

View solution in original post

5 Replies 5
natsumimori
Community Manager

Hi @JStruble ,

 

Thank you for reaching out.

Would you mind sharing some screenshots of what you described in your post? I don't have experience with Constant Contact and would like to get more details to better understand the situation.

 

Your endgoal is to do two-way sync between HubSpot contact lists and Constant Contact lists, correct?

JStruble
Member

Thanks for reaching out!  Yes, the end goal is for two way sync. 

 

  1. This was advertised which you could only import that contact that you want. This doesn't seem to be true.  First I attempted to list by list by HubSpot only allows one sync. See here https://www.dropbox.com/s/wbexu8w874bu2kk/Only%20one%20sync.png?dl=0 
    In the Contact Sync module, it does allow to prevent a list from transfering contacts from the email platform. However, it only prevented one list. I wanted to limit 4 lists from syncing.  See here https://www.dropbox.com/s/m6loulv0akengq3/Only%20limits%20one%20list.png?dl=0  

    Is there a way to sync more than one list?  Currently 4,000 contacts have been imported into HubSpot that I do not want!  If this could be fixed this would be a GREAT help.

  2. The second problem I encountered was getting the list in Constant Contact to fill the list in HubSpot.  I was extremely disapponted in the field mapping for HubSpot, that the drop down menu items did display for a field.  In the field Job Function, I have a drop down for our various target audience but could not select the drop down option 'Executive Director' which would match with the list in Constant Contact by the same name.  See here https://www.dropbox.com/s/dtkthyrnuo8facy/No%20Drop%20down%20option.png?dl=0

  3. As a work around for #2, I created a radio button field Called Executive Director. If this is checked, it will tell Constant contact to upload to the Executive Director list. See here. https://www.dropbox.com/s/1625k2r45nfan5q/Create%20new%20text%20field.png?dl=0  I now need to create this work around for four more lists.  Now this sounds like a resolution, however, it isn't. I adopted a CRM to stop doing duplicate data entry and now I'm forced into it. Whenever there is duplicate data entry there are mistakes.  Is there an easier, cleaner way I can have a list in Hubspot match a list in Constant Contact?

  4. Last, my workaround only has one way sync from HubSpot to Constant Contact.  See:  https://www.dropbox.com/s/1625k2r45nfan5q/Create%20new%20text%20field.png?dl=0  I would like this to be two way.  Is there a solution to make this field mapping two ways?

Your assistance is greatly appreciated!

 

 

0 Upvotes
natsumimori
Community Manager

Hi @JStruble 

 

Thanks for sharing screenshots.

 

I read through Constant Contact App Marketplace documentation and Connect and use HubSpot data sync , and this integration between Constant Contact and HubSpot is a two-way sync. However, in some scenarios, properties won't sync for example

  • Some types of custom properties cannot be synced (e.g. drop-down properties, radio select properties, checkbox properties)". Therefore, this is currently working as desined.(#2, #3)
  • Properties with multiple values can’t be synced in a custom mapping. For example, properties such as emails, phone numbers and addresses where each value has a label to differentiate between "home", "work" and "other".(#4)

For #1, I am checking with the internal team if it's possible to select more than one list to be synced. (My assumption is that you will need to create one list for sync.)

 

 

0 Upvotes
natsumimori
Community Manager

Please feel free to chat into the Technical Support channel as you have paid subscription and have access to the Support team!  (In you account > Help at the bottom right> Contact support > Chat)

0 Upvotes
natsumimori
Solution
Community Manager

@JStruble 

 

I reached out to the internal team and wanted to share the following information:

  • Currently, it's possible to set one filter on Constant Contact side and HubSpot side. That said, we aren't able to set fitler with multiple lists. If you'd like to set the filter with list, you will want to create one list for this purpose.
  • This integration enables you to sync certain contacts, however, it doesn't sync lists with each other. So for example, if you wanted to create an exact same list between Constant Contacts and HubSpot, this is not possible with this integration.

View solution in original post