E

Dashboard Settings

Admin Panel — Envisioned Products
← Back to Dashboard ADMIN
System Status Data Sources Team Access Deployments Refresh Data Activity Log
System Status

Dashboard Version

V1 — Classic V2 — Categories & Margins

Switch between dashboard versions. V2 adds product categories, cost data, and margin analysis. This preference is saved for all team members.

🟢
All Systems Go
Last checked: —

Dashboard

StatusLive
URLdashboard.wduluv.com
Last BuiltApril 07, 2026
Access ProtectionActive

Data Pipeline

ScheduleDaily 7:00 AM
Database3.6 MB
Total Records13,232
Ingested Files39

Sales Monthly

24
rows
2024-05 → 2026-04

Sales by ASIN

3,481
rows
2025-01 → 2026-03

Search Queries

680
rows
2024-11 → 2026-03

PPC Advertising

8,409
rows
AdvertisingSearchTermReport_Last30_2026-04-03
Data Sources
Files are auto-ingested from iCloud Drive → JL-Hub → 02_Work-Envisioned → Finance. Drop new CSVs/Excel files and the pipeline picks them up.

Ingested Files

FilenameSourceRowsIngested At
AdvertisingSearchTermReport_Last30_2026-04-03.xlsxppc8,4092026-04-03T18:01:44
SellerPerformance-2026.csvseller_performance3652026-04-03T18:01:43
SellerPerformance-2025.csvseller_performance3652026-04-03T18:01:43
SellerPerformance-2024.csvseller_performance2732026-04-03T18:01:43
SearchQueryPerformance-2026-03.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2026-02.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2026-01.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2025-12.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2025-11.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2025-10.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2025-09.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2025-08.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2025-07.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2025-06.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2025-05.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2025-04.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2025-03.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2025-02.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2025-01.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2024-12.csvsearch_query402026-04-03T18:01:43
SearchQueryPerformance-2024-11.csvsearch_query402026-04-03T18:01:43
SalesByAsin-2026-03.csvsales_by_asin2372026-04-03T18:01:43
SalesByAsin-2026-02.csvsales_by_asin2442026-04-03T18:01:43
SalesByAsin-2026-01.csvsales_by_asin2442026-04-03T18:01:43
SalesByAsin-2025-12.csvsales_by_asin2332026-04-03T18:01:43
SalesByAsin-2025-11.csvsales_by_asin2262026-04-03T18:01:43
SalesByAsin-2025-10.csvsales_by_asin2282026-04-03T18:01:43
SalesByAsin-2025-09.csvsales_by_asin2322026-04-03T18:01:43
SalesByAsin-2025-08.csvsales_by_asin2432026-04-03T18:01:43
SalesByAsin-2025-07.csvsales_by_asin2422026-04-03T18:01:43
SalesByAsin-2025-06.csvsales_by_asin2472026-04-03T18:01:43
SalesByAsin-2025-05.csvsales_by_asin2522026-04-03T18:01:43
SalesByAsin-2025-04.csvsales_by_asin2532026-04-03T18:01:43
SalesByAsin-2025-03.csvsales_by_asin2462026-04-03T18:01:43
SalesByAsin-2025-02.csvsales_by_asin2542026-04-03T18:01:43
SalesByAsin-2025-01.csvsales_by_asin2512026-04-03T18:01:43
SalesByMonth-2026.csvsales_monthly32026-04-03T18:01:42
SalesByMonth-2025.csvsales_monthly122026-04-03T18:01:42
SalesByMonth-2024.csvsales_monthly92026-04-03T18:01:42

Data Folder Structure

FolderPurposeFile PatternFiles
SalesByMonth/Monthly aggregate sales (D2C + B2B)SalesByMonth-YYYY.csv3
SalesByAsin/SKU-level performance per monthSalesByAsin-YYYY-MM.csv15
SearchQueryPerformance/Brand search keyword dataSearchQueryPerformance-YYYY-MM.csv
SellerPerformance/Daily seller metricsSellerPerformance-YYYY.csv3
(root)PPC advertising search termsAdvertisingSearchTermReport_*.xlsx1

