ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Getting Started with AdStage for Google Sheets
3
To get started, make a copy of this sheet.
4
You must have an active AdStage account and have the AdStage Add-on installed.
5
Need an account?
Sign Up for a 14-day trial
6
7
Quick guide to the AdStage function
8
9
The AdStage for Google Sheets add-on includes five custom functions, one for each entity level you can query. Example queries can be found in the sidebar.
10
1. Accounts
11
2. Campaigns
12
3. Ad Groups
13
4. Ads
14
5. Keywords
15
16
Each function requires a few parameters to work.
17
Timeframes
18
The functions allow both relative ranges (phrases like "last 30 days") and specific date ranges. When specifying specific date ranges you can use a cell range of dates (ex:D1:E1) or a date range string of format: "2016-02-28..2016-03-03".
19
20
Metadata & Metrics
21
Functions must be supplied with column names to fetch data. You can make this a list (ex: {"name", "spend"}) or a range of cells - usually your header row (ex: A1:H1)
22
23
Limit
24
Set how many rows to return. It's always a good idea to test your query with a small limit first. Example:
=accounts("this week", A1:H1, {"limit", 10})
25
26
Suggested parameters to always include in your query
27
Sort by
28
Use this parameter to sort your data by metric. The sort is defaulted to Descending. Popular options are spend and clicks.
=accounts("this week", A1:H1, {"sort by", "clicks"})
29
30
Filters
31
Filters to apply to your data, such as campaign name matching (ex: "campaign name ~ Brand" for campaign names containing brand) and spend filtering (ex: "spend > 0"). Combine multiple filters with a semicolon: ";" Example:
=campaigns("this week", A1:H1, {"filters", "spend > 0; campaign name ~ Brand"})
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100