Ganntz Tools — Overview

Net Revenue ⓘ

—

Gross Revenue—

− Customer Refunds —

− Alert Refunds—

− Lost Chargebacks—

Orders

—

non-cancelled · created in period

Avg Order Value

—

revenue ÷ orders

Ad Spend

—

no data for period

Google · Meta · Pinterest

ROAS

—

revenue ÷ ad spend

Contribution Margin

—

after spend & COGS

Avg COGS

—

% of revenue (avg across stores)

Alert Refunds

—

CDRN · Ethoca · RDR

Customer Refunds

—

of gross revenue

Operating Costs

—

payroll, VA, banking & other

Other Income

—

service fees, cashback, referrals

Revenue & Orders over time

Revenue Orders

Loading…

Top 5 Bestsellers

#	Product	Units	Revenue
Loading…

Top 5 Newcomers Products new to this period ⓘ

#	Product	Units	Revenue
Loading…

Revenue by Store Selected period · gross revenue · money-out breakdown · ROAS on net ⓘ

Store	Gross Revenue	of which deducted			Net Revenue	Orders	AOV	COG%	Ad Spend	ROAS	Share
Store	Gross Revenue	Cust. Ref.	Alert Ref.	Chgbk.	Net Revenue	Orders	AOV	COG%	Ad Spend	ROAS	Share
Loading…

Ad Spend by Platform

No ad spend recorded for this period. Use "+ Enter" above to add spend.

Pending Fulfillment — 14+ Day Orders All stores · Shopify

Order	Store	Customer	Created	Days pending
Loading…

Customer service Orders · CRM · tickets · fulfillment status

read_orders, write_orders, read_customers, write_customers, read_draft_orders, read_fulfillments, read_shipping

Product editing Products · variants · inventory · locations · publishing

read_products, write_products, read_inventory, write_inventory, read_locations, read_publications, write_publications

Fulfillment Fulfillment orders · COGS · shipping · stock levels

read_orders, write_orders, read_fulfillments, write_fulfillments, read_assigned_fulfillment_orders, write_assigned_fulfillment_orders, read_merchant_managed_fulfillment_orders, write_merchant_managed_fulfillment_orders, read_inventory, read_shipping

All tools combined Recommended One token per store covers every tool on this platform

read_all_orders, read_assigned_fulfillment_orders, write_assigned_fulfillment_orders, read_custom_fulfillment_services, read_customers, write_customers, read_draft_orders, read_files, read_fulfillment_constraint_rules, read_fulfillments, write_fulfillments, read_gift_cards, read_inventory, write_inventory, read_inventory_shipments, read_inventory_shipments_received_items, read_inventory_transfers, read_locations, read_markets, read_merchant_managed_fulfillment_orders, write_merchant_managed_fulfillment_orders, read_metaobjects, read_order_edits, read_orders, write_orders, read_payment_mandate, read_payment_notifications, read_payment_terms, read_product_feeds, read_product_listings, read_products, write_products, read_publications, write_publications, read_returns, read_shipping, read_shopify_payments_accounts, read_shopify_payments_bank_accounts, read_shopify_payments_disputes, read_shopify_payments_payouts, read_shopify_payments_provider_accounts_sensitive, read_content, read_third_party_fulfillment_orders

How to generate a Shopify access token (shpat_…)

You need: Client ID, Client Secret, and your myshopify URL — all from the custom app in the Shopify Partner / Admin dashboard.

Get a short-lived authorisation code

Open this URL in a browser (replace the placeholders), click Install app, then copy the code=… value from the redirect URL in your address bar.

https://admin.shopify.com/store/MYSHOPIFY-URL/oauth/authorize?client_id=CLIENT_ID&redirect_uri=https://example.com

Exchange the code for a permanent token in Postman

Create a new POST request to:

https://MYSHOPIFY-URL.myshopify.com/admin/oauth/access_token