Deduplication Status

SalesByMonth overlap handlingActive — INSERT OR IGNORE on Date
SellerPerformance overlap handlingActive — INSERT OR IGNORE on Date
PPC data strategyLatest report file only
Team Access
Cloudflare Access is protecting dashboard.wduluv.com — email-based login required

Authorized Users

JL
ER
AM
EB

Security Settings

AuthenticationOne-Time Pin (Email)
Session Duration24 hours
Public .pages.dev URLDisabled
HTTPSEnforced
ProviderCloudflare Zero Trust (Free)

Access Logs

View who has accessed the dashboard, login attempts, and blocked requests.

View Access Logs →
Deployment History

Recent Deployments

Deploy IDTimeStatusEnvironmentURL
No deployments found

Deployment Configuration

PlatformCloudflare Pages
Projectenvisioned-dashboard
Production Domaindashboard.wduluv.com
Deploy MethodWrangler CLI (automated)
Auto-deployDaily at 7:00 AM ET
Refresh Data

How Data Updates Work

Automatic (Daily at 7 AM):

  1. Pipeline scans CSV/Excel folders for new files
  2. New data is ingested into SQLite database
  3. Dashboard HTML is rebuilt with latest data
  4. Deployed to Cloudflare — live in ~30 seconds

To update data:

  1. Download new reports from Amazon Seller Central
  2. Drop CSV/Excel files into the correct folder in iCloud Drive
  3. Pipeline auto-detects and processes at next scheduled run
  4. Or use the Refresh button to trigger immediately
🔄

Ready to Refresh

Last build: April 07, 2026

Next scheduled: Daily 7:00 AM

Triggers a full pipeline: ingest → build → deploy

Pipeline Run Log

[2026-04-06 20:51:17] STEP 1: Ingesting CSV/Excel files into database... [2026-04-06 20:51:23] STEP 2: Building HTML dashboard + settings from database... [2026-04-06 20:51:23] V1 dashboard copied to deploy/v1/ [2026-04-06 20:51:23] V2 dashboard copied to deploy/v2/ [2026-04-06 20:51:23] Redirector index.html created in deploy/ [2026-04-06 20:51:23] Settings built and copied to deploy/settings/ [2026-04-06 20:51:23] P&L dashboard copied to deploy/pnl/ [2026-04-06 20:51:23] Growth report copied to deploy/growth/ [2026-04-06 20:51:23] Skipping deploy (--no-deploy flag) [2026-04-06 20:51:23] Pipeline complete! [2026-04-06 20:51:23] ============================================================ [2026-04-07 14:02:12] ============================================================ [2026-04-07 14:02:12] Envisioned Dashboard Pipeline [2026-04-07 14:02:12] ============================================================ [2026-04-07 14:02:12] STEP 1: Ingesting CSV/Excel files into database... [2026-04-07 14:02:17] STEP 2: Building HTML dashboard + settings from database... [2026-04-07 14:02:18] V1 dashboard copied to deploy/v1/ [2026-04-07 14:02:18] V2 dashboard copied to deploy/v2/ [2026-04-07 14:02:18] Redirector index.html created in deploy/ [2026-04-07 14:02:18] Settings built and copied to deploy/settings/ [2026-04-07 14:02:18] P&L dashboard copied to deploy/pnl/ [2026-04-07 14:02:18] Growth report copied to deploy/growth/ [2026-04-07 14:02:18] Skipping deploy (--no-deploy flag) [2026-04-07 14:02:18] Pipeline complete! [2026-04-07 14:02:18] ============================================================ [2026-04-07 19:05:38] ============================================================ [2026-04-07 19:05:38] Envisioned Dashboard Pipeline [2026-04-07 19:05:38] ============================================================ [2026-04-07 19:05:38] STEP 1: Ingesting CSV/Excel files into database... [2026-04-07 19:05:49] STEP 2: Building HTML dashboard + settings from database...
Activity Log

