TC Direct Store Audit Scorecard

Audit Details

Store

Audit Date

Auditor

Audit Month

Week Number

Audit Type

Scoring:

✓

Pass

Fail

| Score = items passed ÷ total applicable items | N/A items are excluded from scoring | Gold 90%+ · A 80-89% · B 70-79% · C 60-69% · Fail <60%

Stage 1Inspire0/0 passed—

→

Stage 2Educate0/0 passed—

→

Stage 3Convert0/0 passed—

Overall Score

—

0 of 0 items scored

Action Items

Record issues and follow-ups. These export with your CSV.

Issue / Action

Owner

Due Date

Photo Submission Guide

For remote audits (MY & TH), staff submit photos using this naming convention.

What to Photograph	Naming Format	Example
Storefront / window display	`[Store]_Storefront_[YYYYMMDD]`	`SST_Storefront_20260318`
Full store interior	`[Store]_Interior_[YYYYMMDD]`	`SCS_Interior_20260318`
Product wall / display	`[Store]_ProductWall_[YYYYMMDD]`	`SST_ProductWall_20260318`
Home theater demo area	`[Store]_DemoArea_[YYYYMMDD]`	`SFS_DemoArea_20260318`
Product tags close-up	`[Store]_Tags_[YYYYMMDD]`	`Adelphi_Tags_20260318`
Promotional materials	`[Store]_Promo_[YYYYMMDD]`	`SCS_Promo_20260318`
Screen content	`[Store]_Screen_[YYYYMMDD]`	`SST_Screen_20260318`
Checkout area	`[Store]_Checkout_[YYYYMMDD]`	`Adelphi_Checkout_20260318`
Issue found	`[Store]_Issue_[Desc]_[YYYYMMDD]`	`SST_Issue_LightOut_20260318`

Store Codes: SFS (Wheelock) | Adelphi (Adelphi) | SCS (Starhill) | SST (EmSphere)

How to Use the Exports

Two export options:
1. Export Summary CSV — One row per audit with store, date, stage scores, overall score, tier. Paste into your master tracking sheet.

2. Export Detail CSV — One row per item with pass/fail and comments. Use to find which items consistently fail.

Google Sheet Column Headers

Set up your master tracking sheet with these headers:

Store | Store Name | Date | Month | Week | Auditor | Type | Inspire (%) | Educate (%) | Convert (%) | Overall (%) | Tier | Items Passed | Total Items | Action Items

Google Sheets Integration Setup

One-time setup to enable the "Send to Google Sheets" button. Takes about 5 minutes.

Step 1: Create your Google Sheet

Create a new Google Sheet and add these headers in Row 1:

Timestamp | Store | Store Name | Date | Month | Week | Auditor | Type | Inspire (%) | Educate (%) | Convert (%) | Overall (%) | Tier | Items Passed | Total Items | Action Items | Failed Items

Step 2: Add the Apps Script

In your Google Sheet, go to Extensions → Apps Script. Delete any existing code, paste the code below, then click Save.

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = JSON.parse(e.postData.contents);
  sheet.appendRow([
    new Date().toISOString(),
    data.store,
    data.storeName,
    data.date,
    data.month,
    data.week,
    data.auditor,
    data.type,
    data.inspire,
    data.educate,
    data.convert,
    data.overall,
    data.tier,
    data.passed,
    data.total,
    data.actions,
    data.failedItems
  ]);
  return ContentService
    .createTextOutput(JSON.stringify({status: "success"}))
    .setMimeType(ContentService.MimeType.JSON);
}

function doGet(e) {
  return ContentService
    .createTextOutput("TC Audit endpoint is live.")
    .setMimeType(ContentService.MimeType.TEXT);
}

Step 3: Deploy as Web App

In Apps Script, click Deploy → New deployment
Click the gear icon next to "Select type" → choose Web app
Set "Execute as" to Me
Set "Who has access" to Anyone
Click Deploy and Authorize access when prompted
Copy the Web app URL (it starts with https://script.google.com/macros/...)

Step 4: Paste your Web App URL below

This is saved in your browser so you only need to do this once.

How it works after setup:

Complete the audit → Click "Send to Google Sheets" → Data automatically appears as a new row in your sheet. That's it. Your staff just need the HTML file and the URL saved — they never need to touch the Google Sheet directly.