{"id":35070,"date":"2025-12-21T16:36:43","date_gmt":"2025-12-21T09:36:43","guid":{"rendered":"https:\/\/dps.media\/toi-uu-hoa-du-lieu-marketing-cai-dat-metabase-self-hosted-tren-vps-theo-yeu-cau\/"},"modified":"2025-12-21T16:37:00","modified_gmt":"2025-12-21T09:37:00","slug":"toi-uu-hoa-du-lieu-marketing-cai-dat-metabase-self-hosted-tren-vps-theo-yeu-cau","status":"publish","type":"post","link":"https:\/\/dps.media\/en\/toi-uu-hoa-du-lieu-marketing-cai-dat-metabase-self-hosted-tren-vps-theo-yeu-cau\/","title":{"rendered":"Marketing Data Optimization: Custom Setup of Metabase Self-Hosted on VPS"},"content":{"rendered":"<h2>Benefits of Self-Hosted Metabase for marketing businesses<\/h2>\n<p>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.<\/p>\n<p>Theo b\u00e1o c\u00e1o c\u1ee7a VietnamWorks 2023, 68% SMEs Vi\u1ec7t Nam g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c truy c\u1eadp d\u1eef li\u1ec7u realtime. Metabase gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y hi\u1ec7u qu\u1ea3. Agency nh\u01b0 DPS.MEDIA s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ed1i \u01b0u ROI nhanh ch\u00f3ng.<\/p>\n<p>Hosting on your own VPS ensures high security. Sensitive marketing data is absolutely protected. Operating costs are 40-60% lower than SaaS.<\/p>\n<h3>Accelerate marketing decision-making speed<\/h3>\n<p>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.<\/p>\n<p>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.<\/p>\n<p>Important insight: Integrating Metabase with Google Analytics 4 helps discover hidden insights that the GA4 dashboard does not display.<\/p>\n<ul>\n<li>Identify key marketing KPIs that need to be tracked daily<\/li>\n<li>Set up database connections with ads platforms<\/li>\n<li>T\u1ea1o dashboard realtime cho team sales &amp; marketing<\/li>\n<li>If using Facebook Ads Manager, sync data every 15 minutes<\/li>\n<li>Test query performance before sharing the dashboard<\/li>\n<li>Schedule automated weekly email reports<\/li>\n<\/ul>\n<h3>Long-term Cost Savings for SMEs<\/h3>\n<p>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.<\/p>\n<p>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.<\/p>\n<p>Actual case: An agency in HCM City saved 180 million\/year after switching to self-hosted. ROI from data visualization doubled.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/dps.media\/wp-content\/uploads\/2025\/12\/photo-1551288049-bebda4e38f71-7.jpg\" alt=\"\" title=\"\"><\/p>\n<h2>Professional Metabase installation process on VPS<\/h2>\n<p>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.<\/p>\n<p>We use Ubuntu 22.04 LTS with Docker containers. Metabase runs stably, easy to scale horizontally when needed. PostgreSQL as the backend database.<\/p>\n<p>Complete setup time is only 4-6 hours. Your IT team can manage it easily after 2 hours of training.<\/p>\n<h3>Choose optimal VPS configuration for marketing data<\/h3>\n<p>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.<\/p>\n<p>For agencies running 5+ campaigns simultaneously, 8GB RAM is recommended. Database size under 50GB still runs smoothly. Supplement with Prometheus + Grafana monitoring.<\/p>\n<p>Pro tip: Use a reserved static IP to whitelist in Facebook Business Manager.<\/p>\n<table class=\"wp-block-table\">\n<thead>\n<tr>\n<th>Configuration<\/th>\n<th>Small traffic<\/th>\n<th>Medium traffic<\/th>\n<th>Large agency<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>RAM<\/td>\n<td>4GB<\/td>\n<td>8GB<\/td>\n<td>16GB<\/td>\n<\/tr>\n<tr>\n<td>CPU<\/td>\n<td>2 cores<\/td>\n<td>4 cores<\/td>\n<td>8 cores<\/td>\n<\/tr>\n<tr>\n<td>Storage<\/td>\n<td>100GB SSD<\/td>\n<td>200GB SSD<\/td>\n<td>500GB NVMe<\/td>\n<\/tr>\n<tr>\n<td>(Collective Intelligence). When a group of Agents works together to solve a problem, the result is often better than that of a single Agent. Molt provides an environment for:<\/td>\n<td>200k VND<\/td>\n<td>500k VND<\/td>\n<td>1.2m VND<\/td>\n<\/tr>\n<tr>\n<td>Recommendations<\/td>\n<td>SMBs<\/td>\n<td>Growing businesses<\/td>\n<td>Agency<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ol>\n<li>Choose a VPS provider with 99.9% uptime SLA<\/li>\n<li>Install clean Ubuntu 22.04 LTS<\/li>\n<li>Set up firewall only opening ports 3000, 5432<\/li>\n<li>If using a domain, configure Nginx reverse proxy<\/li>\n<li>Enable SSL Let&#039;s Encrypt mi\u1ec5n ph\u00ed<\/li>\n<li>Daily backup to S3 bucket<\/li>\n<\/ol>\n<h3>C\u00e0i \u0111\u1eb7t Docker &amp; Metabase container<\/h3>\n<p>Docker helps isolate Metabase from the system. Pull the latest official image. Volume mapping keeps data persistent through container restarts.<\/p>\n<p>postgres:13-alpine as a database companion. Environment variables config database name, user, password. Health check ensures the service is always ready.<\/p>\n<p>The automated script used by DPS.MEDIA has been tested with 50+ projects. Zero error deployment.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/dps.media\/wp-content\/uploads\/2025\/12\/photo-1706535849689-59e888460d10-1.jpg\" alt=\"\" title=\"\"><\/p>\n<h2>Integrate Metabase with the marketing ecosystem<\/h2>\n<p>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.<\/p>\n<p>Custom SQL queries for complex marketing metrics. LTV calculation, multi-touch attribution model. No need for expensive data engineers.<\/p>\n<p>Alert system notifies when CAC exceeds the threshold. The team reacts immediately to protect the budget.<\/p>\n<h3>K\u1ebft n\u1ed1i Facebook &amp; Google Ads data<\/h3>\n<p>Facebook Ads Manager exports CSV daily automatically via API. Google Ads uses native OAuth2 connector. Data syncs real-time every 15 minutes.<\/p>\n<p>Create calculated fields for ROAS and CTR benchmarks by industry. Dashboards compare performance at the campaign and adset level. Spot underperforming ads immediately.<\/p>\n<p>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.<\/p>\n<ul>\n<li>Setup Google Cloud service account for BigQuery<\/li>\n<li>Config Facebook API token with ads_read permission<\/li>\n<li>Create custom metrics: ROAS = Revenue \/ Ad Spend<\/li>\n<li>If tracking offline conversion, sync CRM data<\/li>\n<li>Build cohort analysis for customer retention<\/li>\n<li>Export professional monthly PDF reports<\/li>\n<\/ul>\n<h3>Build in-depth marketing dashboards<\/h3>\n<p>Main dashboard includes 6 tiles: Overview KPIs, Funnel Analysis, Channel Performance, Geo Analysis, A\/B Test Results, Forecast Revenue. Each tile is drillable.<\/p>\n<p>Use native chart types: Sankey for funnel, Heatmap for geo performance. Flexible filters by date range and campaign type.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/dps.media\/wp-content\/uploads\/2025\/12\/photo-1674027392887-751d6396b710.jpg\" alt=\"\" title=\"\"><\/p>\n<h2>B\u1ea3o m\u1eadt &amp; Scale Metabase cho doanh nghi\u1ec7p<\/h2>\n<p>3-layer security: Network firewall, App level auth, Data encryption. SSO integration with Google Workspace, Azure AD. Detailed role-based access control.<\/p>\n<p>Scale horizontally using Docker Swarm or Kubernetes. Load balancer distributes traffic. Redis caching increases query speed by 300%.<\/p>\n<p>Backup strategy 3-2-1 rule: 3 copies, 2 media types, 1 offsite. Recovery time objective under 4 hours.<\/p>\n<h3>Setup authentication &amp; user management<\/h3>\n<p>Disable public signup, only admin creates users. Group permissions by team: Marketing view-only, Analyst edit query, Admin full access.<\/p>\n<p>LDAP\/SSO for enterprise. Mandatory 2FA for admin users. Session timeout at 30 minutes of inactivity.<\/p>\n<p>Audit log tracks every query and dashboard access. Detect unauthorized access immediately.<\/p>\n<ol>\n<li>Enable SSO with Google Workspace<\/li>\n<li>Set up user groups by department<\/li>\n<li>Config 2FA for all admin users<\/li>\n<li>If there are compliance requirements, enable audit log<\/li>\n<li>Review permissions quarterly<\/li>\n<li>Test disaster recovery monthly<\/li>\n<\/ol>\n<h3>Monitoring &amp; performance optimization<\/h3>\n<p>Prometheus + Grafana monitor CPU, RAM, query latency. Alert Slack\/Email khi resource &gt;80%. Auto scaling script khi c\u1ea7n.<\/p>\n<p>Database indexing for frequently queried tables. 24h query cache for static reports. CDN for dashboard static assets.<\/p>\n<p>Insight: 80% of performance issues come from unindexed foreign keys in ads data tables.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/dps.media\/wp-content\/uploads\/2025\/12\/photo-1706248504630-d165ae5f7134.jpg\" alt=\"\" title=\"\"><\/p>\n<h2>Why choose DPS.MEDIA services for Metabase<\/h2>\n<p>7 years of experience in digital marketing data infrastructure. Set up for 50+ agencies and SMEs. Available dashboard templates for 12 popular industries.<\/p>\n<p>24\/7 support in Vietnamese. 99.9% uptime SLA guarantee. Clear fixed price packages, no hidden fees.<\/p>\n<p>Free migration from Looker Studio and Google Data Studio. Onsite or online training options. Guaranteed ROI within the first 3 months.<\/p>\n<h3>Service packages suitable for every business size<\/h3>\n<p>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.<\/p>\n<p>All packages have a monthly maintenance fee of 2m. 30-day money-back if not satisfied.<\/p>\n<table class=\"wp-block-table\">\n<thead>\n<tr>\n<th>Service packages<\/th>\n<th>Basic<\/th>\n<th>Pro<\/th>\n<th>Enterprise<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Set up VPS + Metabase<\/td>\n<td>\u2713<\/td>\n<td>\u2713<\/td>\n<td>\u2713<\/td>\n<\/tr>\n<tr>\n<td>Integrations (FB, GG Ads)<\/td>\n<td>3<\/td>\n<td>8+<\/td>\n<td>All<\/td>\n<\/tr>\n<tr>\n<td>Custom dashboards<\/td>\n<td>3<\/td>\n<td>10<\/td>\n<td>Unlimited<\/td>\n<\/tr>\n<tr>\n<td>Training<\/td>\n<td>Video<\/td>\n<td>Onsite<\/td>\n<td>Dedicated<\/td>\n<\/tr>\n<tr>\n<td>Support<\/td>\n<td>Email<\/td>\n<td>24\/7<\/td>\n<td>Account Manager<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Successful real-world case studies<\/h3>\n<p>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.<\/p>\n<p>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%.<\/p>\n<p>They expanded to 12 new clients thanks to real-time proof-of-concept dashboards sent to partners.<\/p>","protected":false},"excerpt":{"rendered":"<p>Explore Metabase self-hosted installation service on VPS dedicated for marketing businesses. Data autonomy, realtime ad campaign analysis, cost savings and increased digital business efficiency. DPS.MEDIA supports full package!<\/p>","protected":false},"author":0,"featured_media":35072,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1720,1742,1755,1635,1756],"tags":[],"class_list":["post-35070","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-case-study","category-cong-nghe-marketing","category-data-analytics","category-digital-marketing","category-toi-uu-hoa-chi-phi"],"acf":[],"rankmath_keywords":{"primary":"Metabase self-hosted, c\u00e0i \u0111\u1eb7t Metabase VPS, ph\u00e2n t\u00edch d\u1eef li\u1ec7u marketing, dashboard marketing realtime, t\u1ed1i \u01b0u h\u00f3a ROI qu\u1ea3ng c\u00e1o","secondary":["c\u00e0i \u0111\u1eb7t Metabase VPS","ph\u00e2n t\u00edch d\u1eef li\u1ec7u marketing","dashboard marketing realtime","t\u1ed1i \u01b0u h\u00f3a ROI qu\u1ea3ng c\u00e1o"]},"yoast_keywords":{"primary":"","secondary":[]},"yoast_focuskw":"","rankmath_focuskw":"Metabase self-hosted, c\u00e0i \u0111\u1eb7t Metabase VPS, ph\u00e2n t\u00edch d\u1eef li\u1ec7u marketing, dashboard marketing realtime, t\u1ed1i \u01b0u h\u00f3a ROI qu\u1ea3ng c\u00e1o","seo_keywords":{"primary":"Metabase self-hosted, c\u00e0i \u0111\u1eb7t Metabase VPS, ph\u00e2n t\u00edch d\u1eef li\u1ec7u marketing, dashboard marketing realtime, t\u1ed1i \u01b0u h\u00f3a ROI qu\u1ea3ng c\u00e1o","secondary":["c\u00e0i \u0111\u1eb7t Metabase VPS","ph\u00e2n t\u00edch d\u1eef li\u1ec7u marketing","dashboard marketing realtime","t\u1ed1i \u01b0u h\u00f3a ROI qu\u1ea3ng c\u00e1o"]},"_links":{"self":[{"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/posts\/35070","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/comments?post=35070"}],"version-history":[{"count":0,"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/posts\/35070\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/media\/35072"}],"wp:attachment":[{"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/media?parent=35070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/categories?post=35070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/tags?post=35070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}