{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/4ab97df830de4feeb63eeefab8d133aa\" frameborder=\"0\" width=\"2682\" height=\"2011\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":2011,"width":2682,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":2011,"thumbnail_width":2682,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/4ab97df830de4feeb63eeefab8d133aa-a77741ccf0e6350e.gif","duration":584.558,"title":"Building a Stripe Subscription KPI Report for a HubSpot Dashboard with ClearSync","description":"In this video, I walk you through how to create a KPI report in HubSpot that highlights key metrics from our Stripe subscription data, such as active paid subscriptions, current and average MRR, and our progress towards a $2 million ARR goal. We start by setting up a custom report using the ClearSync Stripe subscriptions object and apply filters to ensure we only include active subscriptions. I also demonstrate how to add and customize fields, including a formula for calculating our percentage to goal, which requires HubSpot Professional or Enterprise. Please refer to our documentation at docs.clearsync.ai for the specific formulas needed. By the end, you'll have a comprehensive KPI report to track our performance."}