All
cleaning_services
DV360 Bulk Editor
Allows bulk editing DV360 through Sheets and BigQuery.
Impact Level
| Spend Optimization |
|
| Spend Growth |
|
| Time Savings |
|
| Account Health |
|
| Csat Improvement |
|
Value Proposition
| Speed up bulk editing. |
| Add custom validation rules using BQ. |
Instructions
| Select Load Partners, then click Save + Run, then a sheet called DV Editor will be created. |
| In the Partners sheet tab, fill in Filter column then select Load Advertisers, click Save + Run. |
| In the Advertisers sheet tab, fill in Filter column then select Load Campaigns, click Save + Run. |
| In the Campaigns sheet tab, fill in Filter column, optional. |
| Then select Load Insertion Orders And Line Items, click Save + Run. |
| To update values, make changes on all Edit columns. |
| Select Preview, then Save + Run. |
| Check the Audit and Preview tabs to verify commit. |
| To commit changes, select Update, then Save + Run. |
| Check the Success and Error tabs. |
| Update can be run multiple times. |
| Update ONLY changes fields that do not match their original value. |
| Insert operates only on Edit columns, ignores orignal value columns. |
| Carefull when using drag to copy rows, values are incremented automatically. |
| Modify audit logic by visting BigQuery and changing the views. |
Details
| Open Source | YES |
| Age | Nov. 15, 2020 (2 years, 1 month) |
| 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",
"prefix": "DV_Editor_",
"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/18G6cGo4j5SsY08H8P53R22D_Pm6m-zkE6APd3EDLf2c/",
"destination": {
"field": {
"name": "recipe_name",
"prefix": "DV Editor ",
"kind": "string",
"order": 3,
"default": "",
"description": "Name of Google Sheet to create."
}
}
}
}
},
{
"dv_editor": {
"__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",
"prefix": "DV Editor ",
"kind": "string",
"order": 4,
"default": "",
"description": "Name of Google Sheet to create."
}
},
"dataset": {
"field": {
"name": "recipe_slug",
"prefix": "DV_Editor_",
"kind": "string",
"order": 5,
"default": "",
"description": "Name of Google BigQuery dataset to create."
}
},
"command": {
"field": {
"name": "command",
"kind": "choice",
"choices": [
"Clear Partners",
"Clear Advertisers",
"Clear Campaigns",
"Clear Insertion Orders And Line Items",
"Clear Preview",
"Clear Update",
"Load Partners",
"Load Advertisers",
"Load Campaigns",
"Load Insertion Orders And Line Items",
"Preview",
"Update"
],
"order": 6,
"default": "Load Partners",
"description": "Action to take."
}
}
}
}
]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.