# Calculated Property - CTR in Custom Reports

**URL:** <https://community.hubspot.com/t/calculated-property-ctr-in-custom-reports/129321>\
**Category:** Dashboards & Reporting\
**Tags:** reports, dashboards\
**Created:** [April 5, 2025, 2:25am UTC](https://community.hubspot.com/t/calculated-property-ctr-in-custom-reports/129321 "2025-04-05T02:25:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MBhutta](https://avatars.discourse-cdn.com/v4/letter/m/77aa72/32.png) [@MBhutta](https://community.hubspot.com/u/MBhutta)\
**Post date:** [April 5, 2025, 2:25am UTC](https://community.hubspot.com/t/calculated-property-ctr-in-custom-reports/129321/1 "2025-04-05T02:25:44Z")

</div>

“CTR” is not available in Custom Reports for ad campaigns at the ad level. Is it possible to make a Calculated Property of it using the formula: CTR = Clicks/Impressions \* 100? Is there any other work around to use this metric in my custom reports?

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [April 5, 2025, 5:46am UTC](https://community.hubspot.com/t/calculated-property-ctr-in-custom-reports/129321/2 "2025-04-05T05:46:54Z")

</div>

Hi @MBhutta,

Have you tried approaching this with formula fields? [Create formula fields in the custom report builder](https://knowledge.hubspot.com/reports/create-formula-fields-in-the-custom-report-builder)

These are in beta, you should see them under Settings \> Product updates \> All product updates \> Formula Fields now in Custom Report Builder.

Best regards