Set Body → raw → JSON:

{
  "client_id": "CLIENT_ID",
  "client_secret": "CLIENT_SECRET",
  "code": "PASTE_CODE_FROM_STEP_1"
}

Send — the response contains "access_token": "shpat_…". Copy that value into the token field above.

⚠ The authorisation code from step 1 expires in 60 seconds — complete both steps in one go.

Shopify Stores

Code	Shop Name	myshopify URL	Access Code	Live URL	Country	Lang	Currency	Price Rule	Unit Format	Gender	Date Created	Permissions	Finance
Loading…

Tokens are loaded from /opt/ganntz-shared/secrets.env via systemd EnvironmentFile= — no tokens are stored in application code. A store shows Connected when both SHOPIFY_XX_DOMAIN and SHOPIFY_XX_TOKEN are present.

Source: Google Sheet

Pinterest OAuth token expires ~October 2026 — renew it before then to keep Pinterest ad spend data flowing into the sheet automatically. Go to Pinterest Ads → Settings → API Access to regenerate.

Total Spend

—

Google

—

Google

—

Meta

Campaign Breakdown

Store		Google	Meta	Pinterest	Total Spend	Net Revenue	ROAS
Select a date range and click refresh.

Ad spend flows from each store's ad platforms into a central Google Sheet and is read here automatically. The sheet has three tabs — Google, Meta, Pinterest — each in wide format: one row per date, one column per store. Google spend is synced via a script installed in each Google Ads account. Meta spend is synced via a Google Apps Script that calls the Facebook Marketing API — one script per Meta ad account, run daily.

How to install the Google Ads Script for a new store

Open the store's Google Ads account

Go to ads.google.com and switch to the correct store account.

Open Scripts

Click Tools & Settings (top-right wrench icon) → Bulk actions → Scripts. Then click the blue + button.

Paste the script below — no edits needed

The account name is auto-detected from Google Ads and matched against the header row. If the account name doesn't match the sheet column, either rename the Ads account or set ACCOUNT_OVERRIDE to the exact column header value.

/**
 * GANNTZ — Google Ads Daily Spend Sync (v7)
 * Install one copy per Google Ads account. No edits needed —
 * account name is auto-detected and matched to the sheet header.
 * Re-runs are safe; last 7 days are always re-written (self-healing).
 */
var SHEET_ID         = '127SZkm9R6Xsp7he4xdVHKlkjOkQzoevIIjJD7DPoqEI';
var TAB              = 'Google';
var LOOKBACK_DAYS    = 7;
var ACCOUNT_OVERRIDE = ''; // leave empty — or set to exact column header if name differs

