HockeyStack automatically matches ad platform data (such as spent, clicks, and impressions) with website visits and CRM data - if you are using unique UTMs across your ad platforms. This goes even a step further- if you are using unique UTMs across ads, HockeyStack can match ad data with website data and CRM data, which allows you to see the impact of each ad on leads, pipeline, and revenue.

This report focuses on Google Ads, but you could get it easily for every ad channel you use.

In order to create this report, go to the dashboard, and click “+” to add a new report

Then, select “Table” report type

Next, Name the report (1) and select the date range (2) you want to see the data for

Now that you have selected the date range, we will be adding the Date to a breakdown (1) - this will allow us to have the data broken down (grouped) by hour, day, week, month, or quarter (2).

Next, we will breakdown into either:

• Source - if you have set up source properties to show Paid Social, Organic Social, Paid Search, Organic Search, Affiliate, Referral etc.
• UTM Source and UTM Medium - if you don’t have the Source (or similar) property set up in the HockeyStack

In this example, we will use UTM Source and UTM Medium. You are more than welcome to add UTM Term if you want to get more granular with the data, for example, if your UTM Term mentions Keywords or Broad/Phrase match.

Next, we will add 3 Paid Ads Metrics columns.