Edit the downloaded bulksheet

If you've enabled the conversion API service in Search Ads 360, Google generates a click ID (gclid) to identify the click that starts a visit. You can use this 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, since 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 Conversions and Visits report.

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

To 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:

   In this column...	Specify...
   Row type	conversion
   Action	create
   Status	active
   Click ID	The click ID you copied from the advertiser's web logs, the Visit external click ID, or the Conversion external click ID column of the Conversions and Visits report.
   Advertiser Conversion ID	Optionally specify a unique ID for the conversion, such as an order number, transaction identifier, or other type of identifier that is meaningful to you. If you leave this column empty, Search Ads 360 automatically supplies a value when you upload the bulksheet. Learn more.
   Conversion revenue	If you’re adding a transaction conversion, enter an amount. If you’re adding an action conversion, leave this column empty.
   Conversion quantity	Optionally specify 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.
   Conversion timestamp	Specify the time of the conversion. You can specify time in the Search Ads 360 advertiser time zone (listed in Advertiser settings) or in UTC. See timestamp format below.
   Floodlight activity ID	This column specifies the Floodlight activity that recorded the conversion. Copy the Floodlight activity ID from an existing conversion and paste it into the new row. If the Floodlight activity isn’t in the report you downloaded, you can specify the Floodlight activity name in the Floodlight activity name column and leave the Floodlight activity ID column empty.
   Device segment	Optionally specify the type of device on which the conversion occurred. Valid values are: Desktop Mobile Tablet Other
   Attribution type	visit
   Conversion type	action or transaction
   Conversion referrer	Optionally specify the URL of the page the customer visited immediately before the conversion page.
   Engine account currency	If you’re adding a transaction conversion that uses a currency other than US dollars, specify the currency code here or include the Account ID column and specify the ID of the engine account that generated the click. If you specify neither an Engine account currency nor an Account ID, Search Ads 360 assumes the currency of a transaction is US dollars. If your site uses something other than US dollars, specify the currency code in this column.

Note that Agency ID, Account ID are optional because Search Ads 360 can use the click ID to find the agency, and account. For the same reason, the following IDs are also optional:
Conversion Visit ID
Keyword ID
Ad ID
Ad Group ID
Campaign ID

Advertiser ID is optional unless you specify a conversion timestamp. Then, an advertiser ID is required.

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

   In this column...	Specify...
   Row type	conversion
   Action	create
   Status	active
   Keyword ID Ad ID Ad Group ID Campaign ID Account ID Advertiser ID	Copy these values from an existing row that describes the visit and paste into the new row.
   Advertiser Conversion ID	Optionally specify a unique ID for the conversion, such as an order number, transaction identifier, or other type of identifier that is meaningful to you. If you leave this column empty, Search Ads 360 automatically supplies a value when you upload the bulksheet. Learn more.
   Conversion revenue	If you’re adding a transaction conversion, enter an amount. If you’re adding an action conversion, leave this column empty.
   Conversion quantity	Optionally specify 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.
   Conversion Visit ID	Copy the Conversion Visit ID from an existing row that describes the visit and paste it into the new row.
   Conversion timestamp	Specify the time of the conversion. You can specify time in the Search Ads 360 advertiser time zone (listed in Advertiser settings) or in UTC. See timestamp format below.
   Conversion visit timestamp	Copy the Conversion visit timestamp from an existing row that describes the visit and paste it into the new row. If you specify a conversion visit timestamp, you're required to also specify Advertiser ID and Account ID. Otherwise, the time is converted to GMT.
   Floodlight activity ID	This column specifies the Floodlight activity that recorded the conversion. Copy the Floodlight activity ID from an existing conversion and paste it into the new row. If the Floodlight activity isn’t in the report you downloaded, you can specify the Floodlight activity name in the Floodlight activity name column and leave the Floodlight activity ID column empty.
   Device segment	Optionally specify the type of device on which the conversion occurred. Valid values are: Desktop Mobile Tablet Other
   Attribution type	visit
   Conversion type	action or transaction
   Conversion referrer	Optionally specify the URL of the page the customer visited immediately before the conversion page.

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

   In this column...	Specify...
   Row type	conversion
   Action	create
   Status	active
   Keyword ID	Specify the ID of the keyword that you want to attribute for the conversion. You can optionally specify the ID of the ad group, campaign, account, and advertiser that contains the keyword in these columns: Ad Group ID, Campaign ID, Account ID, and Advertiser ID.
   Advertiser Conversion ID	Optionally specify a unique ID for the conversion, such as an order number, transaction identifier, or other type of identifier that is meaningful to you. If you leave this column empty, Search Ads 360 automatically supplies a value when you upload the bulksheet. Learn more.
   Conversion revenue	If you’re adding a transaction conversion, enter an amount. If you’re adding an action conversion, leave this column empty.
   Conversion quantity	Optionally specify 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.
   Conversion timestamp	Specify the time of the conversion. You can specify time in the Search Ads 360 advertiser time zone (listed in Advertiser settings) or in UTC. See timestamp format below.
   Floodlight activity ID	This column specifies the Floodlight activity that recorded the conversion. Copy the appropriate Floodlight activity ID from an existing conversion and paste it into the new row. Use the Floodlight activity name column to help you identify the activity. If the Floodlight activity isn’t in the report you downloaded, you can specify the Floodlight activity name in the Floodlight activity name column and leave the Floodlight activity ID column empty.
   Device segment	Optionally specify the type of device on which the conversion occurred. Valid values are: Desktop Mobile Tablet Other
   Attribution type	keyword/ad
   Conversion type	action or transaction
   Conversion referrer	Optionally specify the URL of the page the customer visited immediately before the conversion page.
   Engine account currency	If you’re adding a transaction conversion that uses a currency other than US dollars, specify the currency code here or include the Account ID column and specify the ID of the engine account that generated the click. If you specify neither an Engine account currency nor an Account ID, Search Ads 360 assumes the currency of a transaction is US dollars. If your site uses something other than US dollars, specify the currency code in this column.

