All

donut_small CM360 Report Replicate

Replicate a report across multiple networks and advertisers.



lock_openGet Access listDocumentation listGit Hub sourcePython menu_bookColab airAirflow thumb_upTest



Instructions

Provide the name or ID of an existing report.
Run the recipe once to generate the input sheet called .
Enter network and advertiser ids to replicate the report.
Data will be written to BigQuery > > > _All

Details

Open Source YES
Age March 3, 2020 (1 year, 8 months)
Authors kenjora@google.com
Shedule Days Configured by user.
Shedule Hours Configured by user.
[
    {
        "drive": {
            "auth": "user",
            "copy": {
                "source": "https://docs.google.com/spreadsheets/d/1Su3t2YUWV_GG9RD63Wa3GNANmQZswTHstFY6aDPm6qE/",
                "destination": {
                    "field": {
                        "name": "recipe_name",
                        "kind": "string",
                        "order": 1,
                        "description": "Name of document to deploy to.",
                        "default": ""
                    }
                }
            }
        }
    },
    {
        "dataset": {
            "auth": {
                "field": {
                    "name": "auth_write",
                    "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."
                }
            }
        }
    },
    {
        "cm_report_replicate": {
            "auth": {
                "field": {
                    "name": "auth_read",
                    "kind": "authentication",
                    "order": 0,
                    "default": "user",
                    "description": "Credentials used for reading data."
                }
            },
            "report": {
                "account": {
                    "field": {
                        "name": "account",
                        "kind": "integer",
                        "order": 3,
                        "default": "",
                        "description": "CM network id."
                    }
                },
                "id": {
                    "field": {
                        "name": "report_id",
                        "kind": "integer",
                        "order": 4,
                        "default": "",
                        "description": "CM template report id, for template"
                    }
                },
                "name": {
                    "field": {
                        "name": "report_name",
                        "kind": "string",
                        "order": 5,
                        "default": "",
                        "description": "CM template report name, empty if using id instead."
                    }
                },
                "delete": {
                    "field": {
                        "name": "delete",
                        "kind": "boolean",
                        "order": 6,
                        "default": false,
                        "description": "Use only to reset the reports if setup changes."
                    }
                }
            },
            "replicate": {
                "sheets": {
                    "sheet": {
                        "field": {
                            "name": "recipe_name",
                            "kind": "string",
                            "order": 1,
                            "default": "",
                            "description": "Sheet to read ids from."
                        }
                    },
                    "tab": "Accounts",
                    "range": ""
                }
            },
            "write": {
                "bigquery": {
                    "dataset": {
                        "field": {
                            "name": "recipe_slug",
                            "kind": "string",
                            "order": 4,
                            "default": ""
                        }
                    },
                    "is_incremental_load": {
                        "field": {
                            "name": "Aggregate",
                            "kind": "boolean",
                            "order": 7,
                            "default": false,
                            "description": "Append report data to existing table, requires Date column."
                        }
                    }
                }
            }
        }
    }
]


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