Question

Google Sheets? Airtable? MySQL?

Guys...

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?

Regards,

Mentioned
#Google Sheets #Airtable #Database #Data #Marketing #Analytics #Spreadsheets #ActiveCampaign #Tray.io #Integromat #Metabase
Share
ambar_tayde's avatar
5 months ago

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).

Check it out > https://medium.com/dronahq-low-code-platform/how-to-build-an-admin-panel-and-dashboard-using-airtable-821c37c377d5

4 points
shannonratliff's avatar
5 months ago

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!

4 points
sandbui's avatar
5 months ago

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.

3 points
navpar's avatar
5 months ago

Hosted MySQL + Metabase (either self hosted , maybe via Cloudron.io, or SaaS). I believe it is easier than most people think

1 point
landonray's avatar
5 months ago

Airtable's amazing of course, but also has very low limits for data.. much lower than Sheets. 50k or 100k per base I think?

1 point
maguay's avatar
@maguay (replying to @landonray )
4 months ago

Airtable's database sizes are partly limited by plans—free plans get 1,200 records per base, Plus plans get 5k records, and Pro plans get 50k records per base—and are capped at a max of 100k records per base.

Google Sheets today can handle a max of 5 million cells per spreadsheet, with up to 18,278 columns.

Excel can handle up to just over 3x that, with modern Excel files capped at 1,048,576 rows by 16,384 columns.

Beyond that—and honestly, long before that—you'll be better served by a dedicated database.

1 point
What's the best to-do list app in 2021?

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...

The community for power users.