BKY Data Consulting
Live demo

Offline Conversions Dashboard

Your offline purchase data -> clear insights on ad performance. Live demo on synthetic data.

Hi [Client Name] — here's a working demo I built for your brick-and-mortar business; click anything, every number is live from the sample data below.

Total Offline Revenue (Ads)
$2,080.70
▲ from Google/Meta Ads
Total Offline Conversions (Ads)
13
▲ from Google/Meta Ads
Avg. Offline Purchase Value
$125.04
■ across all sources

Offline Revenue by Ad Source

This shows how much money your physical stores are making from each online ad platform.

Offline Conversions by Source

This chart highlights which marketing channels are bringing the most customers into your stores.

Offline Revenue by Store Location

See which of your 12 physical locations are generating the most revenue from all sources.

What I'd do for you

✓
Connect your offline sales data
We'll pull your exported CSVs of in-store purchases into a central system.
✓
Match offline sales to ad clicks
We'll link your in-store purchases back to your Google Ads and Meta Ads campaigns.
✓
Send conversions to Google & Meta
Your ad platforms will see which ads led to real in-store sales, improving targeting.
✓
Build custom performance reports
You'll get easy-to-understand reports showing which ads drive the most foot traffic and sales.
⚡ Plus, repetitive work I'd put on autopilot
Automate offline conversion uploads
Python · Google Ads API · Meta Ads API · Scheduled jobs
Alert on significant offline sales
Python · Slack API · Email API
See how I'd build this on your live system — and the data behind it

How it works in production

How I'd set this up on your live system:

Source
Your POS/CRM exports
Your current offline purchase CSVs
→
Processing & Matching
Python (pandas) · Google Sheets API
Clean, deduplicate, and match offline sales to ad interactions
→
Automation
Google Ads API · Meta Ads API · Scheduled jobs
Automate sending offline conversions back to your ad platforms
→
Output
Custom Dashboards · Slack/Email
Interactive reports and real-time alerts on ad performance

Recent Offline Purchases

PurchaseIDPurchaseDateLocationCustomerEmailPurchaseValueSource
P0012023-10-01NYC FlagshipcustomerA@example.com$120.50Google Ads
P0022023-10-01LA StorecustomerB@example.com$85.00Meta Ads
P0032023-10-02Chicago LoopcustomerC@example.com$210.75Organic
P0042023-10-02NYC FlagshipcustomerD@example.com$55.20Google Ads
P0052023-10-03Dallas CentralcustomerE@example.com$150.00Meta Ads
P0062023-10-03Miami BeachcustomerF@example.com$90.00Organic
P0072023-10-04LA StorecustomerG@example.com$300.00Google Ads
P0082023-10-04Chicago LoopcustomerH@example.com$75.00Meta Ads
P0092023-10-05NYC FlagshipcustomerI@example.com$180.00Google Ads
P0102023-10-05Dallas CentralcustomerJ@example.com$110.00Organic

Raw source data

View CSV Download CSV

dataset.csv — showing 12 of 20 rows. Everything above is computed from this file, untouched.

PurchaseIDPurchaseDateLocationCustomerEmailPurchaseValueSource
P0012023-10-01NYC FlagshipcustomerA@example.com120.5Google Ads
P0022023-10-01LA StorecustomerB@example.com85.0Meta Ads
P0032023-10-02Chicago LoopcustomerC@example.com210.75Organic
P0042023-10-02NYC FlagshipcustomerD@example.com55.2Google Ads
P0052023-10-03Dallas CentralcustomerE@example.com150.0Meta Ads
P0062023-10-03Miami BeachcustomerF@example.com90.0Organic
P0072023-10-04LA StorecustomerG@example.com300.0Google Ads
P0082023-10-04Chicago LoopcustomerH@example.com75.0Meta Ads
P0092023-10-05NYC FlagshipcustomerI@example.com180.0Google Ads
P0102023-10-05Dallas CentralcustomerJ@example.com110.0Organic
P0112023-10-06Miami BeachcustomerK@example.com220.0Meta Ads
P0122023-10-06LA StorecustomerL@example.com60.0Google Ads

Want to see your real in-store sales linked to your ads?

I can connect this system to your live data sources in a few days.

bing@bkydataconsulting.com