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
a year 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
a year 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
a year 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
a year 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
a year 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 )
a year 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
How do you manage your chat inbox?

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

What are your favorite small, single-purpose apps?

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

Do you use Readwise app? How much are you paying for the service?

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

The community for power users.