=== PRE-RUN DATABASE BACKUP AND SAFETY CHECK ===
PASS: Pre-import SQLite backup created.
PASS: Database integrity is OK.
PASS: Production intelligence tables are empty.

=== RUN APPROVED WEEKLY INTELLIGENCE IMPORT ===
{
  "ok": true,
  "processing": {
    "imported": [
      {
        "ok": true,
        "sourceRecordId": "src_10d53936deb744a38f26c085d28a8bba",
        "researchLeadCount": 6,
        "evidenceCount": 6,
        "opportunitiesCreated": 0,
        "buyerIntentClaimed": false,
        "salesClaimed": false,
        "archivePath": "/SHiREVault/SHIRE3D/TrendScout/source-snapshots/google-trends/google-trends-20260731T053446Z-1dbfef44e51bc5af.csv",
        "archiveSha256": "1dbfef44e51bc5af56d107a429dcdedfbb865fd9af14562fdae1d6ac64c98dbc",
        "terms": [
          "controller stand",
          "dice tower",
          "3D printed lamp",
          "desk organiser",
          "articulated dragon",
          "fidget toy"
        ],
        "processedPath": "/SHiREVault/SHIRE3D/TrendScout/weekly-inbox/processed/20260731T053446Z-imported-time_series_AU_20250730-1536_20260730-1536.csv"
      }
    ],
    "duplicates": [],
    "rejected": []
  },
  "report": {
    "reportId": "weekly_2026-W31",
    "reportingPeriod": "2026-W31",
    "status": "SEARCH_DEMAND_ONLY_MORE_SALES_EVIDENCE_REQUIRED",
    "databaseStatus": "DRAFT_READY",
    "reportJsonPath": "/SHiREVault/SHIRE3D/TrendScout/weekly-reports/2026-W31/report.json",
    "reportMarkdownPath": "/SHiREVault/SHIRE3D/TrendScout/weekly-reports/2026-W31/report.md",
    "reportSha256": "4f64d196aee200a4efa13518536a1264829d05dbeb2da93d1f3ce123872e06f6"
  },
  "mostInDemandCount": 6,
  "commerciallyPromisingCount": 0,
  "verifiedCommercialFileCount": 0,
  "routineEmailsSent": 0,
  "externalActionsPerformed": {
    "filesDownloaded": 0,
    "filesPurchased": 0,
    "printsStarted": 0,
    "forgeHandoffs": 0,
    "listingsCreated": 0,
    "itemsPublished": 0,
    "advertisingStarted": 0,
    "moneySpent": 0,
    "emailsSent": 0
  }
}

=== VERIFY IMPORT, RANKING AND REPORT ===
PASS: Approved CSV was imported exactly once.
PASS: Six research leads were created.
PASS: Six SEARCH_GROWTH evidence records were created.
PASS: Buyer intent and confirmed sales remain unproven.
PASS: No opportunities or commercial claims were created.
PASS: No files, licences, Forge work or emails were created.

FIRST REAL SEARCH-INTEREST RANKING:
1. fidget toy — score 72.08 — RISING
2. desk organiser — score 48.3 — STABLE_OR_MIXED
3. controller stand — score 28.3 — RISING
4. dice tower — score 2.89 — STABLE_OR_MIXED
5. 3D printed lamp — score 0.88 — STABLE_OR_MIXED
6. articulated dragon — score 0.74 — STABLE_OR_MIXED

Report status: SEARCH_DEMAND_ONLY_MORE_SALES_EVIDENCE_REQUIRED
Report JSON: /SHiREVault/SHIRE3D/TrendScout/weekly-reports/2026-W31/report.json
Report Markdown: /SHiREVault/SHIRE3D/TrendScout/weekly-reports/2026-W31/report.md

=== VERIFY PROCESSED EVIDENCE ARCHIVE ===
PASS: Processed evidence checksum verified:
/SHiREVault/SHIRE3D/TrendScout/weekly-inbox/processed/20260731T053446Z-imported-time_series_AU_20250730-1536_20260730-1536.csv
PASS: Original /home/ray CSV remains intact.

