tradingbills’s gists

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 / 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 / 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:

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 / 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 / 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 / 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 / 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 / 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} } } ])

tradingbills / 10.js

Last active April 19, 2018 20:44

	var collName= 20180419
	/* 2018-04-18 00:00:00 to 2018-04-18 23:59:59 */
	var dateRange= {"$gte":1524009600,"$lte":1524095999}
	// -----------------------------------------------------
	var queryDoc10= {}, paid= "59deb60085a3c22795133b02", free= "59dfe40a0a5037ff1c0bd8af", useSegId = free
	queryDoc10= {"last_request_at": dateRange, "segments.segments.id":useSegId}
	db.getCollection(`${collName}`).aggregate([ { $match: queryDoc10 },{ $group: {_id : null,/* 'Plan Names': { $push: { api_plan_name : "$custom_attributes.api_plan_name", "User email": "$email", "User id": "$user_id" } }, */ "Total no activity" : {"$sum":1} } }
	/* ,{ $project: {_id:0, "Plan Names": "$Plan Names", "Client id" : "$client_id"} } */
	] )

Jason Ashley tradingbills