function main() {
  var ss    = SpreadsheetApp.openById(SHEET_ID);
  var sheet = ss.getSheetByName(TAB);
  if (!sheet) throw new Error('Tab not found: ' + TAB);

  var store = ACCOUNT_OVERRIDE || AdsApp.currentAccount().getName();
  var tz    = AdsApp.currentAccount().getTimeZone();

  var header = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
  var col = -1;
  for (var c = 1; c < header.length; c++) {
    if (String(header[c]).trim() === String(store).trim()) { col = c + 1; break; }
  }
  if (col === -1) {
    throw new Error('Account "' + store + '" has no column in the Google tab. ' +
                    'Header: ' + header.join(', ') +
                    '. Rename the Ads account or set ACCOUNT_OVERRIDE.');
  }

  var lastRow = sheet.getLastRow();
  if (lastRow < 2) throw new Error('Google tab has no date rows in column A.');
  var dates = sheet.getRange(2, 1, lastRow - 1, 1).getValues();
  var rowOf = {};
  for (var i = 0; i < dates.length; i++) {
    var v = dates[i][0];
    if (!v) continue;
    var key = (v instanceof Date) ? Utilities.formatDate(v, tz, 'yyyy-MM-dd')
                                  : String(v).trim().substring(0, 10);
    rowOf[key] = i + 2;
  }

  var now   = new Date();
  var start = new Date(now.getTime() - LOOKBACK_DAYS * 86400000);
  var startStr = Utilities.formatDate(start, tz, 'yyyy-MM-dd');
  var endStr   = Utilities.formatDate(now,   tz, 'yyyy-MM-dd');

  var totals = {};
  var res = AdsApp.search(
    'SELECT segments.date, metrics.cost_micros FROM campaign ' +
    "WHERE segments.date BETWEEN '" + startStr + "' AND '" + endStr + "'");
  while (res.hasNext()) {
    var r = res.next();
    var d = r.segments.date;
    totals[d] = (totals[d] || 0) + (r.metrics.costMicros / 1000000);
  }

  var written = 0, missing = [];
  for (var d in totals) {
    var row = rowOf[d];
    if (!row) { missing.push(d); continue; }
    sheet.getRange(row, col).setValue(totals[d]);
    written++;
  }

  Logger.log('[' + store + '] ' + startStr + ' -> ' + endStr +
             ': wrote ' + written + ' day(s) into column ' + col);
  if (missing.length) Logger.log('[' + store + '] no date row yet for: ' + missing.join(', '));
  if (written === 0) Logger.log('[' + store + '] nothing written — no spend in window or date rows missing.');
}

Authorise and save

Click Authorize when prompted (Google needs permission to write to the sheet). Name the script e.g. "Ganntz Ad Spend Export" and save.

Schedule daily + run once manually

Set frequency to Daily (e.g. 6 AM). Then click Run once to verify — check the sheet and the Logs tab for confirmation.

Verify the sheet column exists

The Google tab must have a column header that exactly matches the Google Ads account name. If it's missing, add it — the script will start populating it from the next run.

⚠ The Google script must be installed separately in each store's own Google Ads account — it writes only to its own column.

How to install the Meta (Facebook) Ads Script for a new store

This is a Google Apps Script (not a Facebook tool) — it runs on a schedule in Google and calls the Facebook Marketing API to pull daily spend into the Meta tab of the sheet.

Get a long-lived Meta access token

Go to Meta Graph API Explorer → select your app → generate a User Token with ads_read scope. Then exchange it for a 60-day token via:

GET https://graph.facebook.com/oauth/access_token?grant_type=fb_exchange_token&client_id=APP_ID&client_secret=APP_SECRET&fb_exchange_token=SHORT_TOKEN

Find the Ad Account ID

In Meta Business Manager → Ad accounts, copy the account ID (format: act_1234567890).

Create a new Google Apps Script

Go to script.google.com → New project. Paste the script below and fill in ACCESS_TOKEN, AD_ACCOUNT_ID, and STORE_NAME.

/**
 * GANNTZ — Meta (Facebook) Ads Daily Spend Sync (v1)
 * Runs as a Google Apps Script. Fetches daily spend from the
 * Facebook Marketing API and writes to the "Meta" tab of the sheet.
 * Re-runs are safe — last 7 days are always re-written (self-healing).
 *
 * Fill in the three variables below, then run once to verify.
 */
var SHEET_ID      = '127SZkm9R6Xsp7he4xdVHKlkjOkQzoevIIjJD7DPoqEI';
var TAB           = 'Meta';
var LOOKBACK_DAYS = 7;
var ACCESS_TOKEN  = '';   // ← long-lived Meta user token (60 days, renew monthly)
var AD_ACCOUNT_ID = '';   // ← e.g. act_1234567890
var STORE_NAME    = '';   // ← exact column header in the Meta tab (e.g. Laurentcarter)