=== LIVE WORKSPACE AND TIMER CHECK ===
{
  "items": [
    {
      "report_id": "weekly_2026-W31",
      "reporting_period": "2026-W31",
      "status": "DRAFT_READY",
      "routine_email_count": 0,
      "demo_records_excluded": 1,
      "created_at": "2026-07-31T05:34:46.252221+00:00",
      "updated_at": "2026-07-31T05:34:46.252221+00:00",
      "report": {
        "approvalActions": [
          {
            "action": "Connect or import a permitted buyer-intent or customer-enquiry source.",
            "approval": "Required before enabling the source.",
            "requiredFor": "Commercial validation"
          },
          {
            "action": "Connect a permitted transactional or Shire3D confirmed-sales source.",
            "approval": "Required before enabling the source.",
            "requiredFor": "Proven-seller ranking"
          },
          {
            "action": "Research legitimate commercial STL, 3MF or STEP sources for the highest-ranked terms.",
            "approval": "Required before any download or purchase.",
            "requiredFor": "Ready-to-print recommendations"
          },
          {
            "action": "Review the weekly intelligence report.",
            "approval": "Explicit Ray approval is always required.",
            "requiredFor": "Any printing, Forge handoff, listing, publishing, advertising or spending"
          }
        ],
        "approvedInboxProcessing": {
          "duplicates": [],
          "imported": [
            {
              "archivePath": "/SHiREVault/SHIRE3D/TrendScout/source-snapshots/google-trends/google-trends-20260731T053446Z-1dbfef44e51bc5af.csv",
              "archiveSha256": "1dbfef44e51bc5af56d107a429dcdedfbb865fd9af14562fdae1d6ac64c98dbc",
              "buyerIntentClaimed": false,
              "evidenceCount": 6,
              "ok": true,
              "opportunitiesCreated": 0,
              "processedPath": "/SHiREVault/SHIRE3D/TrendScout/weekly-inbox/processed/20260731T053446Z-imported-time_series_AU_20250730-1536_20260730-1536.csv",
              "researchLeadCount": 6,
              "salesClaimed": false,
              "sourceRecordId": "src_10d53936deb744a38f26c085d28a8bba",
              "terms": [
                "controller stand",
                "dice tower",
                "3D printed lamp",
                "desk organiser",
                "articulated dragon",
                "fidget toy"
              ]
            }
          ],
          "rejected": []
        },
        "commerciallyPromising": [],
        "demoRecordsExcluded": true,
        "externalActionsPerformed": {
          "advertisingStarted": 0,
          "emailsSent": 0,
          "filesDownloaded": 0,
          "filesPurchased": 0,
          "forgeHandoffs": 0,
          "itemsPublished": 0,
          "listingsCreated": 0,
          "moneySpent": 0,
          "printsStarted": 0
        },
        "generatedAt": "2026-07-31T05:34:46.252221+00:00",
        "googleTrendsSettings": {
          "approvedInboxMeansExplicitRayApproval": true,
          "geography": "Australia",
          "searchType": "Web Search",
          "sourceAdapterId": "google-trends-manual",
          "sourceUrl": "https://trends.google.com/trends/explore?geo=AU",
          "timeRange": "Past 12 months"
        },
        "limitations": [
          "Google Trends is relative search-interest evidence and does not prove sales.",
          "Search popularity, social attention, listings, buyer intent and confirmed sales remain separate signals.",
          "Commercial physical-print rights must be verified before launch.",
          "Price, printability, cost, margin, competition, channel and selling-angle fields remain blank until supported evidence exists.",
          "Weekly email delivery is not installed yet."
        ],
        "localGeneratedAt": "2026-07-31T13:34:46.252221+08:00",
        "mostInDemand": [
          {
            "averageRelativeInterest": 63.45,
            "buyerIntent": false,
            "collectedAt": "2026-07-31T05:34:46.157607+00:00",
            "confirmedSales": false,
            "direction": "RISING",
            "latestRelativeInterest": 64.0,
            "maximumRelativeInterest": 96.0,
            "normalisedProduct": "fidget toy",
            "product": "fidget toy",
            "rank": 1,
            "recentAverageRelativeInterest": 71.46,
            "sampleCount": 53,
            "searchDemandScore": 72.08,
            "signalClassification": "SEARCH_INTEREST_ONLY",
            "sourceArchiveSha256": "1dbfef44e51bc5af56d107a429dcdedfbb865fd9af14562fdae1d6ac64c98dbc",
            "sourcePayloadSha256": "695b2eb41f5efea46fed75680a9452617b678ce1d53802ba1950559e9cb3703b",
            "sourceRecordId": "src_10d53936deb744a38f26c085d28a8bba",
            "sourceUrl": "https://trends.google.com/trends/explore?geo=AU",
            "whyInDemand": "Google Trends direction is RISING; latest relative interest is 64.0. This is search-interest evidence, not proof of purchases or completed sales."
          },
          {
            "averageRelativeInterest": 53.81,
            "buyerIntent": false,
            "collectedAt": "2026-07-31T05:34:46.157607+00:00",
            "confirmedSales": false,
            "direction": "STABLE_OR_MIXED",
            "latestRelativeInterest": 57.0,
            "maximumRelativeInterest": 100.0,
            "normalisedProduct": "desk organiser",
            "product": "desk organiser",
            "rank": 2,
            "recentAverageRelativeInterest": 52.0,
            "sampleCount": 53,
            "searchDemandScore": 48.3,
            "signalClassification": "SEARCH_INTEREST_ONLY",
            "sourceArchiveSha256": "1dbfef44e51bc5af56d107a429dcdedfbb865fd9af14562fdae1d6ac64c98dbc",
            "sourcePayloadSha256": "695b2eb41f5efea46fed75680a9452617b678ce1d53802ba1950559e9cb3703b",
            "sourceRecordId": "src_10d53936deb744a38f26c085d28a8bba",
            "sourceUrl": "https://trends.google.com/trends/explore?geo=AU",
            "whyInDemand": "Google Trends direction is STABLE_OR_MIXED; latest relative interest is 57.0. This is search-interest evidence, not proof of purchases or completed sales."
          },
          {
            "averageRelativeInterest": 19.7,
            "buyerIntent": false,
            "collectedAt": "2026-07-31T05:34:46.157607+00:00",
            "confirmedSales": false,
            "direction": "RISING",
            "latestRelativeInterest": 17.0,
            "maximumRelativeInterest": 40.0,
            "normalisedProduct": "controller stand",
            "product": "controller stand",
            "rank": 3,
            "recentAverageRelativeInterest": 22.0,
            "sampleCount": 53,
            "searchDemandScore": 28.3,
            "signalClassification": "SEARCH_INTEREST_ONLY",
            "sourceArchiveSha256": "1dbfef44e51bc5af56d107a429dcdedfbb865fd9af14562fdae1d6ac64c98dbc",
            "sourcePayloadSha256": "695b2eb41f5efea46fed75680a9452617b678ce1d53802ba1950559e9cb3703b",
            "sourceRecordId": "src_10d53936deb744a38f26c085d28a8bba",
            "sourceUrl": "https://trends.google.com/trends/explore?geo=AU",
            "whyInDemand": "Google Trends direction is RISING; latest relative interest is 17.0. This is search-interest evidence, not proof of purchases or completed sales."
          },
          {
            "averageRelativeInterest": 3.25,
            "buyerIntent": false,
            "collectedAt": "2026-07-31T05:34:46.157607+00:00",
            "confirmedSales": false,
            "direction": "STABLE_OR_MIXED",
            "latestRelativeInterest": 7.0,
            "maximumRelativeInterest": 24.0,
            "normalisedProduct": "dice tower",
            "product": "dice tower",
            "rank": 4,
            "recentAverageRelativeInterest": 1.31,
            "sampleCount": 53,
            "searchDemandScore": 2.89,
            "signalClassification": "SEARCH_INTEREST_ONLY",
            "sourceArchiveSha256": "1dbfef44e51bc5af56d107a429dcdedfbb865fd9af14562fdae1d6ac64c98dbc",
            "sourcePayloadSha256": "695b2eb41f5efea46fed75680a9452617b678ce1d53802ba1950559e9cb3703b",
            "sourceRecordId": "src_10d53936deb744a38f26c085d28a8bba",
            "sourceUrl": "https://trends.google.com/trends/explore?geo=AU",
            "whyInDemand": "Google Trends direction is STABLE_OR_MIXED; latest relative interest is 7.0. This is search-interest evidence, not proof of purchases or completed sales."
          },
          {
            "averageRelativeInterest": 0.43,
            "buyerIntent": false,
            "collectedAt": "2026-07-31T05:34:46.157607+00:00",
            "confirmedSales": false,
            "direction": "STABLE_OR_MIXED",
            "latestRelativeInterest": 2.0,
            "maximumRelativeInterest": 17.0,
            "normalisedProduct": "3d printed lamp",
            "product": "3D printed lamp",
            "rank": 5,
            "recentAverageRelativeInterest": 0.46,
            "sampleCount": 53,
            "searchDemandScore": 0.88,
            "signalClassification": "SEARCH_INTEREST_ONLY",
            "sourceArchiveSha256": "1dbfef44e51bc5af56d107a429dcdedfbb865fd9af14562fdae1d6ac64c98dbc",
            "sourcePayloadSha256": "695b2eb41f5efea46fed75680a9452617b678ce1d53802ba1950559e9cb3703b",
            "sourceRecordId": "src_10d53936deb744a38f26c085d28a8bba",
            "sourceUrl": "https://trends.google.com/trends/explore?geo=AU",
            "whyInDemand": "Google Trends direction is STABLE_OR_MIXED; latest relative interest is 2.0. This is search-interest evidence, not proof of purchases or completed sales."
          },
          {
            "averageRelativeInterest": 0.06,
            "buyerIntent": false,
            "collectedAt": "2026-07-31T05:34:46.157607+00:00",
            "confirmedSales": false,
            "direction": "STABLE_OR_MIXED",
            "latestRelativeInterest": 2.0,
            "maximumRelativeInterest": 2.0,
            "normalisedProduct": "articulated dragon",
            "product": "articulated dragon",
            "rank": 6,
            "recentAverageRelativeInterest": 0.23,
            "sampleCount": 53,
            "searchDemandScore": 0.74,
            "signalClassification": "SEARCH_INTEREST_ONLY",
            "sourceArchiveSha256": "1dbfef44e51bc5af56d107a429dcdedfbb865fd9af14562fdae1d6ac64c98dbc",
            "sourcePayloadSha256": "695b2eb41f5efea46fed75680a9452617b678ce1d53802ba1950559e9cb3703b",
            "sourceRecordId": "src_10d53936deb744a38f26c085d28a8bba",
            "sourceUrl": "https://trends.google.com/trends/explore?geo=AU",
            "whyInDemand": "Google Trends direction is STABLE_OR_MIXED; latest relative interest is 2.0. This is search-interest evidence, not proof of purchases or completed sales."
          }
        ],
        "noSafeLaunchRecommendation": true,
        "originalDesignOpportunities": [
          {
            "demandRank": 1,
            "forgeBriefStatus": "NOT_CREATED",
            "product": "fidget toy",
            "rayApprovalRequired": true,
            "reason": "Demand evidence exists, but no verified commercial STL/3MF/STEP file is stored.",
            "searchDemandScore": 72.08
          },
          {
            "demandRank": 2,
            "forgeBriefStatus": "NOT_CREATED",
            "product": "desk organiser",
            "rayApprovalRequired": true,
            "reason": "Demand evidence exists, but no verified commercial STL/3MF/STEP file is stored.",
            "searchDemandScore": 48.3
          },
          {
            "demandRank": 3,
            "forgeBriefStatus": "NOT_CREATED",
            "product": "controller stand",
            "rayApprovalRequired": true,
            "reason": "Demand evidence exists, but no verified commercial STL/3MF/STEP file is stored.",
            "searchDemandScore": 28.3
          },
          {
            "demandRank": 4,
            "forgeBriefStatus": "NOT_CREATED",
            "product": "dice tower",
            "rayApprovalRequired": true,
            "reason": "Demand evidence exists, but no verified commercial STL/3MF/STEP file is stored.",
            "searchDemandScore": 2.89
          },
          {
            "demandRank": 5,
            "forgeBriefStatus": "NOT_CREATED",
            "product": "3D printed lamp",
            "rayApprovalRequired": true,
            "reason": "Demand evidence exists, but no verified commercial STL/3MF/STEP file is stored.",
            "searchDemandScore": 0.88
          },
          {
            "demandRank": 6,
            "forgeBriefStatus": "NOT_CREATED",
            "product": "articulated dragon",
            "rayApprovalRequired": true,
            "reason": "Demand evidence exists, but no verified commercial STL/3MF/STEP file is stored.",
            "searchDemandScore": 0.74
          }
        ],
        "rejectedItems": [],
        "reportId": "weekly_2026-W31",
        "reportingPeriod": "2026-W31",
        "reportingPeriodEnd": "2026-08-02",
        "reportingPeriodStart": "2026-07-27",
        "risingOpportunities": [
          {
            "averageRelativeInterest": 63.45,
            "buyerIntent": false,
            "collectedAt": "2026-07-31T05:34:46.157607+00:00",
            "confirmedSales": false,
            "direction": "RISING",
            "latestRelativeInterest": 64.0,
            "maximumRelativeInterest": 96.0,
            "normalisedProduct": "fidget toy",
            "product": "fidget toy",
            "rank": 1,
            "recentAverageRelativeInterest": 71.46,
            "sampleCount": 53,
            "searchDemandScore": 72.08,
            "signalClassification": "SEARCH_INTEREST_ONLY",
            "sourceArchiveSha256": "1dbfef44e51bc5af56d107a429dcdedfbb865fd9af14562fdae1d6ac64c98dbc",
            "sourcePayloadSha256": "695b2eb41f5efea46fed75680a9452617b678ce1d53802ba1950559e9cb3703b",
            "sourceRecordId": "src_10d53936deb744a38f26c085d28a8bba",
            "sourceUrl": "https://trends.google.com/trends/explore?geo=AU",
            "whyInDemand": "Google Trends direction is RISING; latest relative interest is 64.0. This is search-interest evidence, not proof of purchases or completed sales."
          },
          {
            "averageRelativeInterest": 19.7,
            "buyerIntent": false,
            "collectedAt": "2026-07-31T05:34:46.157607+00:00",
            "confirmedSales": false,
            "direction": "RISING",
            "latestRelativeInterest": 17.0,
            "maximumRelativeInterest": 40.0,
            "normalisedProduct": "controller stand",
            "product": "controller stand",
            "rank": 3,
            "recentAverageRelativeInterest": 22.0,
            "sampleCount": 53,
            "searchDemandScore": 28.3,
            "signalClassification": "SEARCH_INTEREST_ONLY",
            "sourceArchiveSha256": "1dbfef44e51bc5af56d107a429dcdedfbb865fd9af14562fdae1d6ac64c98dbc",
            "sourcePayloadSha256": "695b2eb41f5efea46fed75680a9452617b678ce1d53802ba1950559e9cb3703b",
            "sourceRecordId": "src_10d53936deb744a38f26c085d28a8bba",
            "sourceUrl": "https://trends.google.com/trends/explore?geo=AU",
            "whyInDemand": "Google Trends direction is RISING; latest relative interest is 17.0. This is search-interest evidence, not proof of purchases or completed sales."
          }
        ],
        "routineEmailCount": 0,
        "schedule": {
          "catchUpMissedRun": false,
          "day": "Monday",
          "systemdCalendar": "Mon *-*-* 08:00:00 Australia/Perth",
          "time": "08:00"
        },
        "schemaVersion": 1,
        "sourceCoverage": {
          "buyerIntentAvailable": false,
          "configuredSources": [
            {
              "adapter_id": "csv-evidence-import",
              "enabled": 0,
              "health_status": "DISABLED",
              "mode": "CSV_IMPORT",
              "name": "Approved Evidence CSV Import"
            },
            {
              "adapter_id": "google-trends-manual",
              "enabled": 0,
              "health_status": "MANUAL_REVIEW_REQUIRED",
              "mode": "MANUAL_REVIEW_ONLY",
              "name": "Google Trends Evidence Review"
            },
            {
              "adapter_id": "reddit-api",
              "enabled": 0,
              "health_status": "NOT_CONFIGURED",
              "mode": "OFFICIAL_API",
              "name": "Reddit API"
            },
            {
              "adapter_id": "shire3d-internal",
              "enabled": 0,
              "health_status": "NOT_CONNECTED",
              "mode": "INTERNAL_SHIRE3D",
              "name": "Shire3D Internal Commerce Evidence"
            },
            {
              "adapter_id": "youtube-data-v3",
              "enabled": 0,
              "health_status": "NOT_CONFIGURED",
              "mode": "OFFICIAL_API",
              "name": "YouTube Data API v3"
            },
            {
              "adapter_id": "ebay-browse",
              "enabled": 0,
              "health_status": "NOT_CONFIGURED",
              "mode": "OFFICIAL_API",
              "name": "eBay Browse API"
            }
          ],
          "confirmedSalesAvailable": false,
          "enabledLiveSourceCount": 0,
          "evidenceByType": [
            {
              "buyer_intent_count": 0,
              "confirmed_sale_count": 0,
              "evidence_type": "SEARCH_GROWTH",
              "item_count": 6
            }
          ],
          "searchInterestAvailable": true
        },
        "status": "SEARCH_DEMAND_ONLY_MORE_SALES_EVIDENCE_REQUIRED",
        "timezone": "Australia/Perth",
        "trackedTerms": [
          "controller stand",
          "dice tower",
          "3D printed lamp",
          "desk organiser",
          "articulated dragon",
          "fidget toy"
        ],
        "verifiedCommercialFiles": []
      }
    }
  ],
  "readOnly": true
}
NEXT                           LEFT LAST PASSED UNIT                                       ACTIVATES
Mon 2026-08-03 08:00:00 AWST 2 days -         - shire-trendscout-weekly-intelligence.timer shire-trendscout-weekly-intelligence.service

1 timers listed.

=== FIRST REAL WEEKLY REPORT RESULT ===
PASS: First genuine TrendScout Weekly Report generated.
PASS: Rankings are labelled as search interest only.
PASS: Buyer intent and confirmed sales remain separate.
PASS: No purchase, download, print, listing, email or spending occurred.

Open TrendScout and select Weekly Reports:
http://100.116.93.90:8781

Evidence: /SHiREVault/Backup/OSBackups/TRENDSCOUT-FIRST-REAL-REPORT-RESUME-20260731T053445Z