ryw89

Getting data for frontend

NOTE: This section is out-of-date.

Getting campaigns, questions, responses, and custom fields. from Spoke.

First import the module:

import rlabsreporting

ryw89

Ingestion workflow (newer, from 03-17-21)

1. File gets uploaded

2. Add data to vendor list metadata table

3. Clean all of the columns (list may not be complete)

   a. DOB

ryw89

Sign up for Github

Will send invites for Redash

Projects

10DLC

SQL queries

Visualization

Google Data Studio

Daily report from Telnyx

CSV export from Telnyx, then place in AWS S3

Ad-hoc SQL queries

ryw89

Data

Old data examples

https://docs.google.com/spreadsheets/d/1r_RiWJZp0wcbpziNyioP3JHEe3VfEuL6/edit#gid=1266710575 https://docs.google.com/spreadsheets/d/150eAXOIvYjM1FLk8hmPDZSqKWnO2OWaX/edit#gid=468795636

Convos to be audited

• Spoke message ID