Edit the downloaded bulksheet

To upload conversions via a bulk edit, edit the Conversion events report you downloaded as described in the following sections.

Add Floodlight conversions

Add a Floodlight conversion and attribute it to a visit using just the click ID.

Google generates a click ID (gclid) to identify the click that starts a visit. Use click ID to attribute a conversion to a specific visit (and therefore to the ad, keyword, or other item from which the visit started). Depending on what you plan to do with the uploaded conversion, you may need to use the click ID to attribute the conversion instead of using the other methods described on this page.

You can find the click ID from the advertiser's web logs. The new Search Ads 360 adds it to the landing-page URL just before redirecting to the advertiser's site. You can also find click IDs in the "Visit external click ID" or "Conversion external click ID" columns of the Conversion events report.

You can only attribute conversions to click IDs that are less than 90 days old. The Conversion events report doesn't include click IDs older than 90 days. Your web logs may include old click IDs, but they can't be used to attribute conversions.

Add a conversion and attribute it to the click ID

1. Add a new row to the report.
2. Add a column to the report and name it "Click ID".
3. Add information to the following columns:

The following IDs are also optional:

• Conversion Visit ID
• Keyword ID
• Ad ID
• Ad Group ID
• Campaign ID
• Client Account ID

Add a conversion and attribute it to a visit

1. Add a new row to the report.
2. Add information to the following columns:

Duplicate conversions

The new Search Ads 360 doesn't stop you from attributing more than one offline conversion to the same timestamp, click ID, and Floodlight activity.

To prevent duplicate conversions, always specify an "Advertiser Conversion ID". The new Search Ads 360 uses the "Advertiser Conversion ID" to uniquely identify a conversion. If you don't already have conventions for generating an "Advertiser Conversion ID", consider combining the click ID, timestamp, and Floodlight conversion action name into a single string. This combination is likely to be unique within a single advertiser.

Edit an existing conversion

To edit an existing conversion, download the conversion in a Conversion events report and change a value in any of the following columns:

• Conversion revenue (for transaction conversions only).
• Client Account Currency (for transaction conversions only): Changes the currency of the transaction. Specify the currency in the ISO 4217 alphabetic (3-char) format. For example, EUR for Euro.
• Conversion quantity: The number of items in a conversion. Format this number in millis (multiply the number of items by 1000). For example, to specify that a user subscribed to 3 newsletters in a conversion, specify 3000 for Conversion quantity.
• Device segment.

The new Search Ads 360 does not support changing the following:

• The conversion timestamp.
• The conversion type.
• The keyword, ad, or visit that is attributed for the conversion.
• The Floodlight activity or activity name.
• The Conversion ID or Advertiser Conversion ID.

However, you can always remove a conversion and upload a new one with the updated date, type, or Floodlight activity.

Starting from a empty bulksheet

While it's standard practice to edit a conversion by downloading the conversion and updating the data in its columns, you can start from an empty bulksheet. Make sure the bulksheet provides data in the following minimal columns to identify the conversion:

• Advertiser conversion ID
• Conversion timestamp
• Client Account ID
• Conversion type
• One of the following:
  • Click ID if the conversion was attributed to a visit, click, or DSA target
  • Keyword ID if the conversion was attributed to a keyword (or keyword and ad)

You also need the following columns:

• Row type set to conversion
• Action set to edit

Remove an existing conversion

To delete a conversion, you'll only need either the Advertiser conversion ID or the conversion ID. You don't have to provide both. After you have the required ID, download the conversion in a Conversion events report and follow these steps:

1. In the "Action" column, enter "deactivate".
2. In the "Status" column, enter "removed".

Timestamp formats

Use any of the following ISO 8601 formats in a timestamp column:

• To specify time in the new Search Ads 360 sub-manager time zone:
  • yyyyMMdd HH:mm:ss
  • yyyy-MM-dd HH:mm:ss
  • yyyyMMdd HH:mm:ss.SSSSSS
  • yyyy-MM-dd HH:mm:ss.SSSSSS
• If you're uploading a Microsoft Excel sheet, set the column formatting to text.
• To specify time in UTC (also known as "Zulu" time or "Greenwich Mean Time"):
  • yyyy-MM-dd'T'HH:mm:ss'Z'
  • yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
• If you're uploading a Microsoft Excel sheet, set the column formatting to date.

Conversion IDs

Each conversion has two unique IDs:

• "Advertiser Conversion ID": You can use this ID to specify an order number, transaction identifier, or other type of identifier that is meaningful to you. Don't place any PII in this field.
  
  The new Search Ads 360 requires the advertiser conversion ID to be unique for a given date and scope.
  
  If you leave this column empty, the new Search Ads 360 automatically supplies a value when you upload the bulksheet to the new Search Ads 360.

• "Conversion ID": The new Search Ads 360 generates this ID to identify the conversion.
  
  Because this ID is a somewhat randomly generated string not guaranteed to be unique, you may want to supply your own ID in the "Advertiser Conversion ID" column.