How to Manage DV360 Negative Keyword Lists
Instructions
This process can be used to quickly add negative keywords to your Advertise-level keyword exclusion list.
This should be used to update an existing list, not create a brand new one. If you already have one, skip to the Find Your Existing List Id
section. If you do not already have one, create that first, add your standard keyword exclusions to kick it off, and then move on to that section.
DV360 sometimes may be unable to immediately apply all keywords. Keep the # of keywords per action run low (5-6 max)
But if your action errors, and only some of the keywords get added, you can simply clear the Date Added
of the successful keywords, or change it to an older date, and re-run the alert. This will re-attempt to apply only the failed keywords
Find Your Existing List Id
Note: Negative keyword lists are built at the Advertiser level in DV360 but can only be applied at the Insertion Order level. This action will add negative keywords at the Advertiser level, subsequently updating all insertion orders that have the advertiser’s negative keyword list applied.
To find your List ID in DV360, navigate to the ‘Campaigns’ view for the Advertiser that your list will live in.
Select the three dots on the right side of the page. The SDF menu will populate then click download.
Since negative keyword lists are applied at the insertion order level, you only need to include granularity down to the insertion order level on this report.
Once your report has downloaded, open it in a google sheet.
Navigate to the SDF-Insertionorder.csv tab. This contains the SDF (structured data file) information at the insertion order level for your campaign.
Find the ‘Keyword List Targeting - Exclude’ column. You will notice that the list IDs in that column are repeated in multiple rows. This is because the list under that ID is applied to multiple insertion orders under the same advertiser.
Copy the list ID and paste it in your template.
Hint: there are multiple list IDs in one cell, there are multiple negative keyword lists applied to that IO. Try creating a dummy IO and applying the negative keyword list you are trying to update to that IO. You can download the SDF ad grab the ID from that row specifically!
Create Your Google Sheet Template
Navigate to the template and then select File > Make A Copy
Fill out your template
Template Variables
Account ID - the ID of the account you would like to apply the keyword exclusions to
List ID - the ID of the existing list you pulled in the
Find Your Existing List Id
sectionList Name - the name of the existing list
Keyword - the keyword
Date Added - the date you are adding the keyword. This should be the current date
Notes:
You may apply negative keywords to multiple accounts in the same google sheet, as long as your authentication token/user has access to each. Ensure each row has the appropriate account id, list id, and list name
You may edit the name of you google sheet, but do not edit the names of the tabs.
Create Your Alli Action
Navigate to your client in Actions and click
Create Action
Filter or search for the DV360 action named
Advertiser Level Negative Keyword List Update
and click
Select
Name your Action and select from the list of available authenticated accounts
If you do not have an authenticated account (or one that has access to what you need) follow these instructions first: How To Authenticate a Partner Platform to Send Actions To
In the
Set Datasource
section, selectGoogle Sheets
Copy and paste the url to your google sheet in
URL
fieldSheet Name should be
Leave This Alone - Todays Adds
Click
Save
and you can create a schedule if you would like.Click
Publish
in the bottom right, and you are done!
We recommend copying the link to your action and pasting that into your google sheet. Any time you add new keywords, you can then just follow the link, click Run Now
and run your action
When Running Your Action
We recommend always checking on your action after clicking run now. Navigate back to your action, to the Audit page. Underneath that, you can click on the most recent
User
blue link. Then click onItems
andAll
to see the full list, what was successful vs what was not.If your action errors, and only some of the keywords get added, you can simply clear the
Date Added
of the successful keywords, or change it to an older date, and re-run the alert. This will re-attempt to apply only the failed keywords

