All
gps_fixed
DV360 Bulk Targeting Editor
Allows bulk targeting DV360 through Sheets and BigQuery.
Impact Level
| Spend Optimization |
|
| Spend Growth |
|
| Time Savings |
|
| Account Health |
|
| Csat Improvement |
|
Value Proposition
| Speed up bulk targeting. |
Instructions
| Select Load, click Save + Run, a sheet called DV Targeter will be created. |
| In the Partners sheet tab, fill in Filter column then select Load, click Save + Run. |
| In the Advertisers sheet tab, fill in Filter column. then select Load, click Save + Run. |
| Check the First And Third Party option to load audiences, which may be slow. If not loaded, user will enter audience ids into the sheet manually. |
| On the Line Items sheet tab, the Filter is used only to limit drop down choices in the rest of the tool. |
| Optionally edit or filter the Targeting Options or Inventory Sources sheets to limit choices. |
| Make targeting updates, fill in changes on all tabs with colored fields (RED FIELDS ARE NOT IMPLEMENTED, IGNORE). |
| Select Preview, click Save + Run then check the Preview tabs. |
| Select Update, click Save + Run then check the Success and Error tabs. |
| Load and Update can be run multiple times. |
| If an update fails, all parts of the update failed, break it up into multiple updates. |
| To refresh the Partner, Advertiser, or Line Item list, remove the filters and run load. |
Details
| Open Source | YES |
| Age | Jan. 12, 2021 (1 year, 11 months) |
| Authors | kenjora@google.com |
| Manual | Triggered on demand by user. |
[
{
"dataset": {
"__comment__": "Ensure dataset exists.",
"auth": {
"field": {
"name": "auth_bigquery",
"kind": "authentication",
"order": 1,
"default": "service",
"description": "Credentials used for writing data."
}
},
"dataset": {
"field": {
"name": "recipe_slug",
"kind": "string",
"order": 2,
"default": "",
"description": "Name of Google BigQuery dataset to create."
}
}
}
},
{
"drive": {
"__comment__": "Copy the default template to sheet with the recipe name",
"auth": {
"field": {
"name": "auth_sheet",
"kind": "authentication",
"order": 1,
"default": "user",
"description": "Credentials used for reading data."
}
},
"copy": {
"source": "https://docs.google.com/spreadsheets/d/1ARkIvh0D-gltZeiwniUonMNrm0Mi1s2meZ9FUjutXOE/",
"destination": {
"field": {
"name": "recipe_name",
"suffix": " DV Targeter",
"kind": "string",
"order": 3,
"default": "",
"description": "Name of Google Sheet to create."
}
}
}
}
},
{
"dv_targeter": {
"__comment": "Depending on users choice, execute a different part of the solution.",
"auth_dv": {
"field": {
"name": "auth_dv",
"kind": "authentication",
"order": 1,
"default": "user",
"description": "Credentials used for dv."
}
},
"auth_sheets": {
"field": {
"name": "auth_sheet",
"kind": "authentication",
"order": 2,
"default": "user",
"description": "Credentials used for sheet."
}
},
"auth_bigquery": {
"field": {
"name": "auth_bigquery",
"kind": "authentication",
"order": 3,
"default": "service",
"description": "Credentials used for bigquery."
}
},
"sheet": {
"field": {
"name": "recipe_name",
"suffix": " DV Targeter",
"kind": "string",
"order": 4,
"default": "",
"description": "Name of Google Sheet to create."
}
},
"dataset": {
"field": {
"name": "recipe_slug",
"kind": "string",
"order": 5,
"default": "",
"description": "Name of Google BigQuery dataset to create."
}
},
"command": {
"field": {
"name": "command",
"kind": "choice",
"choices": [
"Clear",
"Load",
"Preview",
"Update"
],
"order": 6,
"default": "Load",
"description": "Action to take."
}
},
"first_and_third": {
"field": {
"name": "first_and_third",
"kind": "boolean",
"order": 6,
"default": false,
"description": "Load first and third party data (may be slow). If not selected, enter audience identifiers into sheet manually."
}
}
}
}
]Run This Workflow In Minutes On Google Cloud
Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.