MarketBoard - All in One Marketing Dashboard

Selamat datang! 👋

MarketOS —

Rp—

Meta Spend

Rp—

Google Spend

—

Total Results

—

Perlu Action

📌 Menu Utama

📊

Meta Ads

Semua Campaign

Rp—

📍

Meta Area

Per Lokasi

🌐

Meta Non-Area

Nasional

🔍

Google Ads

Semua Campaign

Rp—

📍

Google Area

Per Lokasi

🌐

Google Non-Area

Nasional

📈

SEO Dashboard

Organic Traffic

🎯

Input Leads

Manual Harian

—

⚡ Snapshot Hari Ini

🎯 Meta Ads — Top Campaign

Campaign	Area	Status	CPR	Results
Memuat data...

💡 AI Insight Hari Ini

Memuat insight...

📍 Meta — Area Performance

—

Total Spend

Rp 0

Total Results

0

Avg CPR

Rp 0

Avg CTR

0%

Total Budget

Rp 0

Total Reach

0

unique users

Avg Frequency

0x

impr per user

Avg CPC

Rp 0

avg CPM juga

🎯 Campaign Data

Tanggal	Campaign	Area	Spend	Budget	Reach	Freq	Impr	Clicks	CTR	CPC	CPM	Res	CPR	Status	Saran

💡 Meta Insight

📍 Per Area

Total Spend

Rp 0

Total Results

0

Avg CPR

Rp 0

Avg CTR

0%

📍 Area Campaign Data

Tanggal	Campaign	Area	Spend	Budget	Reach	Freq	Impr	Clicks	CTR	CPC	CPM	Res	CPR	Status	Saran

💡 Area Insight

📍 Performance per Area

Total Spend

Rp 0

Total Results

0

Avg CPR

Rp 0

Avg CTR

0%

🌐 Non-Area Campaign Data

Tanggal	Campaign	Spend	Budget	Reach	Freq	Impr	Clicks	CTR	CPC	CPM	Res	CPR	Status	Saran

💡 Non-Area Insight

📊 Per Campaign

📍 Meta Ads — Analisa per Area

Total Spend

Rp 0

Total Clicks

0

Total Conversions

0

Avg CPC

Rp 0

🔍 Google Ads Data

Tanggal	Campaign	Akun	Spend	Impr	Clicks	CTR	Conv	CPC	CPA	ROAS

💡 Google Insight

📊 Per Campaign

Total Spend

Rp 0

Total Conversions

0

Avg CPA

Rp 0

Avg ROAS

0x

📍 Area Campaign Data

Tanggal	Campaign	Area	Spend	Impr	Clicks	CTR	Conv	CPC	CPA	ROAS

Insight Area

Performance per Area

Total Spend

Rp 0

Total Conversions

0

Avg CPA

Rp 0

Avg ROAS

0x

Non-Area Campaign Data

Tanggal	Campaign	Spend	Impr	Clicks	CTR	Conv	CPC	CPA	ROAS

Insight Non-Area

Per Campaign

Belum ada domain. Klik + Domain →

Total Keywords

0

sedang ditrack

Top 10

0

posisi halaman 1

Avg Position

—

rata-rata ranking

Total Clicks

0

dari GSC data

Total Clicks

—

Total Impressions

—

Average CTR

—

Average Position

—

🔑 Keyword Tracker

🔍

Tambah project & keyword dulu, atau hubungkan GSC via n8n

💡 SEO Insight

Tambah keyword untuk melihat insight otomatis

📊 Distribusi Posisi

—

🌐 Info Project

Pilih project →

⚙️ Setup & Koneksi

n8n → SQLite API → MarketOS Dashboard · Polling sync tiap 8 detik

✅ SQLite Connected

SQLite API

Meta Ads

Google Ads

GSC / SEO

🗺️ Alur Data

📊

Sources

Meta · Google
GSC · Meta Business

→

🤖

n8n

Schedule
HTTP POST

→

🗄️

SQLite

api.php
Hosting server

→

📈

Dashboard

Auto update
tiap 8 detik

✅ Lebih cepat dari Firebase — data tersimpan langsung di server Indonesia. Latency lebih rendah, tidak ada external dependency.

