Skip to content

Instantly share code, notes, and snippets.

[
{
"title": "I am a mediocre developer",
"author": "Nikita Sobolev",
"date": "Mar 13 '18",
"tags": [
"#meta",
"#career",
"#beginners",
"#productivity"
# arrayDataTypesCheck - check input array data types for every element
# Chuck Norris API
# Loop through nested objects
# Mixin - Object.assign
# Promises (in the dark), thank you Pat Benatar
# Reduce - Using reduce to filter
# Regex - Common
# Rest Operator
# Show more or less, pure JS
# Spread Operator (Okay, Okay, let's keep the juvenile humor down to a minimum).
@abstraction
abstraction / multi_channel_attribution.sql
Created February 10, 2020 20:13 — forked from markrittman/multi_channel_attribution.sql
Multi-Channel Attribution Standard SQL query for Google BigQuery sourcing session data from Segment and attributed value from operational system
WITH session_attributiON AS
(SELECT *,
CASE WHEN session_id = LAST_VALUE(session_id)
OVER (partitiON by user_id order by session_start_tstamp ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) THEN 1
ELSE 0
END AS LAST_click_attrib_pct,
CASE WHEN session_id = FIRST_VALUE(session_id)
OVER (partitiON by user_id order by session_start_tstamp ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) THEN 1
ELSE 0
END AS first_click_attrib_pct,
@abstraction
abstraction / google-dorks
Created February 3, 2020 19:27 — forked from stevenswafford/google-dorks
Listing of a number of useful Google dorks.
" _ _ "
" _ /|| . . ||\ _ "
" ( } \||D ' ' ' C||/ { % "
" | /\__,=_[_] ' . . ' [_]_=,__/\ |"
" |_\_ |----| |----| _/_|"
" | |/ | | | | \| |"
" | /_ | | | | _\ |"
It is all fun and games until someone gets hacked!