function main() {
  var ss    = SpreadsheetApp.openById(SHEET_ID);
  var sheet = ss.getSheetByName(TAB);
  if (!sheet) throw new Error('Tab not found: ' + TAB);

  // Locate store column
  var header = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
  var col = -1;
  for (var c = 1; c < header.length; c++) {
    if (String(header[c]).trim() === String(STORE_NAME).trim()) { col = c + 1; break; }
  }
  if (col === -1) throw new Error('Column "' + STORE_NAME + '" not found. Header: ' + header.join(', '));

  // Map date -> row
  var lastRow = sheet.getLastRow();
  if (lastRow < 2) throw new Error('Meta tab has no date rows in column A.');
  var dates = sheet.getRange(2, 1, lastRow - 1, 1).getValues();
  var rowOf = {};
  for (var i = 0; i < dates.length; i++) {
    var v = dates[i][0];
    if (!v) continue;
    var key = (v instanceof Date) ? Utilities.formatDate(v, 'UTC', 'yyyy-MM-dd')
                                  : String(v).trim().substring(0, 10);
    rowOf[key] = i + 2;
  }

  // Date range
  var now   = new Date();
  var start = new Date(now.getTime() - LOOKBACK_DAYS * 86400000);
  var since = Utilities.formatDate(start, 'UTC', 'yyyy-MM-dd');
  var until = Utilities.formatDate(now,   'UTC', 'yyyy-MM-dd');

  // Fetch spend from Meta Marketing API
  var url = 'https://graph.facebook.com/v19.0/' + AD_ACCOUNT_ID + '/insights' +
    '?fields=spend,date_start' +
    '&time_increment=1' +
    '&time_range={"since":"' + since + '","until":"' + until + '"}' +
    '&access_token=' + ACCESS_TOKEN;

  var resp = UrlFetchApp.fetch(url, { muteHttpExceptions: true });
  if (resp.getResponseCode() !== 200) {
    throw new Error('Meta API error: ' + resp.getContentText().substring(0, 300));
  }
  var data = JSON.parse(resp.getContentText()).data || [];

  // Write to sheet
  var written = 0, missing = [];
  for (var i = 0; i < data.length; i++) {
    var d   = data[i].date_start;
    var spend = parseFloat(data[i].spend || 0);
    var row = rowOf[d];
    if (!row) { missing.push(d); continue; }
    sheet.getRange(row, col).setValue(spend);
    written++;
  }

  Logger.log('[' + STORE_NAME + '] ' + since + ' -> ' + until +
             ': wrote ' + written + ' day(s) into column ' + col);
  if (missing.length) Logger.log('[' + STORE_NAME + '] no date row for: ' + missing.join(', '));
  if (written === 0) Logger.log('[' + STORE_NAME + '] nothing written — no spend or date rows missing.');
}

Run once to verify, then schedule daily

Click Run → authorize when prompted. Check the Logs for confirmation. Then go to Triggers (clock icon) → Add trigger → main → Time-driven → Day timer → e.g. 5–6 AM.

Renew the access token monthly

Meta long-lived tokens last ~60 days. Set a calendar reminder to refresh the token and update ACCESS_TOKEN in the script before it expires, or the script will silently stop writing.

⚠ The Meta script must be set up separately for each store's ad account — one Apps Script project per store, each writing to its own column in the Meta tab.

Total Costs

—

Largest Category

—

Entries

—

Avg / Month

—

annualised view

By Category

Upload bank statements in Documents to populate this.

Cost Trend

Loading…

Top Vendors

No data yet.

Year

Metric	Loading…
Select a year and click refresh.

Drop a bank statement or invoice here

CSV or PDF · max 15 MB · JUNI, Revolut, Sparkasse, PayPal supported

Bank / Account

Browse file

Upload History

No uploads yet.

Extracted Items

	Date	Vendor	Description	Amount	Cur	Category	Store	Employee	Relevant	Confidence

	Date ▼	Vendor ↕	Description ↕	Amount ↕	Cur ↕	Category ↕	Store ↕	Employee ↕	Source ↕		Rel. ↕
Loading…

Overview

Platform Metrics

Activity Feed

Quick Links