# Ad Campaign Custom Report

**URL:** <https://community.hubspot.com/t/ad-campaign-custom-report/93209>\
**Category:** Reporting & Analytics\
**Tags:** professional\
**Created:** [November 3, 2023, 8:12am UTC](https://community.hubspot.com/t/ad-campaign-custom-report/93209 "2023-11-03T08:12:46Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![SSingh8983](https://avatars.discourse-cdn.com/v4/letter/s/2acd7d/32.png) [@SSingh8983](https://community.hubspot.com/u/SSingh8983)\
**Post date:** [November 3, 2023, 8:12am UTC](https://community.hubspot.com/t/ad-campaign-custom-report/93209/1 "2023-11-03T08:12:46Z")

</div>

I am trying to create a report that shows at a ad campaign level what was the cost per contact i.e. Ad spend of that campaign/count of contacts created.

However the count of contacts is showing up as zero. I have already connected the google ads account to hubspot. Do I need to create any custom properties for contacts to capture the ad campaign name to attribute them to a campaign?

Also for each ad campaign I want to report the count of contacts who reached X deal stage. Would I need to create any properties/ additional integrations to attribute deals/ contacts to ads?

---

<div class="post-metadata">

**Author:** ![Berangere](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/berangere/32/220784_2.png) [@Berangere](https://community.hubspot.com/u/Berangere)\
**Post date:** [November 6, 2023, 8:11am UTC](https://community.hubspot.com/t/ad-campaign-custom-report/93209/2 "2023-11-06T08:11:40Z")

</div>

Hi @SSingh8983,  
Thank you for asking the Community!  
I’d like to ask some questions please:  
- Where are you seeing zero for the count of contacts? Is it on a custom report that you created? If yes, can you please share screenshot, filters, property used and source data?  
- Or is it a native default report? If that is the case, are some filters selected?  
- To see the cost per contact, in the metrics, did you select the option “cost per contact”?  
The more info, screenshots (without sensitive/confidential information), and details you can provide, the better the Community can assist.  
I’d like to share these articles that can be of interest:  
- [Analyze ad campaigns in HubSpot](https://knowledge.hubspot.com/ads/analyze-ad-campaigns-in-hubspot)  
- [Report on ad campaigns using the custom report builder](https://knowledge.hubspot.com/ads/report-on-ad-campaigns-using-the-custom-report-builder)  
- [Ads attribution in HubSpot](https://knowledge.hubspot.com/ads/ads-attribution-in-hubspot)  
I’d like to invite some of our top experts to this conversation: Hi @danmoyle, @Franci and @HFisher7 do you have any tips to help @SSingh8983, please?

**Also, if anybody else has anything to add and/or share, please feel free to join in the conversation 🙂**

Thank you ❤ and have a great day!  
Best,  
Bérangère

---

<div class="post-metadata">

**Author:** ![SSingh8983](https://avatars.discourse-cdn.com/v4/letter/s/2acd7d/32.png) [@SSingh8983](https://community.hubspot.com/u/SSingh8983)\
**Post date:** [November 6, 2023, 9:19am UTC](https://community.hubspot.com/t/ad-campaign-custom-report/93209/3 "2023-11-06T09:19:27Z")

</div>

Hi [@BérangèreL](https://community.hubspot.com/t5/user/viewprofilepage/user-id/230185) thanks for your revert!

1. I am seeing count of contacts as zero in a native default report. This is under “Marketing \> Ads \> Ad Campaigns”. Please see attached screenshot. The count of impressions and clicks, ad spend is correct but not getting count of contacts here. I have connected my Google Ads account to Hubspot.

2. I also had a question regarding custom report. If I want to build a custom report to track some metrics at an ad campaign level. Under what property name would I find these Google Ad Campaign names? Does Hubspot store these properties as default properties after Google ads integration or do I have to set up some custom properties?

 ![Screenshot 2023-11-06 at 2.42.01 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/a/6/a6cf8f4d8797ac958c7f9308a92f7f8f8288005d.png)

---

<div class="post-metadata">

**Author:** ![danmoyle](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danmoyle/32/91166_2.png) [@danmoyle](https://community.hubspot.com/u/danmoyle)\
**Post date:** [November 6, 2023, 2:01pm UTC](https://community.hubspot.com/t/ad-campaign-custom-report/93209/4 "2023-11-06T14:01:59Z")

</div>

Hi @SSingh8983. One thing to double check is whether you have enabled lead syncing in your HubSpot account. Under Marketing in the main navigation bar, click ads, then click settings in the top right hand corner. Click the lead syncing tab, and make sure you have connected your ad account here. Otherwise, they will not be able to show in HubSpot.

Another thing to consider is whether you’re looking at the right filters. Did you look at the filter in the Ads section in Attribution Reports: **All form Submission**?

 ![danmoyle_0-1699279240364.png](https://d2qpr2jzcazej7.cloudfront.net/original/1X/1afab9abd5c4825892b6ed62c127af37edd8ceb5.png)

Also, you can use the “Ads interactions” list filter to capture contacts who have interacted with your ads.

Hope that helps.

---

<div class="post-metadata">

**Author:** ![SSingh8983](https://avatars.discourse-cdn.com/v4/letter/s/2acd7d/32.png) [@SSingh8983](https://community.hubspot.com/u/SSingh8983)\
**Post date:** [November 6, 2023, 2:23pm UTC](https://community.hubspot.com/t/ad-campaign-custom-report/93209/5 "2023-11-06T14:23:36Z")

</div>

Hi @danmoyle Yes, I had set up lead syncing and the filter is also set to All Form Submissions but it still shows zero contacts.

---

<div class="post-metadata">

**Author:** ![danmoyle](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danmoyle/32/91166_2.png) [@danmoyle](https://community.hubspot.com/u/danmoyle)\
**Post date:** [November 7, 2023, 1:34pm UTC](https://community.hubspot.com/t/ad-campaign-custom-report/93209/6 "2023-11-07T13:34:11Z")

</div>

@SSingh8983 can you find contacts who you know filled out the form from the ad? Is it possible it’s not converting?
