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

security

CM360 Log Audit

Downloads Campaign manager logs and allows audits.

CM360 Log Audit 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

Meet contractual access reporting information.
Reduce unauthorized use of CM accounts and assets.
Audit user access within CM.
Prevent malicious user access / behavior.

Instructions

Wait for BigQuery->->->CM_... to be created.
Wait for BigQuery->->->Barnacle_... to be created, then copy and connect the following data sources.
Join the StarThinker Assets Group to access the following assets
Copy Barnacle Profile Advertiser Map and connect.
Copy Barnacle Profile Campaign Map and connect.
Copy Barnacle Profile Site Map and connect.
Copy Barnacle Profiles Connections and connect.
Copy Barnacle Report Delivery Profiles and connect.
Copy Barnacle Roles Duplicates and connect.
Copy Barnacle Roles Not Used and connect.
Copy Barnacle Site Contacts Profiles and connect.
If reports checked, copy Barnacle Profile Report Map and connect.
Copy Barnacle Report.
When prompted choose the new data sources you just created.
Or give these intructions to the client.

Details

Open Source YES
Age Aug. 24, 2019 (3 years, 4 months)
Authors kenjora@google.com
Shedule Days Configured by user.
Shedule Hours 1, 2
[
    {
        "dataset": {
            "description": "The dataset will hold log table, Create it exists.",
            "hour": [
                1
            ],
            "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": 4,
                    "default": "",
                    "description": "Name of Google BigQuery dataset to create."
                }
            }
        }
    },
    {
        "dcm_log": {
            "description": "Will create tables with format CM_* to hold each endpoint via a call to the API list function. Exclude reports for its own task.",
            "hour": [
                2
            ],
            "auth": {
                "field": {
                    "name": "auth_read",
                    "kind": "authentication",
                    "order": 0,
                    "default": "user",
                    "description": "Credentials used for reading data."
                }
            },
            "accounts": {
                "single_cell": true,
                "values": {
                    "field": {
                        "name": "accounts",
                        "kind": "integer_list",
                        "order": 2,
                        "default": [],
                        "description": "Comma separated CM account ids."
                    }
                }
            },
            "days": {
                "field": {
                    "name": "days",
                    "kind": "integer",
                    "order": 3,
                    "default": 7,
                    "description": "Number of days to backfill the log, works on first run only."
                }
            },
            "out": {
                "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": 5,
                        "default": "",
                        "description": "Google BigQuery dataset to create tables in."
                    }
                }
            }
        }
    }
]


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