E

Dashboard Settings

Admin Panel — Envisioned Products
← Back to Dashboard ADMIN
System Status Data Sources Team Access Deployments Refresh Data Activity Log
System Status
🟢
All Systems Go
Last checked: —

Dashboard

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

Data Pipeline

ScheduleDaily 7:00 AM
Database3.4 MB
Total Records13,295
Ingested Files39

Sales Monthly

24
rows
2024-05 → 2026-04

Sales by ASIN

3,544
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 03, 2026

Next scheduled: Daily 7:00 AM

Triggers a full pipeline: ingest → build → deploy

Pipeline Run Log

[2026-04-03 18:01:14] ============================================================ [2026-04-03 18:01:14] Envisioned Dashboard Pipeline [2026-04-03 18:01:14] ============================================================ [2026-04-03 18:01:14] STEP 1: Ingesting CSV/Excel files into database... [2026-04-03 18:01:42] ============================================================ [2026-04-03 18:01:42] Envisioned Dashboard Pipeline [2026-04-03 18:01:42] ============================================================ [2026-04-03 18:01:42] STEP 1: Ingesting CSV/Excel files into database... [2026-04-03 18:01:44] STEP 2: Building HTML dashboard from database... [2026-04-03 18:01:44] Dashboard built and copied to deploy/index.html [2026-04-03 18:01:44] Skipping deploy (--no-deploy flag) [2026-04-03 18:01:44] Pipeline complete! [2026-04-03 18:01:44] ============================================================ [2026-04-03 18:01:49] ============================================================ [2026-04-03 18:01:49] Envisioned Dashboard Pipeline [2026-04-03 18:01:49] ============================================================ [2026-04-03 19:05:34] ============================================================ [2026-04-03 19:05:34] Envisioned Dashboard Pipeline [2026-04-03 19:05:34] ============================================================ [2026-04-03 19:05:34] STEP 1: Ingesting CSV/Excel files into database... [2026-04-03 19:05:34] STEP 2: Building HTML dashboard + settings from database... [2026-04-03 19:05:35] Dashboard + Settings built and copied to deploy/ [2026-04-03 19:05:35] Skipping deploy (--no-deploy flag) [2026-04-03 19:05:35] Pipeline complete! [2026-04-03 19:05:35] ============================================================ [2026-04-03 20:22:38] ============================================================ [2026-04-03 20:22:38] Envisioned Dashboard Pipeline [2026-04-03 20:22:38] ============================================================ [2026-04-03 20:22:38] STEP 1: Ingesting CSV/Excel files into database... [2026-04-03 20:22:38] STEP 2: Building HTML dashboard + settings from database...
Activity Log

Recent Pipeline Activity

2026-04-03 20:22:38
STEP 2: Building HTML dashboard + settings from database...
2026-04-03 20:22:38
STEP 1: Ingesting CSV/Excel files into database...
2026-04-03 20:22:38
============================================================
2026-04-03 20:22:38
Envisioned Dashboard Pipeline
2026-04-03 20:22:38
============================================================
2026-04-03 19:05:35
============================================================
2026-04-03 19:05:35
Pipeline complete!
2026-04-03 19:05:35
Skipping deploy (--no-deploy flag)
2026-04-03 19:05:35
Dashboard + Settings built and copied to deploy/
2026-04-03 19:05:34
STEP 2: Building HTML dashboard + settings from database...
2026-04-03 19:05:34
STEP 1: Ingesting CSV/Excel files into database...
2026-04-03 19:05:34
============================================================
2026-04-03 19:05:34
Envisioned Dashboard Pipeline
2026-04-03 19:05:34
============================================================
2026-04-03 18:01:49
============================================================
2026-04-03 18:01:49
Envisioned Dashboard Pipeline
2026-04-03 18:01:49
============================================================
2026-04-03 18:01:44
============================================================
2026-04-03 18:01:44
Pipeline complete!
2026-04-03 18:01:44
Skipping deploy (--no-deploy flag)
2026-04-03 18:01:44
Dashboard built and copied to deploy/index.html
2026-04-03 18:01:44
STEP 2: Building HTML dashboard from database...
2026-04-03 18:01:42
STEP 1: Ingesting CSV/Excel files into database...
2026-04-03 18:01:42
============================================================
2026-04-03 18:01:42
Envisioned Dashboard Pipeline
2026-04-03 18:01:42
============================================================
2026-04-03 18:01:14
STEP 1: Ingesting CSV/Excel files into database...
2026-04-03 18:01:14
============================================================
2026-04-03 18:01:14
Envisioned Dashboard Pipeline
2026-04-03 18:01:14
============================================================
2026-04-03 18:00:53
STEP 1: Ingesting CSV/Excel files into database...
2026-04-03 18:00:53
============================================================
2026-04-03 18:00:53
Envisioned Dashboard Pipeline
2026-04-03 18:00:53
============================================================

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 03, 2026