Connecting…

PRECISE EDGE BENEFITS·Campaign Performance

Source: Google Ads Scripts → six rolling snapshot sheets · Conversions per Google Ads conversion tracking · Windows are trailing, not calendar

This page has to be served over http, not opened as a local file

It is currently running from a file:// address. A page loaded that way has no origin, so the browser blocks every request it makes to another domain — including the ones to Google Sheets. This is a browser rule, not a problem with the sheets or their sharing settings.

Upload the file to your domain and open it over https:// and the data will load. To test locally first, serve the folder instead of double-clicking the file — for example run python3 -m http.server 8080 in that folder and open http://localhost:8080.

Can't reach the Google Sheets

The page reads the six Google Ads Script sheets directly, so each one has to be readable without a Google login.

Open each sheet → Share → General access → Anyone with the link → Viewer.
If a sheet still fails, use File → Share → Publish to web → Entire document.
Check the tab names against the TABS list in this file's CONFIG block.

Data source. Google Ads Scripts write to six Google Sheets (Yesterday, Rolling 7/14/30/60/90). This page reads them directly on load — nothing is cached or hand-entered, so it always reflects the latest script run.

How periods are derived. The sheets are cumulative snapshots, not daily rows. Non-overlapping periods are produced by subtracting additive metrics only (impressions, clicks, cost, conversions); every rate is then recomputed from those bases rather than subtracted. Exact prior-period comparison is only mathematically available for the 7-day and 30-day windows; elsewhere the comparison is suppressed rather than approximated. Sections that need true day-level data say so instead of estimating it.

Compliance reminder. Insurance advertising requires the licensed agency name and the city and state of the principal office (Columbus, WI) in creative, plus the Wisconsin license number for Wisconsin advertising; Illinois requires identifying the insurer(s) whose products are offered. Superlatives and statistical claims need substantiation — claims currently running as assets, including “20+ Top Carriers”, “7,500+ Employees Covered” and “15+ Years Experience”, should each have evidence on file.