AI Blocks › Track your numbers
Multi-touch credit calculator
Give it your touches and sales. Get credit split by first, last, linear or decay rules, plus cost per sale.
Multi-touch credit calculator is a free AI skill for the job "Track your numbers". Give the instructions to an AI assistant that supports the required files and tools, then review its output.
Free · No account · MIT licence · Made by wizard7558 · Level: expert · Thinking: high
Made by wizard7558. See the original on GitHub; we copied it as it is, with its licence.
What it does
Credit for each sale split across the ads and visits that came before it, using first-touch, last-touch, linear, position-based or time-decay rules. Then you see cost per sale by channel. The skill writes BigQuery SQL. You declare the keys that link touches to buyers, the currency, time zone, date range and how far back to look. One query builds a ledger that shows every conversion under all five models. It also reports coverage, so sales with no matching touch are not hidden. A second step adds spend and works out cost per sale. It states that these are rules for splitting credit, not proof of what caused the sale.
You give it
- Touch history, such as ad clicks and visits
- Sales or conversion records
- Ad spend by channel
- Time zone, date range and lookback days
- A BigQuery project
You get
- A credit ledger for five models
- A coverage report
- Cost per sale by channel
- A note on what the numbers can and cannot say
Use it when
- Last-click gives all credit to one channel and you doubt it.
- You want to compare five credit rules on the same data.
- You need cost per sale by channel for a budget meeting.
- Some sales have no tracked touch and you need to see how many.
How to use it
- Add it to your AI once: download it and add the folder to Claude, ChatGPT or Codex as a skill.
- Ask for the job in your own words. Your AI opens the skill when it fits.
- It works best when your AI can run SQL on your own BigQuery data.