Google and Microsoft Ads offline conversions
Set up offline conversion tracking for Google Ads and Microsoft Ads so your ad campaigns can be attributed to actual purchases.
What are offline conversions?
When a customer clicks on a Google or Microsoft ad and then purchases from your online store, Shoporama stores the corresponding click ID(gclid for Google and msclkid for Microsoft). These click IDs can be sent back to Google Ads and Microsoft Ads so you can see which ad clicks actually led to purchases.
Here's how it works
- A customer clicks on your ad. The URL contains a click ID.
- Shoporama stores the click ID in the customer's session.
- When the customer completes a purchase, the click ID is associated with the order.
- Shoporama generates a CSV file with all orders and their click IDs.
- Google/Microsoft automatically retrieves this file and matches conversions with ad clicks.
How to set it up
You can find the settings under Settings → Tracking in Admin.
Google Ads
- Enable Google Ads under Tracking.
- Invite ads@shoporama.dk as administrator in your Google Ads account.
- Create an Import from click conversion point in Google Ads.
- Shoporama will show you a URL, username and password for the automatic data file.
- Set up automatic data retrieval in Google Ads with this information.
Microsoft Ads
- Under Tracking, enable Microsoft Ads.
- Shoporama will show you a URL, username and password.
- Set up automatic import of offline conversions in Microsoft Ads with this information.
Contents of the CSV file
The CSV file contains paid orders from the last 90 days with these fields:
- Click ID - Google Click ID or Microsoft Click ID.
- Conversion name - "Purchase".
- Conversion time - the time of the order.
- Conversion value - the order amount.
- Currency - the currency of the shop.
Security of the files
The CSV files are protected with HTTP Basic Authentication. Username and password are automatically generated and displayed in the tracking settings. Only requests with correct login details can access the files.
REST API
The click IDs(gclid and msclkid) are also available via the REST API on the order endpoint if you need to integrate with other systems.