The StarThinker project will no longer receive new solution contributions from the Google team.
Please read the full StarThinker Open Source Support Ends At Google article for more details.



All

gps_fixed

DV360 Bulk Targeting Editor

Allows bulk targeting DV360 through Sheets and BigQuery.

DV360 Bulk Targeting 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 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.

Deployment Stepslaunch Developer Guidebuild UI How Tolaptop