Google Ads Dashboard

Original Post: https://hockeystack.com/templates/roman-krs-google-ads-dashboard

Read before building

Track Date Properties

Goals Needed to Build this Dashboard:

Lead Created Goal	https://www.loom.com/share/e4ef5230d2e7480e8f377f01d094ff64?sid=f7e30c87-a644-4640-9ff7-feccee30703a
MQL Goal	https://www.loom.com/share/25de4ed559794ee880d0a7e69c9735f0?sid=162bdf54-7fea-4f77-90be-2f4942a803d7
SQL Goal	https://www.loom.com/share/ced48ba3e29e46d3a8428f78f4b60c3b?sid=d2aa363f-5ac7-4dc5-9fb2-81c3f0c41289
SAO	https://www.loom.com/share/d83b25cbf6eb462aa951466bbc5b18fa?sid=50a44486-5651-4832-88a9-f95849292abe
SQO	https://www.loom.com/share/6d420aeb37f4445793734e89a96e9cff?sid=706ea2b5-4a5f-43db-8e4f-5a7e89f84ef0
Closed Won	https://www.loom.com/share/6c4b4cb90b1f4109bba6ebd53ebabe2c?sid=d6deec78-da36-405c-ae68-72b508bb01ed

Notes:

• Deal and Opportunity could be used interchangeably in these examples

• Goals, Properties, and Reports subject to your specific customization requirements :)

Defined Properties Needed to Build this Dashboard

Defined Properties	Resource
Channel (previously: Unified Channel) Property	Created as part of the onboarding
Campaign (previously: Unified Campaign) Property	https://docs.hockeystack.com/guides/how-to-build-a-unified-campaign-property#block-eb9f2de5c2e341dba9d572ff11d46ce5
High Intent Pages	https://www.loom.com/share/0de889d5ddce405ba5e51a9070408f04?sid=cc32c7c4-030b-4312-858e-022b1e5f213a
Region	https://www.loom.com/share/d45f6e804f0e47e3b1f57cb1bcfa51a1?sid=c37f7024-1280-491f-bdc2-6284e8a41403
Keywords	https://www.loom.com/share/ad37bb1a62c3487585d99e3a4212230c?sid=48898710-27c7-4c17-87b5-6efdf1b3e83e

Reports Needed to Build this Dashboard

Region Performance (Direct)	https://www.loom.com/share/af68e189b07d41729bbc7a82661e26ef?sid=2f89ded2-7f5c-4398-965b-49a77056114b
User Journey with Google Ads	https://www.loom.com/share/f23adf1a8a3349dc80c6c849fa5146f3?sid=b1a9c60f-4c86-4e58-8151-de3709913a3b
Lift of Keywords on Closed Won	https://www.loom.com/share/fcc5ee30993340948e3567a403f816d7?sid=c52fb838-f060-483e-b900-15ccd4640c7d
Lift of Keywords on Pipeline	https://www.loom.com/share/af68e189b07d41729bbc7a82661e26ef?sid=9f4cdfc5-59b7-4e25-b050-a673c1818b22
Lift of Keywords on Leads	https://www.loom.com/share/af68e189b07d41729bbc7a82661e26ef?sid=9f4cdfc5-59b7-4e25-b050-a673c1818b22
Conversion Rates Linear	https://www.loom.com/share/97b1b1682ba34ea98eb4e95e82ecae0c?sid=ed47811e-2c09-4fff-bfbd-0635d6de12ab
SRA Mentioning Google	https://www.loom.com/share/14bf803a59b44f6e83b1eabd95af9cd5?sid=fd871d21-a631-4b39-b4fd-649f5c3e34a8
Google Website Visits Until Closed Won	https://www.loom.com/share/842537b9db7245248fdaf52f87831939?sid=68f06f19-7b88-4c4d-bcca-e5aafea13910
Google Website Visits until Lead	https://www.loom.com/share/7b37bc828a62400ba436acb519d5f7eb?sid=f4b44997-fb65-4c16-a8f5-829743daddfc
Google Website Visits Until Deal	https://www.loom.com/share/69094f39eba44aa3aca0972fb8c8ee92?sid=0f94d8fc-8854-421d-afbb-94fb8ad9d44b
Direct Conversion Rates	https://www.loom.com/share/dd5449bb6eed401698db28634dd0cc1c?sid=46f59576-5daf-476a-8449-4c335bbcd744
Direct Conversions / Demo	https://www.loom.com/share/abc14ba1edc34823b20e1fd80d015ad3?sid=d2ef1bed-a21b-489d-b738-5e2d7627bb66
Channel Metrics over Time	https://www.loom.com/share/ceb33096875748c8a18b276e084c199b?sid=c573a585-3faa-44da-ba8e-fadf5d2f6132
Cost Per Aquisition	https://www.loom.com/share/eb926073c72948349aad9f51e511e106?sid=d5194170-955a-41de-b69a-f509cce9c241
Conversion Rate	https://www.loom.com/share/3b32c8212b60468a894939851294c567?sid=ba05961c-abe1-490c-9415-f582bd36ade6
Spent - USA	https://www.loom.com/share/4cac962952e14eb3b4cdabfe40c391ed?sid=449982ed-9a45-4bcb-a16d-af6e4b701a0f
Campaign Performance (Direct)	https://www.loom.com/share/98022eaba594451ebbd79fefabea86de?sid=c189fb05-8aee-4d72-8efb-13c411455027
Keywords Performance (Direct)	https://www.loom.com/share/af68e189b07d41729bbc7a82661e26ef?sid=2f89ded2-7f5c-4398-965b-49a77056114b