Benefits of Self-Hosted Metabase for marketing businesses

Self-hosted Metabase helps marketing businesses fully control their data. You are not dependent on expensive cloud services. Customer data and ads performance are always ready for analysis.

According to the 2023 VietnamWorks report, 68% of Vietnamese SMEs face difficulties in accessing real-time data. Metabase solves this problem effectively. Agencies like DPS.MEDIA use it to optimize ROI quickly.

Hosting on your own VPS ensures high security. Sensitive marketing data is absolutely protected. Operating costs are 40-60% lower than SaaS.

Accelerate marketing decision-making speed

The Metabase dashboard displays real-time metrics from Facebook Ads and Google Ads. The marketing team grasps trends immediately. No more waiting for delayed Excel reports.

You can create funnel analysis and cohort retention in just 5 minutes. Beautiful visualizations easily persuade stakeholders. Conversion rates increase by an average of 15-25% after implementation.

Important insight: Integrating Metabase with Google Analytics 4 helps discover hidden insights that the GA4 dashboard does not display.

• Identify key marketing KPIs that need to be tracked daily
• Set up database connections with ads platforms
• Create real-time dashboards for the sales & marketing team
• If using Facebook Ads Manager, sync data every 15 minutes
• Test query performance before sharing the dashboard
• Schedule automated weekly email reports

Long-term Cost Savings for SMEs

Cloud SaaS like Tableau and Power BI charge per user/month. Self-hosted Metabase only costs about 200,000 VND/month for VPS. Scale according to actual business needs.

With a traffic of 10,000 sessions/day, a 4GB RAM VPS is sufficient. Automatic backups, 99.9% uptime. No worries about unexpected overage fees.

Actual case: An agency in HCM City saved 180 million/year after switching to self-hosted. ROI from data visualization doubled.

Professional Metabase installation process on VPS

DPS.MEDIA deploys Metabase according to enterprise standards. From choosing the VPS, setting up the server to migrating old data. Ensuring zero downtime for the business.

We use Ubuntu 22.04 LTS with Docker containers. Metabase runs stably, easy to scale horizontally when needed. PostgreSQL as the backend database.

Complete setup time is only 4-6 hours. Your IT team can manage it easily after 2 hours of training.

Choose optimal VPS configuration for marketing data

VPS needs at least 4GB RAM, 2 CPU cores, 100GB SSD. DigitalOcean, Vultr, Viettel IDC are all suitable. Choose a Singapore data center for the lowest latency.

For agencies running 5+ campaigns simultaneously, 8GB RAM is recommended. Database size under 50GB still runs smoothly. Supplement with Prometheus + Grafana monitoring.

Pro tip: Use a reserved static IP to whitelist in Facebook Business Manager.

1. Choose a VPS provider with 99.9% uptime SLA
2. Install clean Ubuntu 22.04 LTS
3. Set up firewall only opening ports 3000, 5432
4. If using a domain, configure Nginx reverse proxy
5. Enable free Let's Encrypt SSL
6. Daily backup to S3 bucket

Install Docker & Metabase container

Docker helps isolate Metabase from the system. Pull the latest official image. Volume mapping keeps data persistent through container restarts.

postgres:13-alpine as a database companion. Environment variables config database name, user, password. Health check ensures the service is always ready.

The automated script used by DPS.MEDIA has been tested with 50+ projects. Zero error deployment.

Integrate Metabase with the marketing ecosystem

Metabase connects natively with Google BigQuery, Postgres, MySQL. Facebook Ads and Google Ads via Supermetrics or BigQuery export. All data in one place for analysis.

Custom SQL queries for complex marketing metrics. LTV calculation, multi-touch attribution model. No need for expensive data engineers.

Alert system notifies when CAC exceeds the threshold. The team reacts immediately to protect the budget.

Connect Facebook & Google Ads data

Facebook Ads Manager exports CSV daily automatically via API. Google Ads uses native OAuth2 connector. Data syncs real-time every 15 minutes.

Create calculated fields for ROAS and CTR benchmarks by industry. Dashboards compare performance at the campaign and adset level. Spot underperforming ads immediately.

Real-world example: Agency A discovered 30% of the budget was poured into ineffective adsets thanks to the Metabase dashboard. Optimized immediately, ROI increased 42% the following month.

• Setup Google Cloud service account for BigQuery
• Config Facebook API token with ads_read permission
• Create custom metrics: ROAS = Revenue / Ad Spend
• If tracking offline conversion, sync CRM data
• Build cohort analysis for customer retention
• Export professional monthly PDF reports

Build in-depth marketing dashboards

Main dashboard includes 6 tiles: Overview KPIs, Funnel Analysis, Channel Performance, Geo Analysis, A/B Test Results, Forecast Revenue. Each tile is drillable.

Use native chart types: Sankey for funnel, Heatmap for geo performance. Flexible filters by date range and campaign type.

Security & Scaling Metabase for enterprises

3-layer security: Network firewall, App level auth, Data encryption. SSO integration with Google Workspace, Azure AD. Detailed role-based access control.

Scale horizontally using Docker Swarm or Kubernetes. Load balancer distributes traffic. Redis caching increases query speed by 300%.

Backup strategy 3-2-1 rule: 3 copies, 2 media types, 1 offsite. Recovery time objective under 4 hours.

Setup authentication & user management

Disable public signup, only admin creates users. Group permissions by team: Marketing view-only, Analyst edit query, Admin full access.

LDAP/SSO for enterprise. Mandatory 2FA for admin users. Session timeout at 30 minutes of inactivity.

Audit log tracks every query and dashboard access. Detect unauthorized access immediately.

1. Enable SSO with Google Workspace
2. Setup user groups by department
3. Config 2FA for all admin users
4. If there are compliance requirements, enable audit log
5. Review permissions quarterly
6. Test disaster recovery monthly

Monitoring & performance optimization

Prometheus + Grafana monitor CPU, RAM, and query latency. Slack/Email alerts when resources > 80%. Auto-scaling script when needed.

Database indexing for frequently queried tables. 24h query cache for static reports. CDN for dashboard static assets.

Insight: 80% of performance issues come from unindexed foreign keys in ads data tables.

Why choose DPS.MEDIA services for Metabase

7 years of experience in digital marketing data infrastructure. Set up for 50+ agencies and SMEs. Available dashboard templates for 12 popular industries.

24/7 support in Vietnamese. 99.9% uptime SLA guarantee. Clear fixed price packages, no hidden fees.

Free migration from Looker Studio and Google Data Studio. Onsite or online training options. Guaranteed ROI within the first 3 months.

Service packages suitable for every business size

Basic package 15m: VPS Setup + Metabase + 3 basic dashboards. Pro package 35m: Full integrations + custom metrics + training. Enterprise package 75m+: SSO, scale infra, dedicated support.

All packages have a monthly maintenance fee of 2m. 30-day money-back if not satisfied.

Successful real-world case studies

Agency X in Hanoi serves 25 beauty brand SMEs. Previously used Google Sheets to track ads. Switched to Metabase after 1 month, the team saved 20 hours/week reconciling data.

Discovery: 25% of the Facebook ads budget was wasted on ineffective peak hours. Optimized timing, CAC decreased by 35%. Satisfied clients, retention rate increased by 40%.

They expanded to 12 new clients thanks to real-time proof-of-concept dashboards sent to partners.