About uploading conversions from a bulksheet

You can add or update conversions with a timestamp as far back as January 1, 2013.

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

1. Download a Conversions and Visits report, which contains data about existing conversions. (You'll use data from the existing conversions to create new conversions.)
2. Edit the downloaded bulksheet to do any of the following:
   • Add a conversion that is attributed to a visit: This allows you to account for returns, fraud, and so forth. Note that, for conversions occurring on an engine account that is not tracked by DoubleClick Search clickservers, the account won't have any visits. Therefore, the conversion can't be visit-attributed.
   • 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.
3. Upload the bulksheet back into DS.
4. If you're uploading conversions that occur offline, periodically upload an availability timestamp.