Aston Motes astonm

## growth_accounting_and_ltv.sql
with
    dau as (
        -- This part of the query can be pretty much anything.
        -- The only requirement is that it have three columns:
        --   dt, user_id, inc_amt
        -- Where dt is a date and user_id is some unique identifier for a user.
        -- Each dt-user_id pair should be unique in this table.
        -- inc_amt represents the amount of value that this user created on dt.
        -- The most common case is
        --   inc_amt = incremental revenue from the user on dt

## switchbot_bluepy.py
# Activate switchbot by python with bluepy on Raspberry Pi
# https://github.com/IanHarvey/bluepy
#
# Switchbot's API is taken from this
# https://github.com/OpenWonderLabs/python-host

import binascii
from bluepy.btle import Peripheral

# find your switchbot address by
	with
	dau as (
	-- This part of the query can be pretty much anything.
	-- The only requirement is that it have three columns:
	-- dt, user_id, inc_amt
	-- Where dt is a date and user_id is some unique identifier for a user.
	-- Each dt-user_id pair should be unique in this table.
	-- inc_amt represents the amount of value that this user created on dt.
	-- The most common case is
	-- inc_amt = incremental revenue from the user on dt
	# Activate switchbot by python with bluepy on Raspberry Pi
	# https://github.com/IanHarvey/bluepy
	#
	# Switchbot's API is taken from this
	# https://github.com/OpenWonderLabs/python-host

	import binascii
	from bluepy.btle import Peripheral

	# find your switchbot address by