Laporan Marketing Sheet

Not one file — a set of Google Sheets combined into an “ALL” reporting view. The daily/weekly reporting station and the operational home of the PIC map. #type/tool #scope/general

• Type: Google Sheet (a set — see below)
• Used by (position): Digital Advertiser, Superoperator, Marketing Lead
• Holds / does: daily & weekly performance per brand × channel; source of the PIC map (which accounts a position is assigned). Tabs seen on the master: PIC · ReportGM (per-marketplace ROAS/omset) · Target.
• The set (Anton 2026-07-11 — do NOT change any of these):
  • Laporan Marketing Arkanza 2026 (1GlSpEo…, ~3.6 MB) = the combined “ALL” master (Anton’s “Antonio - Laporan Marketing ALL”); spans main + subbrand markets; holds the PIC map.
  • Laporan Marketing Arkanza ++ 2025 (13ac60…) = the Arkanza++ (subbrands) source.
  • So: Arkanza (main) + Arkanza++ (subbrands) → combined “ALL”. (Scope-unclear, present in Drive: Laporan Marketing Indo Group, LAPORAN FB ADS GUDANG dan STORE — not wired here.)
• App vs KB: live values + the PIC map live in the sheet (operational); the KB references it abstractly as “PIC scope: akun yang ditugaskan.” Never bake the marketplace→person map into the KB — see Plan. DA sub-stations (Analisa / Monitoring Harga) are likely tabs in the master, not separate files; Drive read_file_content returns only the first tab, so use per-tab reads if a tab-level read is ever needed.
• Access / source: Google Drive (shared). Referenced KPIs defined once in KPI_Definitions.
• SOPs that use it: DA — SOP_Pelaporan_Harian · SOP_Pelaporan_Mingguan; Superoperator — SOP_Pelaporan_Mingguan_Superoperator (PIC Report + Weekly Report). (extended as SOPs are written)

Related

_Tools_MOC · KPI_Definitions · Org_Structure_and_RACI