🔌 API Endpoint Reference

BASE URL:

https://rm.kampunginggrisplus.com/analyze-tools/api.php

PATHS (tambahkan ?path=...):

🎯 marketos/ads/{YYYY-MM-DD}/{rowId}

🔍 marketos/goog/{YYYY-MM-DD}/{rowId}

📈 marketos/seo/keywords/{projId}/{kwId}

📱 marketos/social_posts/{postId}

📍

Workflow Area Report

rowType: "area" · ada kolom Area

1

HTTP Request — Method POST

URL API (tambahkan di node HTTP Request setelah Sheets node):

https://rm.kampunginggrisplus.com/analyze-tools/api.php?path=marketos/ads/{{ $now.toFormat('yyyy-MM-dd') }}/{{ $json.rowType || 'area' }}_{{ $now.toMillis() }}&action=update

2

Body JSON — Area

{ "rowType": "area", "tanggal": "{{ $json.Tanggal }}", "campaign": "{{ $json.Campaign }}", "area": "{{ $json.Area }}", "spend": {{ $json.Spend || 0 }}, "budget": {{ $json.Budget || 0 }}, "reach": {{ $json.Reach || 0 }}, "frequency": {{ $json.Frequency || 0 }}, "impressions": {{ $json.Impressions || 0 }}, "clicks": {{ $json.Clicks || 0 }}, "ctr": "{{ $json.CTR }}", "cpc": {{ $json.CPC || 0 }}, "cpm": {{ $json.CPM || 0 }}, "results": {{ $json.Results || 0 }}, "cpr": {{ $json.CPR || 0 }}, "status": "{{ $json.Status }}", "diagnosis": "{{ $json.Diagnosis }}", "saran": "{{ $json.Saran }}", "syncAt": {{ $now.toMillis() }} }

🌐

Workflow Non-Area Report

rowType: "non-area" · tanpa kolom Area

1

URL sama dengan Area Report

Gunakan URL yang sama di atas, perbedaan hanya di Body JSON.

2

Body JSON — Non-Area

{ "rowType": "non-area", "tanggal": "{{ $json.Tanggal }}", "campaign": "{{ $json.Campaign }}", "spend": {{ $json.Spend || 0 }}, "budget": {{ $json.Budget || 0 }}, "reach": {{ $json.Reach || 0 }}, "frequency": {{ $json.Frequency || 0 }}, "impressions": {{ $json.Impressions || 0 }}, "clicks": {{ $json.Clicks || 0 }}, "ctr": "{{ $json.CTR }}", "cpc": {{ $json.CPC || 0 }}, "cpm": {{ $json.CPM || 0 }}, "results": {{ $json.Results || 0 }}, "cpr": {{ $json.CPR || 0 }}, "status": "{{ $json.Status }}", "diagnosis": "{{ $json.Diagnosis }}", "saran": "{{ $json.Saran }}", "syncAt": {{ $now.toMillis() }} }

📥 Import Manual CSV/XLSX

🔍

n8n → Google Ads Daily Report

Schedule → Google Ads node → HTTP POST → SQLite API

1

Buat workflow di n8n

Schedule (daily 08:00) → Google Ads node → HTTP Request POST ke SQLite API

2

URL API Google Ads

https://rm.kampunginggrisplus.com/analyze-tools/api.php?path=marketos/goog/{{ $now.toFormat('yyyy-MM-dd') }}/{{ $now.toMillis() }}&action=update

3

Body JSON Google Ads

{ "tanggal": "{{ $json.Date }}", "campaign": "{{ $json['Campaign name'] }}", "spend": {{ $json.Cost || $json.Spend || 0 }}, "impressions": {{ $json.Impressions || 0 }}, "clicks": {{ $json.Clicks || 0 }}, "ctr": "{{ $json['CTR'] }}", "conversions": {{ $json.Conversions || 0 }}, "cpc": {{ $json['Avg. CPC'] || 0 }}, "cpa": {{ $json['Cost / conv.'] || 0 }}, "roas": {{ $json['Conv. value/cost'] || 0 }}, "syncAt": {{ $now.toMillis() }} }

