Liscor
/ botd_gtm.js
Last active
April 4, 2025 18:02
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (async () => { | |
| try { | |
| const Botd = await import('https://openfpcdn.io/botd/v1'); | |
| const botd = await Botd.load(); | |
| const result = await botd.detect(); | |
| let window.gtm_botd = result; | |
| console.log(result); | |
| } catch (error) { | |
| console.error(error); |
Liscor
/ bq_change_history.sql
Created
January 18, 2025 12:50
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Activate Change History for a BigQuery table | |
| ALTER TABLE IF EXISTS | |
| `XXX.analytics_XXX.events_20250113` | |
| SET | |
| OPTIONS(enable_change_history=TRUE) | |
| -- Query Changes for a day maximum | |
| select | |
| parse_date('%Y%m%d',event_date) as event_date | |
| ,platform | |
| ,_change_type |