Periklis Papanikolaou admariner
coolaj86
/ ChatGPT-Dan-Jailbreak.md
Last active
July 8, 2025 19:52
ZordnajelA
/ ga4_traffic_source_session_level.sql
Last active
February 19, 2024 03:30
Using SQL FIRST_VALUE() window function to replicate GA4 traffic source attribution behavior
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
| FIRST_VALUE( | |
| (SELECT | |
| value.string_value | |
| FROM | |
| UNNEST(event_params) | |
| WHERE | |
| key = 'name_of_traffic_source_parameter' | |
| --source, medium, campaign, content, term, campaign_id | |
| ) |
manchumahara
/ gist:dc88a6b9b157ada5f02cb8408653b80f
Created
September 21, 2022 04:53
Google My Business Categories (Json formatted)
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
| [ | |
| "Abbey", | |
| "Aboriginal and Torres Strait Islander organization", | |
| "Aboriginal art gallery", | |
| "Abortion clinic", | |
| "Abrasives supplier", | |
| "Abundant Life church", | |
| "Accountant", | |
| "Accounting firm", | |
| "Accounting school", |
ZordnajelA
/ ga4_session_scope_custom_dimension.sql
Last active
February 19, 2024 06:24
Using SQL window functions to replicate Google Analytics custom dimensions behavior
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
| LAST_VALUE( | |
| (SELECT | |
| value.string_value --value.int_value, value.float_value, value.double_value | |
| FROM | |
| UNNEST(event_params) | |
| WHERE | |
| key = 'name_of_event_parameter_to_use_as_dimension' | |
| ) | |
| IGNORE nulls | |
| ) OVER ( |
luratic-devs
/ GA4 - Dimensions & Metrics Cheatsheet - Changelog.md
Last active
February 2, 2025 16:20
GA4 - Dimensions & Metrics Cheatsheet - Changelog.md
Learn about the new features and functionalities in the GA4 Dimensions and Metrics Cheatsheet release notes.
New Metrics and Dimensions
karpathy
/ stablediffusionwalk.py
Last active
June 29, 2025 09:56
hacky stablediffusion code for generating videos
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
| """ | |
| stable diffusion dreaming | |
| creates hypnotic moving videos by smoothly walking randomly through the sample space | |
| example way to run this script: | |
| $ python stablediffusionwalk.py --prompt "blueberry spaghetti" --name blueberry | |
| to stitch together the images, e.g.: | |
| $ ffmpeg -r 10 -f image2 -s 512x512 -i blueberry/frame%06d.jpg -vcodec libx264 -crf 10 -pix_fmt yuv420p blueberry.mp4 |
eliasdabbas
/ mutlilevel_treemap.py
Last active
June 10, 2022 17:03
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
| import plotly.express as px | |
| def treemap(traffic_df, metric='Users', path=['Medium', 'Source']): | |
| """Make in interactive treemap for two data dimensions/levels. | |
| Parameters: | |
| ----------- | |
| traffic_df : A DataFrame containing two dimensions, and one or more metrics | |
RomainVialard
/ Get indexes of selected rows.gs
Last active
August 16, 2024 00:32
Google Apps Script - Google Sheets - Use the getActiveRangeList() method to get indexes of selected rows
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
| function myFunction() { | |
| const sheet = SpreadsheetApp.getActiveSheet(); | |
| const data = sheet.getDataRange().getValues(); | |
| const selectedRows = getIndexesOfSelectedRows(sheet); | |
| for (let i = 0; i < data.length; i++) { | |
| // skip not selected rows | |
| if (!selectedRows.includes(i + 1)) continue; | |
| const rowData = data[i]; | |
| console.log(rowData); | |
| // perform the relevant action: generate a document, send an email,... |
ioannispol
/ conda-env-setup.sh
Last active
September 6, 2024 01:43
Automate Anaconda environment creation
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
| #!/usr/bin/env bash | |
| SECONDS=0 | |
| source ~/miniconda3/etc/profile.d/conda.sh | |
| # Set miniconda environment path | |
| ENV_PATH="$HOME/miniconda3/envs" | |
| echo "The folowing environments are installed:$(ls $ENV_PATH)" |
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
| { | |
| "createdBy": "Redirector v3.5.3", | |
| "createdAt": "2023-05-24T14:38:35.748Z", | |
| "redirects": [ | |
| { | |
| "description": "Wikipedia -> Wikiless", | |
| "exampleUrl": "https://en.wikipedia.org/wiki/XYZ", | |
| "exampleResult": "https://farside.link/wikiless/wiki/XYZ", | |
| "error": null, | |
| "includePattern": "*wikipedia.org/*", |