About uploading conversions from a bulksheet

Here’s the general outline for using a bulksheet to upload conversions:

1. If you plan to attribute conversions to a Google click ID, enable the conversion API service in Search Ads 360.
2. Download a Conversions and Visits report, which contains data about existing conversions. (You'll use data from the existing conversions to create new conversions.)
3. Edit the downloaded bulksheet to do any of the following:
   • Add a conversion that is attributed to a click ID or visit ID: This allows you to account for returns, fraud, and so forth.
   • Add a conversion that is attributed to an ad, keyword, or product group: This is great for call tracking or other forms of offline conversions.
   • Change information about an existing conversion: For example, you may want to change a conversion for discounts applied after an online purchase, returns with a restocking fee, or credits.
4. Upload the bulksheet back into Search Ads 360.
5. If you're uploading conversions that occur offline, periodically upload an availability timestamp.

Note the following:

• Offline conversions for social and auto track engines can only be uploaded from the Search Ads 360 Conversions API.

• When you use a bulksheet to upload conversions, each upload should contain fewer than 100,000 rows. Search Ads 360 might not be able to process a conversions bulksheet with more than 100,000 rows.

• Regarding uploading historical conversions:
  • Conversions attributed to keywords, ads, product groups, or visits are forced into the last-click attribution model no matter when they're uploaded, whereas those attributed to Google click IDs (GCLIDs) are forced into this attribution model after 60 days.
  • You can't upload conversions attributed to GCLIDs if either of the following is true:
    • The conversion timestamp is older than 90 days.
    • The GCLID is older than 90 days.
  • You can't edit conversions that are older than 90 days. 
  • You can't upload conversions where the conversion timestamp is older than 2 years.
  • You can't upload conversion timestamps older than 14 days for the purposes of auction-time bidding.
• Instead of using bulksheets to manually upload conversion data, you can use the Search Ads 360 API to upload conversion data. Or if you use a supported call-tracking vendor, you can use their integration to automatically upload conversions. Learn more about uploading offline conversions.

Uploading custom Floodlight variables from bulksheets not supported

You cannot specify custom Floodlight variables for conversions that you upload from a bulksheet. To upload custom data for offline conversions, use the Search Ads 360 conversion API.