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. 

1. To find your List ID in DV360, navigate to the ‘Campaigns’ view for the Advertiser that your list will live in. 

2. Select the three dots on the right side of the page. The SDF menu will populate then click download.

   1. 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. 

      

3. Once your report has downloaded, open it in a google sheet. 

4. Navigate to the SDF-Insertionorder.csv tab. This contains the SDF (structured data file) information at the insertion order level for your campaign. 

5. 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.

6. 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

1. Navigate to the template and then select File > Make A Copy

2. Fill out your template

   1. Template Variables

      1. Account ID - the ID of the account you would like to apply the keyword exclusions to

      2. List ID - the ID of the existing list you pulled in the Find Your Existing List Id section

      3. List Name - the name of the existing list

      4. Keyword - the keyword

      5. Date Added - the date you are adding the keyword. This should be the current date

   2. Notes:

      1. 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

3. You may edit the name of you google sheet, but do not edit the names of the tabs.

Create Your Alli Action

1. Navigate to your client in Actions and click Create Action

2. Filter or search for the DV360 action named Advertiser Level Negative Keyword List Update

   and click Select

   

3. Name your Action and select from the list of available authenticated accounts

   1. If you do not have an authenticated account (or one that has access to what you need) follow these instructions first: How Manage Partner Platform Authentication in Actions

4. In the Set Datasource section, select Google Sheets

   1. Copy and paste the url to your google sheet in URL field

   2. Sheet Name should be Leave This Alone - Todays Adds

      

5. Click Saveand you can create a schedule if you would like.

6. 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 on Items and All 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

Full Process Recording - Watch This