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.
Replicate a report across multiple networks and advertisers.
| 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 |
| Open Source | YES |
| Age | March 3, 2020 (2 years, 10 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."
}
}
}
}
}
}
]Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.