Time back from admin work means better service for our fishing communities.
Empowering fishing communities in Baja and beyond
We partnered with The Nature Conservancy to simplify tracking FishKit's impact on fishing communities through optimized Bizops and smart Airtable tools.





Apps used
































Overview
We teamed up with the Nature Conservancy to take the FishKit project to the next level! Our mission? To make tracking the impact of the FishKit toolkit as easy as pie. By harnessing the magic of Airtable and integrating it with Looker Studio, we created a system that automates the collection and organization of key metrics, including fishery communities, training conservationists, tracked species, sustainability improvements, and more. This initiative was a game-changer for the Nature Conservancy’s Monitoring, Evaluation, and Learning (MEL) plan, paving the way for smarter decisions as they expand the toolkit’s reach.
What did we build together? A simple yet mighty Airtable database that pulls data directly from the FishKit SQL databases and allows the team to add important details that help make sense of ongoing operations. Plus, we designed dynamic infographics that transform complex data into eye-catching visuals—perfect for sharing progress with everyone involved, especially donors. With this new setup, the team can monitor their impact in one place without any hiccups, all while saving their most precious resources: time and money. Adios to countless spreadsheets!
Thanks to our friendly solution, the Nature Conservancy is now equipped to track FishKit’s success and make informed decisions that benefit the communities they serve. This project shows just how powerful a little creativity and the right tools can be in driving conservation efforts forward—making a real difference, one community at a time!
Metrics improved
At the intersection of innovation and conservation, we’re thrilled to share how smarter tracking can lead to big wins for our communities and ecosystems! Here’s a look at the impressive results we achieved.
Streamlined Species Reporting: After the process integration, we boosted species reporting from 150 to a whopping 270—no more duplication, and easier tracking.
2X Donor Engagement: Say hello to double the donor engagement! We’ve made it easier to showcase Fishkit's impact and it's showing with increased support and response from donors to the latest conservation efforts.
Increase in User Acquisition: The species database has led to a significant increase in new users, driven by their interest in region-specific specimens. This metric saw an impact of almost ~35% in for the applicable areas.
Immediate Time Savings: Who doesn’t love saving time? Post-onboarding, we cut data entry and management time by 50%. That’s half the hassle and twice the efficiency!
Meet the process
Feel free to drag the cards or use arrow keys to scroll [<-] [->]
Deliverables
Looker Studio Impact Dashboard
Designed to communicate key metrics and concepts visually to a broader audience.

Airtable Base as day-to-day Tool
One base that serves as a project tracker on all fronts: engagements, community, partnerships, and more.

Data Architecture
Thought for scale, we workshopped a new data structure to house TNC’s FishKit operations.

Make.com Data Sync Scenario
Created to mirror the robust SQL database behind the FishKit app with the day-to-day Airtable PM base.

Replit script to mirror Digital Ocean’s database
A scheduled Repl bridges the gap between cloud repository and the team running the D2D in Airtable.

Video Documentation
A full video library stores all knowledge on how to maintain and operate TNC’s new tools.

Try a Discovery.
It's fully refundable.
During a Discovery, I spend one week working with you to understand your pain points and build a prototype of your project. If we don't end up collaborating, that's ok! I'll still go out of my way to make sure you're better off than when we started.
no strings attached!