To attribute conversions to specific products coming from your Merchant Center inventory feed and being advertised in a Shopping campaign:

1. Make sure the Conversions and Visits report you downloaded contains products from a Shopping campaign.
2. Add a new row to the report.
3. Add information to the following columns:

   In this column...	Specify...
   Row type	conversion
   Action	create
   Status	active
   Account ID Advertiser ID	Copy these values from an existing row and paste into the new row.
   Advertiser Conversion ID	Optionally specify a unique ID for the conversion, such as an order number, transaction identifier, or other type of identifier that is meaningful to you. If you leave this column empty, Search Ads 360 automatically supplies a value when you upload the bulksheet. Learn more.
   Conversion revenue	If you’re adding a transaction conversion, enter an amount. If you’re adding an action conversion, leave this column empty.
   Conversion quantity	Optionally specify 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.
   Conversion timestamp	Specify the time of the conversion. You can specify time in the Search Ads 360 advertiser time zone (listed in Advertiser settings) or in UTC. See timestamp format below.
   Floodlight activity ID	The Floodlight activity that recorded the conversion. Copy the Floodlight activity ID from an existing conversion and paste it into the new row. If the Floodlight activity isn’t in the report you downloaded, you can specify the Floodlight activity name in the Floodlight activity name column and leave the Floodlight activity ID column empty.
   Attribution type	Product group
   Conversion type	action or transaction
   Conversion referrer	Optionally specify the URL of the page the customer visited immediately before the conversion page.
   Product group ID	The ID of the product group that you want to attribute for the conversion. Search Ads 360 assigns this ID to a product group when the group is created.
   Product ID	The ID for the product. You specify this ID in your inventory feed. If a product doesn't appear in the downloaded bulksheet, there may not be any conversion data for the product during the report's time period. You can either adjust the report's time period and download another bulksheet or look up the product ID from the Search Ads 360 UI by clicking Inventory management in the left navigation pane and looking in the Product ID column on the Inventory items tab.
   Inventory Account ID	The ID of the inventory feed to which the product belongs. Search Ads 360 assigns this ID when you link a product feed to Search Ads 360. If your Merchant Center account is a multi-client account, specify the ID of the sub-account that contains the product. You can find this ID from the Search Ads 360 UI by clicking Inventory management in the left navigation pane and looking in the ID column on the Inventory accounts tab.
   Product Country	The country that has been defined for the Merchant Center feed that contains data about the product. Specify an ISO 3166 country code.
   Product Language	The language that has been defined for the Merchant Center feed that contains data about the product. Specify an ISO 639 language code.
   Channel	Set to Online for online Shopping ads and Local for Local Inventory Ads.
   Store Id	For Local Inventory Ads, specify the store for which the product was advertised. This should match the store IDs used in your inventory feed.

For example, if you upload a bulksheet with the following duplicate rows, Search Ads 360 will attribute two conversions to the "Call center" Floodlight activity:

However, if you upload a bulksheet with the following duplicate rows, Search Ads 360 will attribute one conversion to the "Call center" Floodlight activity because the advertiser IDs are the same: