ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
#REF!
3
!!! these code samples are not official Google products and are not formally supported !!!
4
the code samples are also available on GitHub
5
6
7
The goal of this document is to manipulate DV360 Campaigns, Insertion Order & Line Items at scale, directly from this sheet.
8
PLEASE MAKE A COPY!
9
Last Updated: 20210611
10
11
12
SETUP
13
14
GETTING READY
15
01Open the GCP console and navigate to APIs & Services > Library and enable the Display & Video 360 API
16
02
Retrieve your partner ID
DV360 > Partners
17
18
19
DOCUMENTATION
20
Learn more about the APIs
21
01
DV360 API Overview
https://developers.google.com/display-video/api/guides/getting-started/overview
22
02
DV360 API Documentation
https://developers.google.com/display-video/api/reference/rest
23
03
Other Google APIs
https://developers.google.com/apis-explorer/#p/
24
04
Apps Script Project List
https://script.google.com/home/my
25
26
27
INITIAL SETUP
28
StepTo DoTabMenu
29
01
Make a copy of this template sheet
-
[ File ] > [ Make a Copy ]
30
02
Open the Script Editor
-
[ Tools ] > [ Script editor ]
31
03
Within Apps Script, link your GCP project (see Getting Ready step #1)
-
[ Resources ] > [ Cloud Platform Project ]
32
33
34
HINT
35
36
Copy without formatting
WindowsCtrl + Shift ⇧ + V
37
Mac
Command ⌘ + Shift ⇧ + V
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