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
When you've got too many things to do, how do you keep track of them all? Have you started using a new to-do list app recently, or found an old one is still doing the job well? The last time we di...
With the recent shutdowns of Woven calendar and x.ai, scheduling productivity has taken a hit. Which tools do you swear by? Will calendar and scheduling point solutions continue to get swallowed w...