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 LinkedIn, 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

https://lh7-us.googleusercontent.com/wJx0C8NPVVAgwYkOZj34dL2U5RVwiHliUTwiAjeNg88a111_H30dNusCD9daUH4FaSljcK3dcqSO9Lw70eFmRXqHqmNNC8dLJ0yzC7Zx5BS7YikpYkRVLhdE3s-rpgQoVql11Xx4sSPbn53VaXeM12I

Then, select “Table” report type

https://lh7-us.googleusercontent.com/Unx_MSaBCNkHStBaH667Lu0NmTPKHo4qFOEs906p5YeJc00tmK2ZLnhdTa2sVOIyB5GX2VZhudPMInATvgO83NEOw-_ACBl4gvhca5_S0N2tQiSGNLagllh785m8NoduqfiogE6s4ABn6XHha5zUtzQ

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

https://lh7-us.googleusercontent.com/gsfJyEyiY0PwdjG8Yy-_uRhtWyYGIdIApNxrIdFDhcr4PDMkwUiXaf49VeCGtG09YPi-ZsyckVT84A_psPa7pXTZdo8fIirBt0TOkv6HfBYchT3kHes4NJ_L4iu2mhhrChYkNG7wywjs31zoCafhjXw

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).

https://lh7-us.googleusercontent.com/whZzERHcyVgJwB94Txpf8owza2kg73VDmjJC5SfVkOvLFFhxNSflzZu6TNnTuqI7Ah2bNxVwol6HxVR7aScdw646RL9pvx8lOtfa9lWmEJ-559h8WkPNRIKef1MVBdXZfOPoXBGW094MbrCbEBviZfc

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.

https://lh7-us.googleusercontent.com/rKpx1EQKlsWyfa4zsL2ZDoqOjXQGJwkwT07LT6aPYJd23_T5pTrlxK6XlBPGtP2fCU5rr7GXGqoWzHt4008toDy34iU_Jo9TDrv0GVyOuLq-Z8XCnDVHjDcvhlEKIvLTx8rJdI9mG6NBVucaLY2xUmY

Next, we will add 3 Paid Ads Metrics columns.

https://lh7-us.googleusercontent.com/uO3u3zNiMzNagROz0AOKggtKVjk-uvv41mUTA25sxBEflKa5Is8lqFnr5d_y6IddBYiaVLptZlbmyEnWuJ9dqtqR-_EZvOggmidPv5rYRIcUNRUkv8ZcIGEiCc1btz9ZaH0E3Mh-BYj4m3XF9HtAACA

https://lh7-us.googleusercontent.com/5e_o8pDBWDqytrqyawVfwD2x9MmmSRZrw0S7q2ry17S_z9bWFAJ4dhHcN6AqwlRUEjFkRmQG4AQFasX1RkquDhy4ZuUumsEi93m2HoxUBeOmGViP7s56CBBc1Z-Y_EImI7PhUzMipFig2u6L7SIul4U

Followed by that, we will add another column, this time Website Metrics (1)  -> Pageviews (2)

https://lh7-us.googleusercontent.com/BU55KPV6FEoQf7gBVV2XmYVLDMZGdav_xJ_rUZ7RQdBOOwZbqRfNsUq6P8pDesvV_rSETDb-Bd6OzZMA4j-OBhOIushcg3BS4V_gBmBKyQH9Ugu4CPsMVc9_RJeWsGaOMtpb6G4AkylnGg8-TJvHklQ