Skip to content
Alex's Happy Doc
Alex's Happy Doc
Files
Building bot flows in botbuilder, Creating analytics dashboards, Reviewing responses for non-sensical results, Building retool views, Fixing database bugs, Creating social content, Creating blogs/articles, creating case studies, Updating website, managing invoices and finances
More
Share
Explore
Alex's Happy Doc

icon picker
Elmar Notes

Process Flow (start-to-end)

Coda: capture client details (manual)
Coda: capture audience specification (manual)
Coda: capture pricing agreement (manual)
Coda: capture form specification (manual)
Landbot: Use the (client-approved) form specification outlined in Coda and build it into a WhatsApp-bot survey (manual)
Landbot/Google Sheets: Map answer variables into columns in Google Sheet
Landbot: Use the (client-approved) audience specification outlined in Coda to identify the target audience that is suitable (and not blacklisted) to complete the WhatsApp survey (manual)
Landbot: Send (pre-approved) WhatsApp survey invitation message to target audience. (manual selection of audience)
Landbot: When respondent accepts the survey invitation redirect respondent to the WhatsApp (bot) survey (automatic)
Landbot: Collect answers from respondent (automatic)
Google Sheets: Analyze answers for data quality and flag fraud-detection (manual)
Google Sheets: Blacklist respondents exhibiting fraudulent behavior (manual)
Landbot: Import blacklisted respondents from Google Sheet into Landbot (manual?)
(Add bad actor score to blacklisted respondents from Google sheets using Get )
Google Sheets: Download CSV of passed respondents, along with referral (cell no., cell network, amount)
⁠
@Tim Treagus
⁠
What do you use this csv for?
(tool?): Block payout for blacklisted respondents
Simcloud: Initiate payout to respondents that completed they survey by uploading CSV
(Google Data Studio): Aggregate- and de-identify answers and present in online report (manual?)
Code?: Publish survey outcome report
Google Sheets/Email: Export cleaned data for client into CSV and send to client in email
Google Data Studio: Share Data Studio dashboard with client

Respondent Acquisition (Process Flow)

An implementation of the process flow outlined above, with the goal to grow a sustainable and diverse group of active respondents that can be used to create target audiences.
Social media campaign managers (FB & Twitter): Run awareness campaigns on various platforms to get people to signup as a respondent (manual?)
Referral incentive: Respondents are incentivized to send the WhatsApp number to their network, earning ~R2 each time the referrer does a survey.
(retool): Request their cellphone number and sent them the (pre-approved) WhatsApp survey invitation to complete the onboarding survey (automatic?)

vNext Priorities

Top 3 items in the process-flow that take the most time:
WhatsApp-bot survey creation (5 hrs)
Data quality analysis, monitoring and processing
Creating data visualization dashboard in data studio
Top 3 items in the process-flow that run a high risk of errors:
Data quality analysis (4 hrs)
Multiple versions of data - risk of mismatching and misaligning data for payments, client sharing CSV and blacklisting
Setting up survey in Landbot;
Incorrect variables (omitting variables)
Incorrect mapping of variables
Incorrect conditional logic (wrong audience does survey)
Top 3 missing features that will allow us to increase product revenue:
Processing of received data: Accuracy checks, cleaning, payments - 4 hours
Optimizing above would give more time for lead generation

⁠
@Elmar De Groot
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.