Hey folks,
Here are some of the ideas I am toying with, most are from my own experiences at work and observing my coworkers. However I'm not sure of the demand there is for them and would really appreciate if you guys could take a look and roast :D
Dashboard for bigquery, specifically firebase analytics. At work I am in charge of rolling out our tracking and analytics for our apps: defining events + params, writing queries for relevant AARRR metrics (build custom script on google sheets) and creating dashboards on powerBI. The default dashboard in firebase is absolutely trash, along with GA for firebase - thus we had to go with our own solution. I absolutely love Bigquery and it's a shame that the default UIS on top are shit.
Ads content search engine (= search tiktok, find trending). While running an ecommerce store, finding ads content is hard and time consuming. I created a docs with links to tiktok videos to later compile and make ad content
Vlookup across google spreadsheets. Currently one google sheets are limited to certain million of rows (sum of all tabs as well). To create complicated dashboard, sometimes we need to use multiple sheet files. However, this requires importrange which doesn't help in case of big tables, plus loading time is shit.
Ads data analytics on google sheets. Connect fb, google, & other ad networks data source to google sheet. Also connect to internal db (via API or google sheet hooks) to create custom dashboards.
Automated product landing page. I have an ecommerce store of about 1000 SKUs and finding a perfect landing page with the right product suggestions is tough. Currently I'm working on a dynamic landing page that over time take CTR and CPC data from facebook ads to determine what works / not.
I'd be really interested in discussing the landing page idea further. Feel free to drop me an email at campbjames1@gmail.com
yo - thanks for the reply :D I haven't worked properly on any of them yet. I sort of worked on the landing page to use in my ecommerce site though it's not fully functional - still trying to use shop/inventory api from facebook but I can smell there is some pretty great things to do here.
Feel free to shoot email at lhc1702@gmail.com to discuss more. thanks
I think there are some pretty solid ideas here! Have you thought about MVPing any of them, setting up a landing page and seeing if you get any traction?
They all sound like stuff that would be of use to yourself. All of them sounds like opportunities worth pursuing. It all comes down to the validation process of interviewing people who have the problem to see how big of a problem it really is for folks.
Also, good stuff on your ecommerce business.