Recent Pipeline Activity

2026-04-07 19:05:49
STEP 2: Building HTML dashboard + settings from database...
2026-04-07 19:05:38
STEP 1: Ingesting CSV/Excel files into database...
2026-04-07 19:05:38
============================================================
2026-04-07 19:05:38
Envisioned Dashboard Pipeline
2026-04-07 19:05:38
============================================================
2026-04-07 14:02:18
============================================================
2026-04-07 14:02:18
Pipeline complete!
2026-04-07 14:02:18
Skipping deploy (--no-deploy flag)
2026-04-07 14:02:18
Growth report copied to deploy/growth/
2026-04-07 14:02:18
P&L dashboard copied to deploy/pnl/
2026-04-07 14:02:18
Settings built and copied to deploy/settings/
2026-04-07 14:02:18
Redirector index.html created in deploy/
2026-04-07 14:02:18
V2 dashboard copied to deploy/v2/
2026-04-07 14:02:18
V1 dashboard copied to deploy/v1/
2026-04-07 14:02:17
STEP 2: Building HTML dashboard + settings from database...
2026-04-07 14:02:12
STEP 1: Ingesting CSV/Excel files into database...
2026-04-07 14:02:12
============================================================
2026-04-07 14:02:12
Envisioned Dashboard Pipeline
2026-04-07 14:02:12
============================================================
2026-04-06 20:51:23
============================================================
2026-04-06 20:51:23
Pipeline complete!
2026-04-06 20:51:23
Skipping deploy (--no-deploy flag)
2026-04-06 20:51:23
Growth report copied to deploy/growth/
2026-04-06 20:51:23
P&L dashboard copied to deploy/pnl/
2026-04-06 20:51:23
Settings built and copied to deploy/settings/
2026-04-06 20:51:23
Redirector index.html created in deploy/
2026-04-06 20:51:23
V2 dashboard copied to deploy/v2/
2026-04-06 20:51:23
V1 dashboard copied to deploy/v1/
2026-04-06 20:51:23
STEP 2: Building HTML dashboard + settings from database...
2026-04-06 20:51:17
STEP 1: Ingesting CSV/Excel files into database...
2026-04-06 20:51:17
============================================================
2026-04-06 20:51:17
Envisioned Dashboard Pipeline
2026-04-06 20:51:17
============================================================
2026-04-04 23:21:02
============================================================
2026-04-04 23:21:02
Pipeline complete!
2026-04-04 23:21:02
Deployment successful!
2026-04-04 23:20:48
STEP 3: Deploying to Cloudflare Pages...
2026-04-04 23:20:48
Growth report copied to deploy/growth/
2026-04-04 23:20:48
P&L dashboard copied to deploy/pnl/
2026-04-04 23:20:48
Settings built and copied to deploy/settings/
2026-04-04 23:20:48
Redirector index.html created in deploy/
2026-04-04 23:20:48
V2 dashboard copied to deploy/v2/
2026-04-04 23:20:48
V1 dashboard copied to deploy/v1/
2026-04-04 23:20:48
STEP 2: Building HTML dashboard + settings from database...
2026-04-04 23:20:43
STEP 1: Ingesting CSV/Excel files into database...
2026-04-04 23:20:43
============================================================
2026-04-04 23:20:43
Envisioned Dashboard Pipeline
2026-04-04 23:20:43
============================================================
2026-04-03 23:24:17
============================================================
2026-04-03 23:24:17
Pipeline complete!

System Information

Database Location~/.envisioned/envisioned.db
Pipeline Scriptpipeline.py
Build Scriptbuild_html_dashboard.py
Deploy MethodWrangler → Cloudflare Pages
Cron ScheduleDaily 7:00 AM + refresh checks every 30 min
Python VersionPython 3.9.6
Settings GeneratedApril 07, 2026