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.
Move from BigQuery to CM.
| Specify a CM Account ID, Floodligh Activity ID and Conversion Type. |
| Include BigQuery dataset and table. |
| Columns: Ordinal, timestampMicros, quantity, value, encryptedUserId | encryptedUserIdCandidates | gclid | mobileDeviceId | matchId | dclid |
| Include encryption information if using encryptedUserId or encryptedUserIdCandidates. |
| Open Source | YES |
| Age | March 16, 2018 (4 years, 9 months) |
| Authors | kenjora@google.com |
| Shedule Days | Configured by user. |
| Shedule Hours | Configured by user. |
[
{
"conversion_upload": {
"auth": {
"field": {
"name": "auth_cm",
"kind": "authentication",
"order": 1,
"default": "user",
"description": "Credentials used for CM."
}
},
"account_id": {
"field": {
"name": "account",
"kind": "string",
"order": 0,
"default": ""
}
},
"activity_id": {
"field": {
"name": "floodlight_activity_id",
"kind": "integer",
"order": 1,
"default": ""
}
},
"conversion_type": {
"field": {
"name": "floodlight_conversion_type",
"kind": "choice",
"order": 2,
"choices": [
"encryptedUserId",
"encryptedUserIdCandidates",
"dclid",
"gclid",
"matchId",
"mobileDeviceId"
],
"default": "encryptedUserId",
"description": "Must match the values specifed in the last column."
}
},
"encryptionInfo": {
"encryptionEntityId": {
"field": {
"name": "encryption_entity_id",
"kind": "integer",
"order": 3,
"default": "",
"description": "Typically the same as the account id."
}
},
"encryptionEntityType": {
"field": {
"name": "encryption_entity_type",
"kind": "choice",
"order": 4,
"choices": [
"ADWORDS_CUSTOMER",
"DBM_ADVERTISER",
"DBM_PARTNER",
"DCM_ACCOUNT",
"DCM_ADVERTISER",
"DFP_NETWORK_CODE"
],
"default": "DCM_ACCOUNT"
}
},
"encryptionSource": {
"field": {
"name": "encryption_entity_source",
"kind": "choice",
"order": 5,
"choices": [
"AD_SERVING",
"DATA_TRANSFER"
],
"default": "DATA_TRANSFER"
}
}
},
"from": {
"bigquery": {
"auth": {
"field": {
"name": "auth_bigquery",
"kind": "authentication",
"order": 1,
"default": "user",
"description": "Credentials for BigQuery."
}
},
"dataset": {
"field": {
"name": "dataset",
"kind": "string",
"order": 6,
"default": "Source containing the conversion data."
}
},
"table": {
"field": {
"name": "table",
"kind": "string",
"order": 7,
"default": "Source containing the conversion data."
}
},
"legacy": {
"field": {
"name": "legacy",
"kind": "boolean",
"order": 8,
"default": false,
"description": "Matters if source is a view."
}
}
}
}
}
}
]Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.