🔐 Langkah 1 — Setup OAuth GSC di n8n

Grant Type

Authorization Code

Scope

https://www.googleapis.com/auth/webmasters.readonly

Auth URL

https://accounts.google.com/o/oauth2/auth

Token URL

https://oauth2.googleapis.com/token

🤖 Langkah 2 — Buat Workflow n8n

1

Node: Schedule Trigger

Interval: Every Day jam 07:00.

2

Node: HTTP Request ke GSC API

Method: POST · Auth: OAuth2 GSC

https://www.googleapis.com/webmasters/v3/sites/https%3A%2F%2Fspv.goldenenglish.id%2F/searchAnalytics/query

3

Body JSON request ke GSC

{ "startDate": "{{ $now.minus({days:3}).toFormat('yyyy-MM-dd') }}", "endDate": "{{ $now.minus({days:1}).toFormat('yyyy-MM-dd') }}", "dimensions": ["query","date"], "rowLimit": 500, "startRow": 0 }

4

Node: Code — Transform data

const rows = $input.first().json.rows || []; return rows.map(row => ({ json: { keyword: row.keys[0], date: row.keys[1], clicks: row.clicks, impressions: row.impressions, ctr: parseFloat((row.ctr * 100).toFixed(2)), position: Math.round(row.position * 10) / 10, updated: Date.now() } }));

5

Node: HTTP Request POST ke SQLite API

Method: POST · ganti PROJ_ID dengan ID project SEO

https://rm.kampunginggrisplus.com/analyze-tools/api.php?path=marketos/seo/keywords/PROJ_ID/{{ $json.keyword }}_{{ $json.date }}&action=update

6

Body JSON ke SQLite API

{ "keyword": "{{ $json.keyword }}", "date": "{{ $json.date }}", "position": {{ $json.position }}, "clicks": {{ $json.clicks }}, "impressions": {{ $json.impressions }}, "ctr": {{ $json.ctr }}, "updated": {{ $json.updated }} }

💡 PROJ_ID: Copy dari tombol "Copy Project ID" di SEO Dashboard saat project aktif.

🔄 Auto update: Data masuk SQLite → dashboard refresh otomatis tiap 8 detik tanpa reload.

💡Tips Setup n8n → SQLite API

🔌 Method: Gunakan POST (bukan PUT/PATCH) untuk semua request ke API

🔔 Error Handling: Tambah node Error Trigger di tiap workflow n8n

📋 Urutan node: Schedule → API/Sheets → HTTP Request → SQLite API

🧪 Testing: Execute manual dulu di n8n, cek response API, baru aktifkan schedule

⚡ Response sukses: {"ok":true} — kalau muncul ini data sudah masuk

🔄 Dashboard refresh: Data baru akan muncul di dashboard dalam 8 detik otomatis

📱 Social Media — Content Performance

Belum ada data. Import CSV dari Meta Business Suite.

Total Posts

—

periode ini

Total Views

—

video plays

Total Reach

—

unique accounts

Avg Engagement

—

likes+cmnt+save+share

Avg ER

—

engage/reach

📈 Trend Konten — Views & Reach

📋 Data Per Post

Caption	Tipe	Tanggal	Views	Reach	Likes	Cmnt	Share	Save	ER%	Link

🏆 Top 5 Posts

Belum ada data

📊 Breakdown Tipe Konten

—

💡 Content Insight

Import data dulu

👥 Followers Growth Tracker

Followers Sekarang

—

Growth 30 Hari

—

Growth Rate

—

Total Records

—

Tanggal	Followers	+/- vs Sebelumnya	Aksi

🎯 Input Leads Harian

Database leads per sumber per area — klik + untuk tambah entri baru

Filter

Hari Ini

Total Leads

0

semua area

Top Area

—

terbanyak

vs Kemarin

—

perubahan

Low Performance

—

perlu perhatian

📈 Trend Leads

🏆 Top 7 Hari

Belum ada data

▼ Low 7 Hari

Belum ada data

📋 Riwayat Input Leads

Tanggal	Total
Belum ada data

📝 Notes

📝

Pilih atau buat note baru

Klik note di kiri, atau tekan + Baru