Tips, Tricks & Best Practices

danielajk
Membre

How to import timestamps from .csv to contact property

Résolue

Dear Community,

I use Webinarjam and Hubspot for sign ups and webinar execution and am connecting the two via zapier. I want to update a contact property in Hubspot to reflect who attended a webinar and who missed it. For this, I imported a .csv with the live attendees from Webinarjam and the contact property has been correctly updated for properties formatted as "radio select", where option was “Yes" for attendance and "No" for no attendance. I also wanted to import the time stamps (so time spent in live or replay room) but this information could not be imported, I guess because of the wrong format. Can you let me know what format I can import into? Ideally it would not be text but date or time, so you can later on also interpret or filter according to the results? See the screenshot below for the timestamp format I want to import.

Thank you and best

Daniela

 

danielajk_2-1642181177012.png

 

 

 

 

0 Votes
1 Solution acceptée
karstenkoehler
Solution
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

How to import timestamps from .csv to contact property

Résolue

Hi @danielajk,

 

Unfortunately there aren't any file formats for durations or time (aside from the Date picker format). The closest to a duration would be the Number format. You'd have to convert the minutes into decimals first. Then you could import the number into a newly created custom Number property.

 

Let me know if you have any follow-up questions!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

Voir la solution dans l'envoi d'origine

0 Votes
2 Réponses
danielajk
Membre

How to import timestamps from .csv to contact property

Résolue

Thanks @karstenkoehler this helps.

karstenkoehler
Solution
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

How to import timestamps from .csv to contact property

Résolue

Hi @danielajk,

 

Unfortunately there aren't any file formats for durations or time (aside from the Date picker format). The closest to a duration would be the Number format. You'd have to convert the minutes into decimals first. Then you could import the number into a newly created custom Number property.

 

Let me know if you have any follow-up questions!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Votes