Skip to content

Instantly share code, notes, and snippets.

View tradingbills's full-sized avatar

Jason Ashley tradingbills

0 followers · 2 following
  • Los Alamitos, CA
View GitHub Profile
@tradingbills
tradingbills / Webhook Curl from Postman for Slack
Created August 6, 2016 06:31
curl --request POST \
--url https://hooks.slack.com/services/T06EH0294/B1VJZGDKQ/43L... \
--header 'cache-control: no-cache' \
--form 'payload={"new-bot-name":"Agenda","username": "Agenda","icon_emoji":":googledoc:","text": "<{Place Doc Here}|Google Doc : 2016 - Weekly Apps - API Meeting>"}'
@tradingbills
tradingbills / intercom TFP new signup by dateRange
Last active March 1, 2018 16:08
mongodb query Col1
var collName= 20180301
// 2018-03-01 00:00:00 to
// 2018-03-01 23:59:59
var dateRange= {"$gte":1519862400,"$lte":1519948799}
var queryDoc; queryDoc.signed_up_at = dateRange
db.getCollection(`${collName}`).aggregate([
{ "$match": queryDoc }
,{ "$group":{ "_id" : null,
// "Plan Names": { "$addToSet": { "api_plan_name" : "$custom_attributes.api_plan_name"}},
@tradingbills
tradingbills / 7.a Signedup and Upgraded in Date RangeItemized by ID.js
Last active March 2, 2018 15:52
Signedup and Paid within dateRange, Itemized who and what
var collName= 20180302
// 2018-03-02 00:00:00 to
// 2018-03-02 23:59:59
var dateRange= {"$gte":1519948800,"$lte":1520035199}
var queryDoc; queryDoc.signed_up_at = dateRange
var paid = "59deb60085a3c22795133b02"
var free = "59dfe40a0a5037ff1c0bd8af"
var segPaidOrFree = paid
@tradingbills
tradingbills / 7.a Signedup and Upgraded in Date Range as Count.js
Last active March 2, 2018 15:54
Signedup and Paid within dateRange, Count
var collName= 20180302
// 2018-03-02 00:00:00 to
// 2018-03-02 23:59:59
var dateRange= {"$gte":1519948800,"$lte":1520035199}
var queryDoc; queryDoc.signed_up_at = dateRange
var paid = "59deb60085a3c22795133b02"
var free = "59dfe40a0a5037ff1c0bd8af"
queryDoc["segments.segments.id"] = paid;
@tradingbills
tradingbills / intercom TFP new signup by dateRange Active Segment by dateRange.js
Last active March 2, 2018 15:55
ACT,SU
var collName= 20180301
// 2018-03-01 00:00:00 to
// 2018-03-01 23:59:59
var dateRange= {"$gte":1519862400,"$lte":1519948799}
var queryDoc; queryDoc.signed_up_at = dateRange
var segments = {
"id": "5a709f20e8a46fcd9c0c5d37",
"name": "_HAS ACTIVITY"
}
@tradingbills
tradingbills / mongodb query Col1.b Segmented by Region.js
Last active March 2, 2018 15:55
intercom TFP new signup by dateRange Segmented by Region
var collName= 20180301
// 2018-03-01 00:00:00 to
// 2018-03-01 23:59:59
var dateRange= {"$gte":1519862400,"$lte":1519948799}
var queryDoc; queryDoc.signed_up_at = dateRange
db.getCollection(`${collName}`)
.aggregate([
{ $match: queryDoc }
,{ $group:
@tradingbills
tradingbills / 3.js
Last active April 19, 2018 20:35
var collName= 20180419
// 2018-04-18 00:00:00 to
// 2018-04-18 23:59:59
var dateRange= {"$gte":1524009600,"$lte":1524095999}
// -----------------------------------------------------
var queryDoc03={}, segments= { "id": "5a709f20e8a46fcd9c0c5d37","name": "_HAS ACTIVITY"}
queryDoc03.signed_up_at= dateRange
queryDoc03.last_request_at= dateRange
queryDoc03["segments.segments.id"]= {$ne:segments.id}
db.getCollection(`${collName}`).aggregate([ { $match: queryDoc03 }, { "$group": {"_id": null, /* 'Plan Names': { $addToSet: { api_plan_name : "$custom_attributes.api_plan_name"}}, */ "Total Non-Activity": {"$sum": 1} } } ])
@tradingbills
tradingbills / 4 5 6.js
Last active April 19, 2018 20:38
var collName= 20180419
// 2018-04-18 00:00:00 to
// 2018-04-18 23:59:59
var dateRange= {"$gte":1524009600,"$lte":1524095999}
// -----------------------------------------------------
var queryDoc040506={}; queryDoc040506.signed_up_at = dateRange
db.getCollection(`${collName}`)
.aggregate([ { $match: { signed_up_at: dateRange } } ,{ $group: { _id : "$custom_attributes.api_experience_level",/*'Plan Names': { $addToSet: { api_plan_name : "$custom_attributes.api_plan_name"}}, */ "Sum" : {"$sum":1} } } ,{ $sort:{_id : 1} } ])
@tradingbills
tradingbills / 8.js
Last active April 19, 2018 20:38
var collName= 20180419
// 2018-04-18 00:00:00 to
// 2018-04-18 23:59:59
var dateRange= {"$gte":1524009600,"$lte":1524095999}
// -----------------------------------------------------
var queryDoc08 = {}, segments = {"id": "5a709f20e8a46fcd9c0c5d37", "name": "_HAS ACTIVITY" }
queryDoc08.last_request_at = dateRange
queryDoc08["segments.segments.id"] = segments.id
db.getCollection(`${collName}`).aggregate([{ $match: queryDoc08 },{ "$group": {_id: null,/* 'Plan Names': { $addToSet: { api_plan_name : "$custom_attributes.api_plan_name"}}, */ "Total Activity": {"$sum": 1} } } ])
@tradingbills
tradingbills / 9.js
Last active April 19, 2018 20:41
var collName= 20180419
// 2018-04-18 00:00:00 to
// 2018-04-18 23:59:59
var dateRange= {"$gte":1524009600,"$lte":1524095999}
// -----------------------------------------------------
var queryDoc09 = {}, segments= {"id": "5a709f20e8a46fcd9c0c5d37", "name": "_HAS ACTIVITY"}
queryDoc09.last_request_at = dateRange
queryDoc09["segments.segments.id"] = {$ne:segments.id}
db.getCollection(`${collName}`).aggregate([ { $match: queryDoc09 }, { "$group": { _id: null,/* 'Plan Names': { $addToSet: { api_plan_name : "$custom_attributes.api_plan_name"}}, */ "Total Non-Activity": {"$sum": 1} } } ])