In "digital marketing world" it's very common to use Google Sheets to store data. Ex:
→ Metrics from Facebook Ads → Google Sheets → Google Data Studio
→ Metrics from Google Ads → Google Sheets
→ Metrics from ActiveCampaign → Google Sheets → Google Data Studio
Google Sheets is not a database. The performance slows down after many rows.
In your opinion: Which is the best option to store data and integrate with other services by using Zapier, Integromat, etc.... ? I like Airtable... Suggestions?
Hey, I have used Airtable as a database for an Admin Panel and Dashboard. And it worked out pretty well, because it is easy to integrate. I have integrated it with my app in made on DronaHQ (low-code platform).
I love Airtable, the single-select field is game-changing for grouping items together by category to see more specific stat breakdowns. Charts and pivot tables are exceptionally easy to put together once you get the basic organization you want to create down. I've organized an article archive database of 50,000+ on Airtable, and have built channel/platform stat burndowns and analytical databases before. I love how no-code/low-code Airtable is, it's inspired me to get a little better without feeling forced into it. I'm an Airtable fangirl.
There is a small learning curve that can feel scary when onboarding teams, but it's more about feeling confident in knowing you can't really break anything if you make a copy, ha!
How much data do you need to store? Google Sheets is basically an online spreadsheet that can only take you so far. If you want to take it a step further, then Airtable is a good option as it's a spreadsheet-database hybrid.
However, if you want to query your data and find insights. Then you'll need to upgrade to a data warehouse like Redshift, Snowflake, Google BigQuery, etc. You'll have to use a BI tool like PowerBI, Tableau, Thoughtspot, Sisense, etc to then query the data to create visualizations and give you insights into how your marketing campaigns are performing.
A number of integration tools like Zapier, Integromat and Tray.io can help integrating and connecting the different tools that you use in your stack.
Hosted MySQL + Metabase (either self hosted , maybe via Cloudron.io, or SaaS). I believe it is easier than most people think
Hey guys, first post here. As part of my work, I have to deal with and respond to a lot of incoming messages from different chats: Linkedin/WhatsApp/Signal/IG. I try to use Unreads/Archive features...
There are plenty of advanced, powerful software filled with enough features to do almost anything. And then there are the tiny utilities that don't do much, but that are great at what they do do. ...
I came across Readwise this week and I thought it was a very nice app. It sends emails with highlights from Kindle books, Instapaper, Pocket, iBooks and other services. It also offers the spaced re...