{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":629600404,"defaultBranch":"main","name":"marketing-analytics-jumpstart-dataform","ownerLogin":"GoogleCloudPlatform","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-04-18T16:30:14.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/2810941?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1712831382.0","currentOid":""},"activityList":{"items":[{"before":"2e71e7becde3a1ed83a6bd3f0d65d389435d2c52","after":"d68ba0f34a48efaeada1595b8c723435869914e5","ref":"refs/heads/main","pushedAt":"2024-04-16T16:07:36.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"chmstimoteo","name":"Carlos Timoteo","path":"/chmstimoteo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16627815?s=80&v=4"},"commit":{"message":"Merge pull request #23 from kingman/ga4-event-view-with-safe-cast\n\nfix data cast type issues in ga4 event data","shortMessageHtmlLink":"Merge pull request #23 from kingman/ga4-event-view-with-safe-cast"}},{"before":"7ec1282857f727f81e4e479fb10070d76be76b97","after":null,"ref":"refs/heads/dependabot/npm_and_yarn/protobufjs-7.2.6","pushedAt":"2024-04-11T10:29:42.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"}},{"before":"f08423ba1c1fb401adf52337bf219ba28f9a657b","after":"2e71e7becde3a1ed83a6bd3f0d65d389435d2c52","ref":"refs/heads/main","pushedAt":"2024-04-11T10:29:35.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"kingman","name":"Charlie Wang","path":"/kingman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2144018?s=80&v=4"},"commit":{"message":"Bump protobufjs from 7.2.4 to 7.2.6 (#22)\n\nBumps [protobufjs](https://github.com/protobufjs/protobuf.js) from 7.2.4 to 7.2.6.\r\n- [Release notes](https://github.com/protobufjs/protobuf.js/releases)\r\n- [Changelog](https://github.com/protobufjs/protobuf.js/blob/master/CHANGELOG.md)\r\n- [Commits](https://github.com/protobufjs/protobuf.js/compare/protobufjs-v7.2.4...protobufjs-v7.2.6)\r\n\r\n---\r\nupdated-dependencies:\r\n- dependency-name: protobufjs\r\n dependency-type: indirect\r\n...\r\n\r\nSigned-off-by: dependabot[bot] \r\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>","shortMessageHtmlLink":"Bump protobufjs from 7.2.4 to 7.2.6 (#22)"}},{"before":null,"after":"7ec1282857f727f81e4e479fb10070d76be76b97","ref":"refs/heads/dependabot/npm_and_yarn/protobufjs-7.2.6","pushedAt":"2024-04-10T22:03:29.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"},"commit":{"message":"Bump protobufjs from 7.2.4 to 7.2.6\n\nBumps [protobufjs](https://github.com/protobufjs/protobuf.js) from 7.2.4 to 7.2.6.\n- [Release notes](https://github.com/protobufjs/protobuf.js/releases)\n- [Changelog](https://github.com/protobufjs/protobuf.js/blob/master/CHANGELOG.md)\n- [Commits](https://github.com/protobufjs/protobuf.js/compare/protobufjs-v7.2.4...protobufjs-v7.2.6)\n\n---\nupdated-dependencies:\n- dependency-name: protobufjs\n dependency-type: indirect\n...\n\nSigned-off-by: dependabot[bot] ","shortMessageHtmlLink":"Bump protobufjs from 7.2.4 to 7.2.6"}},{"before":"d2a247a30d7babfbd23153feb915246add0342ce","after":"f08423ba1c1fb401adf52337bf219ba28f9a657b","ref":"refs/heads/main","pushedAt":"2024-03-25T15:33:36.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"kingman","name":"Charlie Wang","path":"/kingman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2144018?s=80&v=4"},"commit":{"message":"add new view (#21)\n\n* add the view\r\n\r\n* adjustment according to PR review comments","shortMessageHtmlLink":"add new view (#21)"}},{"before":"0771e1092d46760252e7bdc7d0c609ec5080b4eb","after":"d2a247a30d7babfbd23153feb915246add0342ce","ref":"refs/heads/main","pushedAt":"2024-03-21T07:43:12.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"kingman","name":"Charlie Wang","path":"/kingman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2144018?s=80&v=4"},"commit":{"message":"add pre-operation to add the missing column (#20)\n\n* add pre-operation to add the missing column\r\n\r\n* backfill script\r\n\r\n* review comment updates","shortMessageHtmlLink":"add pre-operation to add the missing column (#20)"}},{"before":"f04ee50e3af417541f687c2de1f136c13329d5dc","after":"0771e1092d46760252e7bdc7d0c609ec5080b4eb","ref":"refs/heads/main","pushedAt":"2024-03-11T19:25:52.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"kingman","name":"Charlie Wang","path":"/kingman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2144018?s=80&v=4"},"commit":{"message":"Update README.md (#19)","shortMessageHtmlLink":"Update README.md (#19)"}},{"before":"21eab62289da78ba593bab543850b09604ed88a5","after":"f04ee50e3af417541f687c2de1f136c13329d5dc","ref":"refs/heads/main","pushedAt":"2024-03-08T20:03:47.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"chmstimoteo","name":"Carlos Timoteo","path":"/chmstimoteo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16627815?s=80&v=4"},"commit":{"message":"Merge pull request #17 from edemir/main\n\nAdd collected_traffic_source data source and add it to the events.","shortMessageHtmlLink":"Merge pull request #17 from edemir/main"}},{"before":"e9c9023fd1303780143e46d3050a8b276eb22f94","after":"21eab62289da78ba593bab543850b09604ed88a5","ref":"refs/heads/main","pushedAt":"2024-03-08T20:03:29.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"chmstimoteo","name":"Carlos Timoteo","path":"/chmstimoteo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16627815?s=80&v=4"},"commit":{"message":"Merge pull request #18 from kingman/fix-null-language\n\nreplace null value with empty string for language field","shortMessageHtmlLink":"Merge pull request #18 from kingman/fix-null-language"}},{"before":"ed57a2a89bca346bb990ce73e423776b0a0e580c","after":"e9c9023fd1303780143e46d3050a8b276eb22f94","ref":"refs/heads/main","pushedAt":"2023-11-10T17:26:52.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"kingman","name":"Charlie Wang","path":"/kingman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2144018?s=80&v=4"},"commit":{"message":"explicit select columns from repeated nested field: items. Avoid breaking schema when new fields are added to nested struct (#15)","shortMessageHtmlLink":"explicit select columns from repeated nested field: items. Avoid brea…"}},{"before":"3b6ce0dd01fefa0586ad3dc76218d746a6ec3079","after":"ed57a2a89bca346bb990ce73e423776b0a0e580c","ref":"refs/heads/main","pushedAt":"2023-11-03T18:39:20.000Z","pushType":"pr_merge","commitsCount":5,"pusher":{"login":"chmstimoteo","name":"Carlos Timoteo","path":"/chmstimoteo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16627815?s=80&v=4"},"commit":{"message":"Merge pull request #14 from kingman/vbb-optimize\n\nOptimize query for the Aggregated_VBB view","shortMessageHtmlLink":"Merge pull request #14 from kingman/vbb-optimize"}},{"before":"b474222c3d1655a93c953de57db98fa07c3baa0e","after":"3b6ce0dd01fefa0586ad3dc76218d746a6ec3079","ref":"refs/heads/main","pushedAt":"2023-10-23T14:34:51.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"kingman","name":"Charlie Wang","path":"/kingman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2144018?s=80&v=4"},"commit":{"message":"Chwa branch (#12)\n\n* only select the current ads from the dim_ads table, to avoid multiple counting on conversions and performance\r\n\r\n* create view for aggregated_vbb","shortMessageHtmlLink":"Chwa branch (#12)"}},{"before":"de195e18f57bb6192848cb1fa889815ef7b12e97","after":null,"ref":"refs/heads/dependabot/npm_and_yarn/semver-7.5.4","pushedAt":"2023-10-23T14:19:02.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"chmstimoteo","name":"Carlos Timoteo","path":"/chmstimoteo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16627815?s=80&v=4"}},{"before":"3c8957536de5da1f42dbd8e3cacbb498fd97fc6e","after":"b474222c3d1655a93c953de57db98fa07c3baa0e","ref":"refs/heads/main","pushedAt":"2023-10-23T14:18:57.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"chmstimoteo","name":"Carlos Timoteo","path":"/chmstimoteo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16627815?s=80&v=4"},"commit":{"message":"Merge pull request #13 from GoogleCloudPlatform/dependabot/npm_and_yarn/semver-7.5.4\n\nBump semver from 7.3.8 to 7.5.4","shortMessageHtmlLink":"Merge pull request #13 from GoogleCloudPlatform/dependabot/npm_and_ya…"}},{"before":null,"after":"de195e18f57bb6192848cb1fa889815ef7b12e97","ref":"refs/heads/dependabot/npm_and_yarn/semver-7.5.4","pushedAt":"2023-10-20T20:24:33.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"},"commit":{"message":"Bump semver from 7.3.8 to 7.5.4\n\nBumps [semver](https://github.com/npm/node-semver) from 7.3.8 to 7.5.4.\n- [Release notes](https://github.com/npm/node-semver/releases)\n- [Changelog](https://github.com/npm/node-semver/blob/main/CHANGELOG.md)\n- [Commits](https://github.com/npm/node-semver/compare/v7.3.8...v7.5.4)\n\n---\nupdated-dependencies:\n- dependency-name: semver\n dependency-type: indirect\n...\n\nSigned-off-by: dependabot[bot] ","shortMessageHtmlLink":"Bump semver from 7.3.8 to 7.5.4"}},{"before":"81149106249080aa7ecb4542f33df696ba769370","after":null,"ref":"refs/heads/dependabot/npm_and_yarn/protobufjs-7.2.4","pushedAt":"2023-10-20T20:23:40.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"}},{"before":"fc365a8b829d1c23a6d15abc239e521939044f18","after":"3c8957536de5da1f42dbd8e3cacbb498fd97fc6e","ref":"refs/heads/main","pushedAt":"2023-10-20T20:23:33.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"kingman","name":"Charlie Wang","path":"/kingman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2144018?s=80&v=4"},"commit":{"message":"Bump protobufjs from 7.1.2 to 7.2.4 (#10)\n\nBumps [protobufjs](https://github.com/protobufjs/protobuf.js) from 7.1.2 to 7.2.4.\r\n- [Release notes](https://github.com/protobufjs/protobuf.js/releases)\r\n- [Changelog](https://github.com/protobufjs/protobuf.js/blob/master/CHANGELOG.md)\r\n- [Commits](https://github.com/protobufjs/protobuf.js/compare/protobufjs-v7.1.2...protobufjs-v7.2.4)\r\n\r\n---\r\nupdated-dependencies:\r\n- dependency-name: protobufjs\r\n dependency-type: indirect\r\n...\r\n\r\nSigned-off-by: dependabot[bot] \r\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>","shortMessageHtmlLink":"Bump protobufjs from 7.1.2 to 7.2.4 (#10)"}},{"before":"b9e7025fb3de6b576800fe1414d43b1389f98458","after":"fc365a8b829d1c23a6d15abc239e521939044f18","ref":"refs/heads/main","pushedAt":"2023-09-27T10:43:09.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"kingman","name":"Charlie Wang","path":"/kingman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2144018?s=80&v=4"},"commit":{"message":"only select the current ads from the dim_ads table, to avoid multiple counting on conversions and performance (#11)","shortMessageHtmlLink":"only select the current ads from the dim_ads table, to avoid multiple…"}},{"before":null,"after":"81149106249080aa7ecb4542f33df696ba769370","ref":"refs/heads/dependabot/npm_and_yarn/protobufjs-7.2.4","pushedAt":"2023-08-15T22:21:41.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"},"commit":{"message":"Bump protobufjs from 7.1.2 to 7.2.4\n\nBumps [protobufjs](https://github.com/protobufjs/protobuf.js) from 7.1.2 to 7.2.4.\n- [Release notes](https://github.com/protobufjs/protobuf.js/releases)\n- [Changelog](https://github.com/protobufjs/protobuf.js/blob/master/CHANGELOG.md)\n- [Commits](https://github.com/protobufjs/protobuf.js/compare/protobufjs-v7.1.2...protobufjs-v7.2.4)\n\n---\nupdated-dependencies:\n- dependency-name: protobufjs\n dependency-type: indirect\n...\n\nSigned-off-by: dependabot[bot] ","shortMessageHtmlLink":"Bump protobufjs from 7.1.2 to 7.2.4"}},{"before":"82325ed6cd5f4585653c81c607c06dd6224d8ccd","after":null,"ref":"refs/heads/chmstimoteo-patch-1","pushedAt":"2023-08-14T20:50:37.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"chmstimoteo","name":"Carlos Timoteo","path":"/chmstimoteo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16627815?s=80&v=4"}},{"before":"956a564cb0d33f7cbca156f8c052eab205760625","after":"b9e7025fb3de6b576800fe1414d43b1389f98458","ref":"refs/heads/main","pushedAt":"2023-08-14T20:50:33.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"chmstimoteo","name":"Carlos Timoteo","path":"/chmstimoteo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16627815?s=80&v=4"},"commit":{"message":"Merge pull request #9 from GoogleCloudPlatform/chmstimoteo-patch-1\n\nUpdate README.md","shortMessageHtmlLink":"Merge pull request #9 from GoogleCloudPlatform/chmstimoteo-patch-1"}},{"before":null,"after":"82325ed6cd5f4585653c81c607c06dd6224d8ccd","ref":"refs/heads/chmstimoteo-patch-1","pushedAt":"2023-08-14T20:47:10.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"chmstimoteo","name":"Carlos Timoteo","path":"/chmstimoteo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16627815?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"5bad6f79d073e9fa9bbb3e9f26981b7055bac7b0","after":null,"ref":"refs/heads/sync-20230609-191940","pushedAt":"2023-06-12T15:55:49.971Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"TXZebra","name":"Monty Chavez","path":"/TXZebra","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/57365811?s=80&v=4"}},{"before":"d92f7b0749a0a8f2220071b0a79803c5cc41f965","after":"956a564cb0d33f7cbca156f8c052eab205760625","ref":"refs/heads/main","pushedAt":"2023-06-12T15:55:46.020Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"TXZebra","name":"Monty Chavez","path":"/TXZebra","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/57365811?s=80&v=4"},"commit":{"message":"Merge pull request #8 from GoogleCloudPlatform/sync-20230609-191940\n\nUpdates to include conversion action as one of the business keys in the conversion fact table.","shortMessageHtmlLink":"Merge pull request #8 from GoogleCloudPlatform/sync-20230609-191940"}},{"before":null,"after":"5bad6f79d073e9fa9bbb3e9f26981b7055bac7b0","ref":"refs/heads/sync-20230609-191940","pushedAt":"2023-06-10T00:24:19.475Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"TXZebra","name":"Monty Chavez","path":"/TXZebra","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/57365811?s=80&v=4"},"commit":{"message":"Updates to include conversion action as one of the business keys in the conversion fact table.","shortMessageHtmlLink":"Updates to include conversion action as one of the business keys in t…"}},{"before":"6283909c1eb9b015c9698e352fb31786c58af035","after":null,"ref":"refs/heads/sync-20230607-174213","pushedAt":"2023-06-07T23:41:01.188Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"TXZebra","name":"Monty Chavez","path":"/TXZebra","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/57365811?s=80&v=4"}},{"before":"e9bfb88308079bc6d4f463aaf5586be9f9df1e51","after":"d92f7b0749a0a8f2220071b0a79803c5cc41f965","ref":"refs/heads/main","pushedAt":"2023-06-07T23:40:57.322Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"TXZebra","name":"Monty Chavez","path":"/TXZebra","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/57365811?s=80&v=4"},"commit":{"message":"Merge pull request #7 from GoogleCloudPlatform/sync-20230607-174213\n\nFixed ad conversion update bug and removed references to tracker id.","shortMessageHtmlLink":"Merge pull request #7 from GoogleCloudPlatform/sync-20230607-174213"}},{"before":null,"after":"6283909c1eb9b015c9698e352fb31786c58af035","ref":"refs/heads/sync-20230607-174213","pushedAt":"2023-06-07T22:47:39.170Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"TXZebra","name":"Monty Chavez","path":"/TXZebra","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/57365811?s=80&v=4"},"commit":{"message":"Fixed ad conversion update bug and removed references to tracker id.","shortMessageHtmlLink":"Fixed ad conversion update bug and removed references to tracker id."}},{"before":"e09d87ced2242ee959fc19e1f098b65ae570a1c5","after":null,"ref":"refs/heads/sync-20230531-113206","pushedAt":"2023-05-31T16:38:09.087Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"TXZebra","name":"Monty Chavez","path":"/TXZebra","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/57365811?s=80&v=4"}},{"before":"b9a0b7f6d84d5c33a46a61de383872b51def2b98","after":"e9bfb88308079bc6d4f463aaf5586be9f9df1e51","ref":"refs/heads/main","pushedAt":"2023-05-31T16:38:05.812Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"TXZebra","name":"Monty Chavez","path":"/TXZebra","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/57365811?s=80&v=4"},"commit":{"message":"Merge pull request #6 from GoogleCloudPlatform/sync-20230531-113206\n\nFixed bug in ad_stats view for cost calculation.","shortMessageHtmlLink":"Merge pull request #6 from GoogleCloudPlatform/sync-20230531-113206"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEMjZGsAA","startCursor":null,"endCursor":null}},"title":"Activity · GoogleCloudPlatform/marketing-analytics-jumpstart-dataform"}