All

cleaning_services

DV360 Bulk Editor

Allows bulk editing DV360 through Sheets and BigQuery.

DV360 Bulk Editor Sample Screenshot


lock_openGet Access directions_bikeSample listGit Hub sourcePython menu_bookColab airAirflow thumb_upTest



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 (1 year)
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.

Deployment Stepslaunch Developer Guidebuild UI How Tolaptop