Your offline sales, back in Google Ads. So the account sees revenue, not just form fills.
Upload a CRM export or the weekly sheet of sales. Oppy checks each row, says how many can be matched and why the rest cannot, and sends them once you approve.
- CSV or sheet
- Emails and phones hashed
- Sent after approval
What the file needs.
A way to match
A click id, or the email or phone of the person. For a call, the calling number and when the call started.
When the sale happened
The date and time of the sale, and its value if you have it. Google takes a sale up to 90 days after the click, or 63 days when it is matched by email or phone.
Consent
The people's consent to their data being used this way, as Google's rules require.
What Oppy checks before sending.
Columns are found by their names, in English or French, never by their position. Phone numbers are written in international form. Dates are read in the account's own time zone unless the cell says otherwise.
Rows Google would drop anyway are set aside before anything is sent, such as a sale with no way to match it, no date, or a date too old. You see why each one was set aside.
You see how many rows can be matched and why the others cannot. Then, after approval, the sales go to Google through its Data Manager API, which is where Google takes them now. Emails and phones are hashed with SHA-256 before they leave.
The sales arrive in their own conversion action, set as secondary. You see them in the account's reports first, and bidding starts to use them once you make that action primary.
How to connect it.
Give the Data Manager permission
Someone with access to the Google Ads account gives Optizads Google's Data Manager permission, from the account's Integrations.
Upload the file
A CSV or spreadsheet from your CRM, or the sheet you already keep. A Google Sheet is read from its share link, which anyone with the link can open: for a file with emails or phones, upload the export instead.
Read the check and approve
See what will match, fix what will not if you can, and approve the send.
What it does not do.
It does not connect to a CRM directly. You export the sales and upload them.
A sale that carries its order id is never sent twice.
Questions about offline conversions.
Anything else? Ask Oppy in the product, or write to the team.
Why import offline sales into Google Ads?
When the real sale happens after the click, on the phone or in a shop, Google Ads only sees the lead. Sending the sale shows which clicks became customers, and once the action is primary, bidding aims at them.
How far back can I import sales?
Up to 90 days after the click for a sale matched by its click id, and 63 days for one matched by email or phone. Older rows are set aside before sending.
Is customer data sent in clear?
No. Emails and phone numbers are hashed with SHA-256 before they are sent to Google.
Put Oppy to work on your account.
Create your account and connect Google Ads. Your first audit arrives in minutes, your first tasks soon after. 14 days free, no card.
- Every change logged in History
- Hosted in the EU
- Any account size