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.
Calculate DV360 cost at the dynamic creative combination level.
| Add a sheet URL. This is where you will enter advertiser and campaign level details. |
| Specify the CM network ID. |
| Click run now once, and a tab called Dynamic Costs will be added to the sheet with instructions. |
| Follow the instructions on the sheet; this will be your configuration. |
| StarThinker will create two or three (depending on the case) reports in CM named Dynamic Costs - .... |
| Wait for BigQuery->->->Dynamic_Costs_Analysis to be created or click Run Now. |
| Copy Dynamic Costs Sample Data. |
| Click Edit Connection, and Change to BigQuery->->->Dynamic_Costs_Analysis. |
| Copy Dynamic Costs Sample Report. |
| When prompted, choose the new data source you just created. |
| Edit the table to include or exclude columns as desired. |
| Or, give the dashboard connection intructions to the client. |
| Open Source | YES |
| Age | July 13, 2018 (4 years, 5 months) |
| Authors | aritrab@google.com kenjora@google.com |
| Shedule Days | Configured by user. |
| Shedule Hours | Configured by user. |
[
{
"dynamic_costs": {
"auth": {
"field": {
"name": "auth_read",
"kind": "authentication",
"order": 1,
"default": "user",
"description": "Credentials used for reading data."
}
},
"account": {
"field": {
"name": "dcm_account",
"kind": "string",
"order": 0,
"default": ""
}
},
"sheet": {
"template": {
"url": "https://docs.google.com/spreadsheets/d/19J-Hjln2wd1E0aeG3JDgKQN9TVGRLWxIEUQSmmQetJc/edit?usp=sharing",
"tab": "Dynamic Costs",
"range": "A1"
},
"url": {
"field": {
"name": "configuration_sheet_url",
"kind": "string",
"order": 1,
"default": ""
}
},
"tab": "Dynamic Costs",
"range": "A2:B"
},
"out": {
"auth": {
"field": {
"name": "auth_write",
"kind": "authentication",
"order": 1,
"default": "service",
"description": "Credentials used for writing data."
}
},
"dataset": {
"field": {
"name": "bigquery_dataset",
"kind": "string",
"order": 2,
"default": "dynamic_costs"
}
}
}
}
}
]Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.