ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Google Ads Campaign Overview Dashboard By
3
4
Monitor Google Ads activity from the comfort of your spreadsheet with this free template. Easily evaluate ad engagements,
track costs, and gain performance insights to share with your team.
5
6
The base of this template is the “Raw_Data” tab, which is where Unito will sync your Google Ads data into and keep it up-to-date in real-time.
7
If syncing data with Unito, please do not remove the columns UnitoID and LastModified.
8
9
You can also fill this tab in manually. Rates (CTR, CPC, CTR etc.) are calculated within the “DropDown” tab and do not need to be added in.
10
11
Set up your Google Ads High-Level Overview Dashboard template in just a few steps!
12
13
Step 1: Click File → Make a copy to create your own version.
14
15
Step 2: Sign up for a 14-day trial with Unito. In order to keep data in sync between Google Ads and Google Sheets, you will need a Unito account.
16
Head to https://unito.io/ to create an account, no credit card required.
17
18
Step 3: Delete the test data in the "Raw Data" tab. Build a flow with Google Ads and Google Sheets. We’ve included steps to walk you through the process below.
19
20
21
Step-by-step walkthrough to connect your data to this template:
22
23
1. Connect Google Ads and Google Sheets:
24
Authorize Google Ads and select the desired Account
25
Choose Campaign as a Resource
26
Select Campaign Name, Ad Network Type, and Date as Dimensions.
27
Select Impressions, Clicks, Cost Micros, and Conversions as Metrics.
28
Choose a predefined or custom Google Ads Date Range.
29
Authorize Google Sheets and select “Raw_Data” as your desired sheet by pasting the URL.
30
Install our Spreadsheet Sync Add-On for Google Sheets.
31
32
33
34
35
36
37
38
39
40
41
42
43
2. Add Rules (Optional)
44
Your flow direction will be automatically selected as one-way from Google Ads to Google Sheets.
45
You can now specify the data you want to include in your report by adding filters, limit the number of rows you sync,
46
and choose to preserve or remove rows from your sheet that no longer meet your rules.
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
3. Map your fields
65
Follow the mappings in the image for your template to work as expected.
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
4. Launch your flow!
86
Your Google Ads data should appear in the “Raw Data” tab and will stay updated in real-time.
Check out the charts in the “Dashboard” tab.
87
88
About Unito 👋
89
Unito is a no-code two-way integration solution that can connect your apps and automate your workflows in minutes.
90
91
Feedback or questions?
92
We’re here to support you. Please email support@unito.io if you have any questions about this template or Unito.
93
94
95
96
97
98
99
100