APIs & Integrations

Shamash
Contributor | Gold Partner
Contributor | Gold Partner

Calculated properties for transactional data

SOLVE

We’re using the ecom bridge api to set up a custom ecom integration and would like to store calculated values for transactional data on contact properties as well as company properties, such as the contact’s average order value or lifetime order value or number of completed orders. Is there a way to do these calculations from within Hubspot?

1 Accepted solution
IsaacTakushi
Solution
HubSpot Employee
HubSpot Employee

Calculated properties for transactional data

SOLVE

Hey @shamash,

Not directly through any of our APIs, but you could pull property values, parse and calculate them on your end, and update a new custom property to act as a calculated or rollup property.

Isaac Takushi

Associate Certification Manager

View solution in original post

5 Replies 5
Shamash
Contributor | Gold Partner
Contributor | Gold Partner

Calculated properties for transactional data

SOLVE

Got it, thanks @Isaac_Takushi

IsaacTakushi
HubSpot Employee
HubSpot Employee

Calculated properties for transactional data

SOLVE

Hi @shamash,

Calculated and rollup properties were launched today (9/5/18) at INBOUND 2018 to Marketing Hub Enterprise, Sales Hub Enterprise, and Service Hub Enterprise subscriptions and offer this kind of functionality. Learn more about HubSpot's INBOUND 2018 product announcements here.

At this time, there are no plans to add calculated and rollup properties to other subscription types.

Isaac Takushi

Associate Certification Manager
Shamash
Contributor | Gold Partner
Contributor | Gold Partner

Calculated properties for transactional data

SOLVE

By the way @Isaac_Takushi, is it possible to do these calculations/rollups using the APIs?

IsaacTakushi
Solution
HubSpot Employee
HubSpot Employee

Calculated properties for transactional data

SOLVE

Hey @shamash,

Not directly through any of our APIs, but you could pull property values, parse and calculate them on your end, and update a new custom property to act as a calculated or rollup property.

Isaac Takushi

Associate Certification Manager
Shamash
Contributor | Gold Partner
Contributor | Gold Partner

Calculated properties for transactional data

SOLVE

Interesting, good timing :slight_smile: Thanks