Skip to content

Instantly share code, notes, and snippets.

Andy Wingrave walkerofmargins

View GitHub Profile
View [Win] Data-Review.js
var params = {
number_of_days: 7,
sample_percentage: 1,
libs: {'web':''},
last_seen: 'Registration Date',
csv_format: true,
people_spec: ["Community member"]
}
var defaults = ["$city", "$region", "mp_country_code", "$brand", "$bluetooth_version", "$device", "$os", "$app_release", "$app_version", "$carrier", "$lib_version", "$wifi", "$screen_width", "$screen_height", "$model", "$os_version", "$manufacturer", "$screen_dpi", "$has_telephone", "has_nfc", "$bluetooth_enabled", "$browser", "$initial_referrer", "$initial_referring_domain", "$referrer", "$referring_domain", "$browser_version", "mp_keyword", "$search_engine", "utm_source", "utm_medium", "utm_campaign", "utm_content", "utm_term", "$radio", "mp_device_model", "$google_play_services", "mp_lib", "campaign_id", "message_id", "message_subtype", "message_type", "$answer_count", "survey_id", "collection_id", "$survey_shown", "$watch_model", "$ios_ifa", "$current_url", "$duration", "$from_binding", "$experiments", "$import", "distinct_id", "time",
@walkerofmargins
walkerofmargins / [Win] Events in Airplane mode.js
Created Mar 6, 2019
Events where the difference in ingestion time and event time is greater than x
View [Win] Events in Airplane mode.js
var params = {
timezone_offset: -8,
minutes_gaps: 60
}
function main() {
return Events({
from_date: '2019-02-01',
to_date: '2019-02-28',
event_selectors: [{event: 'Game Played'}]
View [Win] Snack Overflow - JQL Demo.js
//////////////////////////////////////////////////////////
/* Return an event count grouped by a single property */
//////////////////////////////////////////////////////////
function main() {
return Events({
from_date: '2018-02-10',
to_date: '2019-02-20',
event_selectors: [{
event: 'Shopping List Add'
@walkerofmargins
walkerofmargins / [Win] MTU Overage - Single Event.js
Last active Mar 6, 2019
JQL to identify MTU issue where a single event caused an overage
View [Win] MTU Overage - Single Event.js
function main() {
return Events({
/* Dec */
from_date: "2018-12-01",
to_date: "2018-12-31",
// /* Jan */
// from_date: "2019-01-01",
// to_date: "2019-01-31",
// /* Feb */
You can’t perform that action at this time.