Overview of updating or creating tags to report purchase details

To track online sales and revenue for specific products in your inventory feed, you’ll need to: Set up a tag on your site that records sales (transactions) for a Floodlight activity. You can use the google tag with a Floodlight event snippet , a Floodlight tag , or Google Tag Manager for purchase detail reporting. If you already have a tag for recording Floodlight transactions, you can use an existing tag. On the page that contains the Floodlight tag or event snippet, add a data structure called the purchase details variable . Then populate the variable with the ID, quantity, and price of each item purchased. For example, write code that interacts with the shopping cart on your site to populate the purchase details variable and store it in a custom JavaScript variable. If you use the Google tag or Google Tag Manager on your site, you can store the purchase details variable in the data layer. Pass the purchase details to the Floodlight tag or event snippet. If you use Google Tag Manager, you can retrieve the data from the data layer. Otherwise, you'll need to add specifically formatted data to the Floodlight tag or event snippet. (Recommended) Use Google Tag Assistant to validate your tags .

Create a Floodlight tag or event snippet to track transactions

If you aren’t already using a Floodlight activity for reporting on transactions, or if you want to keep product reporting separate from your other Floodlight activities, create a new Floodlight activity group and Floodlight activity. These steps describe how to create a new Floodlight activity group and Floodlight activity from Search Ads 360. You can also create these items in Campaign Manager 360 ; just make sure that the tag you create in Campaign Manager 360 is a Floodlight sales activity . In Search Ads 360, create a Floodlight activity group and specify Transaction for the group’s conversion type. Create a Floodlight activity in the new transaction group. Search Ads 360 generates a tag to record Floodlight transactions. Copy the tag and send it to your web team. Your web team needs to paste the tag onto your site or add it to your Google Tag Manager container. The exact steps depends on how you're implementing tags on your site. Learn more about Options for creating and implementing Floodlight activities and tags .

Add the purchase-details variable to your Floodlight tags #sa-hc-dei

After your web developer writes code to populate the purchase-details variable, you’ll need to update your Floodlight tags or event snippets so they can pass the data to Search Ads 360. If you use Google Tag Manager, you'll need to update your container to use the data you pushed to the ecommerce.purchase.products array or create macros that pass the data to your Floodlight tag. Manually update your tags If you're passing purchase details directly to a Floodlight tag, most likely, your web developer has made the purchase-details variable available to the page in a JavaScript object or as a custom variable in the DOM. For example, let’s say your web developer makes the purchase details available in a JavaScript object named floodlightSpec . You’d need to update your Floodlight event snippet to look like this:  <script> gtag('event', 'purchase', { 'allow_custom_scripts': true, 'send_to': 'DC-1234567/group1/thank123+transactions', 'transaction_id': floodlightSpec.sessionID, 'value': floodlightSpec.revenue, 'items': [ { 'id': floodlightSpec.item[0].id, 'price': floodlightSpec.item[0].price, 'quantity': floodlightSpec.item[0].number }, { 'id': floodlightSpec.item[1].id, 'price': floodlightSpec.item[1].price, 'quantity': floodlightSpec.item[1].number } ], 'country': floodlightSpec.country, 'language': floodlightSpec.lang } ); </script> <noscript> <img src="https://ad.doubleclick.net/ddm/activity/src=1234567;type=group1;cat=thank123; qty=1;cost=floodlightSpec.revenue;dc_lat=;dc_rdid=; tag_for_child_directed_treatment=;tfua=;npa=; ord= floodlightSpec.sessionID ;prd=i1:floodlightSpec.item[0].id|p1:floodlightSpec.item[0].price|q1:floodlightSpec.item[0].number|i2:floodlightSpec.item[1].id|p2:floodlightSpec.item[1].price|q2:floodlightSpec.item[1].number|c:floodlightSpec.country|l:floodlightSpec.lang?" width="1" height="1" alt=""> </noscript>  Note : Event snippets generated by Search Ads 360 include an optional <noscript> tag that contains a Floodlight image tag. This tag is used to report conversions in browsers that don't support JavaScript. If your site supports browsers that haven't enabled JavaScript, it's recommended that you update the Floodlight image tag to include purchase details as shown in the example. Use Google Tag Manager to update your tags Google Tag Manager helps you maintain tags on your site. Instead of adding and updating tags directly on your site, you add and update them in Google Tag Manager. Google Tag Manager then outputs properly formatted tags on your site as needed. Learn more about Google Tag Manager . When you need to pass dynamically generated data—such as purchase details—to tags managed by Google Tag Manager, your web developer can do either of the following: Use data from the data layer If your web developer has made the purchase-details variable available in the data layer, follow these steps to pass the data to your Floodlight tag: Use the dataLayer.push method to make the data available in Google Tag Manager's data layer. In Google Tag Manager, navigate to the container for your site. Click the Tags tab and click the Floodlight transaction tag that reports sales. Click the Pencil icon to make changes to the tag. Under Product Reporting, check the Provide product-level sales data check box. From the Data Source list, select Data Layer . Google Tag Manager will automatically use the data pushed to the data layer in the ecommerce.purchase.products array. Click Save . Preview and publish your changes . Use a variable to access other data If your web developer has made the purchase-details variable available somewhere other than the data layer, follow these steps to use a Google tag manager variable (formerly Macro) to pass the data on. Output the data elsewhere (such as in a DOM variable). In Google Tag Manager, navigate to the container for your site. Click the Tags tab and click the Floodlight transaction tag that reports sales. Click the Pencil icon to make changes to the tag. Under Product Reporting, check the Provide product-level sales data check box. From the Data Source list, select one of the following: JavaScript variable if the data is formatted as a JavaScript variable . Floodlight formatted value if the data is formatted as a String . Click the Add variable icon next to the Product Data Field . Click the New variable button in the upper right. Click the Pencil icon in the variable configuration card and do the following: Choose the appropriate variable type. For example, if the data is available in a JavaScript variable, select JavaScript Variable . In the next field, enter the name of the object that contains the data. For example, here's a page that outputs the String as a global JavaScript variable. <script> window.salesData="i1:sku-12345|p1:100.0|q1:1|i2:sku-67890|p2:20.0|q2:2" </script> Name the variable either by editing the namespace at the top, or by clicking save and editing the name in the following window. After doing this, you should see the name enclosed in double brackets in the Product Data Field. Click Save again to update the draft version of your tag. Preview and publish your changes .

Validate your tags for reporting purchase details

After you add or update tags to support purchase-detail reports, you can use Google Tag Assistant to validate the tags. To use Google Tag Assistant: In a Google Chrome browser, visit the Chrome Web Store and install Google Tag Assistant . (Learn more about using Google Tag Assistant .) Tag Assistant will: Check the syntax of the purchase-details variable. For example, if you accidently define two IDs for a single product, or specify the wrong data type for a field, Tag Assistant will display an error. Provide a preview of the data that's collected by the tag. Perform checks on other variables within each tag

Average unit price column

Displays the average price reported for sales of a product (using the price reported on each product). Only available after you link your Merchant Center account with Search Ads 360 . Calculated as: Revenue from units sold / Units sold View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Cross-sell average unit price column

Displays average price reported for sales of a product when it sold as a result of advertising a different product. Only available after you link your Merchant Center account with Search Ads 360 . Calculated as Revenue from the product when it sold as a cross sell / Cross-sell units sold View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Cross-sell cost of goods sold column

Displays the total cost of selling a product when it sold as a result of advertising a different product. Only available after you enable your inventory feed to report on profit . Calculated as: Sum of cost_of_goods_sold for a given SKU over every transaction attributed to clicks on a different SKU View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Cross-sell gross profit from units sold column

Displays the total revenue generated from sales of a product as a result of advertising a different product. Only available after you enable your inventory feed to report on profit . Calculated as: QUANTITY field * PRICE field - cost_of_goods_sold for a given SKU over every transaction attributed to clicks on a different SKU View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Cross-sell gross profit margin column

Displays the gross profit margin for a specific product when sold as a result of advertising a different product. Only available after you enable your inventory feed to report on profit . Calculated as Cross-sell gross profit from units sold / total revenue View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Cross-sell revenue from units sold column

Displays the total revenue generated from cross sales (revenue generated as a result of advertising a different product). Only available after you link your Merchant Center account with Search Ads 360 . Calculated as: Revenue from units sold - Lead revenue from units sold View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Cross-sell units sold column

Displays the number of units sold as the result of cross-selling. (The number of units sold as a result of advertising a different product.) Only available after you link your Merchant Center account with Search Ads 360 . Calculated as: Units sold - Lead units sold View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Gross profit from units sold column

Displays the gross profit for a given SKU over every transaction in which it appears. Only available after you enable your inventory feed to report on profit . Calculated as: QUANTITY field * PRICE field - cost_of_goods_sold from the inventory feed View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Gross profit margin column

Displays the gross profit margin for a specific product. Only available after you enable your inventory feed to report on profit . Calculated as Gross profit from units sold / total revenue View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Lead average unit price column

Displays the average price reported for sales of a product when it sold as a result of advertising the product. Only available after you link your Merchant Center account with Search Ads 360 . Calculated as Revenue from this product when it sold as a result of advertising the product / Lead units sold View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Lead cost of goods sold column

Displays the total cost of selling a product when sold as a result of advertising the product. Only available after you enable your inventory feed to report on profit . Calculated as: Sum of cost_of_goods_sold for a given SKU over every transaction attributed to clicks on the same SKU View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Lead gross profit from units sold column

Displays the total revenue generated from sales of a product as a result of advertising the product. Only available after you enable your inventory feed to report on profit . Calculated as: QUANTITY field * PRICE field - cost_of_goods_sold for a given SKU over every transaction attributed to clicks on the same SKU View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Lead gross profit margin column

Displays the gross profit margin for a specific product as a direct result of advertising the product. Only available after you enable your inventory feed to report on profit . Calculated as Lead gross profit from units sold / total revenue View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Lead revenue from units sold column

Displays the total revenue generated from a product as a result of advertising the product. Only available after you link your Merchant Center account with Search Ads 360 . Calculated as: Sum of the QUANTITY field * PRICE field for a given SKU over every transaction attributed to clicks on the same SKU View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Lead units sold column

Displays the number of units sold as a result of advertising the product. Only available after you link your Merchant Center account with Search Ads 360 . Calculated as: Sum of the QUANTITY field for a given SKU over every transaction attributed to clicks on the same SKU View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Net profit from units sold column

Displays the net profit for a given SKU over every transaction in which it appears. Only available after you enable your inventory feed to report on profit . Calculated as: Gross profit from units sold - advertising cost View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Net profit margin column

Displays the net profit margin for a specific product. Only available after you enable your inventory feed to report on profit . Calculated as: Net profit from units sold / revenue from units sold View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Revenue from units sold column

Displays the total revenue generated from a product (using the price reported on each product). Only available after you link your Merchant Center account with Search Ads 360 . Calculated as: Sum of the QUANTITY field * PRICE field for all SKUs over every transaction attributed to clicks on the same SKU View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Displays the total number of units sold for a particular product in your inventory feed. Only available after you link your Merchant Center account with Search Ads 360 . Calculated as: Sum of the QUANTITY field for all SKUs over every transaction attributed to clicks on the same SKU View this column You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360 . Navigate to an advertiser or lower scope. Click the Dimension ▼ tab and select a dimension. For example, to view product performance organized by brand, select Brand sold . Click the Segment button and select a Products sold segment. For example, to view metrics for individual product IDs, select the Product ID segment. If the column doesn't automatically appear in the reporting table, do the following: Above the performance summary graph, click the Columns button. Under Available columns , navigate to Products and select the column. Click Apply . You can use this and other purchase detail columns to automate campaign management . For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more .

Report on purchase details - Search Ads 360 Help

Update or create tags to report purchase details

Overview
Create a Floodlight tag or event snippet to track transactions
Generate content for the purchase-details variable
Add the purchase-details variable to your Floodlight tags or event snippets
Validate your tags for reporting purchase details

Purchase detail columns

Average unit price column
Cross-sell average unit price column
Cross-sell cost of goods sold column
Cross-sell gross profit from units sold column
Cross-sell gross profit margin column
Cross-sell revenue from units sold column
Cross-sell units sold column
Gross profit from units sold column
Gross profit margin column
Lead average unit price column
Lead cost of goods sold column
Lead gross profit from units sold column
Lead gross profit margin column
Lead revenue from units sold column
Lead units sold column
Net profit from units sold column
Net profit margin column
Revenue from units sold column
Units sold column

Update or create tags to report purchase details

Overview
To track online sales and revenue for specific products in your inventory feed, you’ll need to:
1. Set up a tag on your site that records sales (transactions) for a Floodlight activity.
  You can use the google tag with a Floodlight event snippet, a Floodlight tag, or Google Tag Manager for purchase detail reporting.
  
  If you already have a tag for recording Floodlight transactions, you can use an existing tag.
2. On the page that contains the Floodlight tag or event snippet, add a data structure called the purchase details variable. Then populate the variable with the ID, quantity, and price of each item purchased.
  For example, write code that interacts with the shopping cart on your site to populate the purchase details variable and store it in a custom JavaScript variable.
  
  If you use the Google tag or Google Tag Manager on your site, you can store the purchase details variable in the data layer.
3. Pass the purchase details to the Floodlight tag or event snippet.
  If you use Google Tag Manager, you can retrieve the data from the data layer.
  
  Otherwise, you'll need to add specifically formatted data to the Floodlight tag or event snippet.
4. (Recommended) Use Google Tag Assistant to validate your tags.
Create a Floodlight tag or event snippet to track transactions
If you aren’t already using a Floodlight activity for reporting on transactions, or if you want to keep product reporting separate from your other Floodlight activities, create a new Floodlight activity group and Floodlight activity.

These steps describe how to create a new Floodlight activity group and Floodlight activity from Search Ads 360. You can also create these items in Campaign Manager 360; just make sure that the tag you create in Campaign Manager 360 is a Floodlight sales activity.
1. In Search Ads 360, create a Floodlight activity group and specify Transaction for the group’s conversion type.
2. Create a Floodlight activity in the new transaction group.
  Search Ads 360 generates a tag to record Floodlight transactions.
3. Copy the tag and send it to your web team.
4. Your web team needs to paste the tag onto your site or add it to your Google Tag Manager container.
  The exact steps depends on how you're implementing tags on your site. Learn more about Options for creating and implementing Floodlight activities and tags.

Generate content for the purchase-details variable

The purchase-details variable provides information about the products sold in a given transaction. You can add the variable to a Floodlight event snippet, Floodlight tag, the Google Tag Manager data layer, or a Google Tag Manager macro.

Depending on how you add the variable, use one of the following formats:

If you're using the Google tag, format the purchase-details variable as a JSON object directly in the Floodlight event snippet.
If you're using a Floodlight Iframe or image tag, or passing the data to Google Tag Manager as a macro, format the purchase-details variable as a String divided into a set of fields.
If you're pushing the data to Google Tag Manager's data layer, format the variable as a JSON object with purchase-detail fields.

Requirements for the JSON format in a Floodlight event snippet

If you use the Google tag, purchase details should be specified in the event snippet as a JSON items array, plus country and language fields. Each item in the array contains the following fields:

id
price
quantity

For example:

<script> gtag('event', 'purchase', { 'allow_custom_scripts': true, 'send_to': 'DC-1234567/group1/thank123+transactions', 'transaction_id': '012345', 'value': 129.97, 'items': [ { 'id': '123456755559', 'price': '19.99', 'quantity': 1 }, { 'id': '123456788889', 'price': '54.00', 'quantity': 2 } ], 'country': 'us', 'language': 'en' } ); </script> <noscript> <img src="https://ad.doubleclick.net/ddm/activity/src=1234567;type=group1;cat=thank123; qty=1;cost=129.97;dc_lat=;dc_rdid=;tag_for_child_directed_treatment=;tfua=;npa=; ord=012345;prd=i1:123456755559|p1:19.99|q1:1|i2:123456788889|p2:54.0|q2:2|c:us|l:en?" width="1" height="1" alt=""> </noscript>

Note: Event snippets generated by Search Ads 360 include an optional <noscript> tag that contains a Floodlight image tag. This tag is used to report conversions in browsers that don't support JavaScript. If your site supports browsers that haven't enabled JavaScript, it's recommended that you update the Floodlight image tag to include purchase details as shown in the example.

Requirements for the JSON format in the data layer

If you use Google Tag Manager, the purchase-detail fields should be specified as elements in a JSON ecommerce.purchase.products array:

'ecommerce':{ 'purchase':{ 'products': [{ 'id': 'String', 'price': 'Floating point', 'quantity': Integer, 'country': 'String', // Optional 'language': 'String', // Optional 'accountId': 'String' // Optional }, { … // Each SKU (product) in the transaction // is in its own array item. }] } }'

Note that the field names for this JSON object are different from the JSON object you use if you're adding the purchase-details variable to a Floodlight event snippet.

When you push purchase details to the data layer, you'll actually be storing the data in the same object that Google Analytics can use to report the products that have been purchased on your site. That is, if you're using both Search Ads 360 and Google Analytics to report purchase details, your web developer can use the same object to store the data for both products.

Requirements for the String format

In the String format, each purchase-detail field should be specified as a key-value pair in the following format:
[field ID][index]:[value]

[field ID] identifies the type of value being reported.
[index] indicates the item for which the value is being reported.
[value] provides information about the sale of the product.

Separate each field with a | (pipe). For example,
i1:123456755559|p1:19.99|q1:1|i2:123456788889|p2:54.0|q2:2

Purchase-detail fields

Field	ID in String format	Type	Required	Description
`ID`	`i`	String	Yes	The ID of the product that has been sold. The ID must match the item id from Google Merchant Center.
`PRICE`	`p`	Floating point	Yes	Price per unit of the product that has been sold. Do not include a currency symbol.
`QUANTITY`	`q`	Integer	Yes	The quantity of units of the product that has been sold.
`COUNTRY`	`c`	String (ISO 3166 country code)	No	The country registered for the Merchant Center feed that contains data about the product. This field is needed only when item IDs are not unique across multiple Merchant Center feeds. Specify the country only once for each product (it is not a repeated field). If the field isn’t specified, Search Ads 360 chooses a Merchant Center feed that contains the product ID and uses that feed's attributes for the products sold dimensions.
`LANGUAGE`	`l`	String (ISO 639 language code)	No	The language registered for the Merchant Center feed that contains data about the product. This field is needed only when item IDs are not unique across multiple Merchant Center feeds. If the field isn’t specified, Search Ads 360 chooses a Merchant Center feed that contains the product ID and uses that feed's attributes for the products sold dimensions.

Special characters and URL encoding

The : (colon) and | (pipe) are used as field delimiters in the String format. Search Ads 360 cannot accept data that includes these characters as values in a field, even if you're using one of the JSON formats.

As with all Floodlight data, the following characters also are not accepted:

;, <, >, ?

Example of a purchase with multiple products

Suppose a transaction includes the following items:

Item 1
- Name: m-dress-orange-xl
- UPC: 123456755559
- Price per item: $19.99
- Quantity: 1
Item 2
- Name: m-polo-green-l
- UPC: 123456788889
- Price per item: $54
- Quantity: 2

The purchase-details variable in an event snippet would contain the following fields:

'items': [ { 'id': '123456755559', 'price': '19.99', 'quantity': 1 }, { 'id': '123456788889', 'price': '54.00', 'quantity': 2 } ]

Here's how the purchase details variable appears in a Floodlight iframe tag:
i1:123456755559|p1:19.99|q1:1|i2:123456788889|p2:54.0|q2:2

In addition to the purchase-details variable, the Floodlight tag or event snippet would also specify the following data:

ID of the Floodlight activity group
ID of the Floodlight activity
Transaction ID (Order ID)
Total value of the transaction: $129.97 = (1*$19.99 + 2*$54)
Quantity: 3 (you can define the exact meaning of this field. You might consider using it to report on the total cart size.)
Any other custom Floodlight variables

The final google tag with the event snippet would look like this:
  <script async src="https://www.googletagmanager.com/gtag/js?id=DC-1234567"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments)}; gtag('js', new Date()); gtag('config', 'DC-1234567'); </script> 

Here's an example of Floodlight Iframe tag with a purchase details variable:
<iframe src="https://ad.doubleclick.net/activity;src=12345;type=group-;cat=activity;ord=12345;qty=3;cost=140;prd=i1:123456755559 |p1:19.99|q1:1|i2:123456788889|p2:54.0|q2:2?" width="1" height="1" frameborder="0" style="display:none"></iframe>

Example of the country and language codes

You can use Merchant Center to submit your products in multiple feeds, each targeted to a specific language and country. For example, if you sell the same group of products in the US and Canada, you can set up one feed with prices and descriptions for the US, another feed with Canadian prices and descriptions in French, and a third feed with Canadian prices and descriptions in English.

When you submit feeds with the same product IDs but different target languages or countries, you'll need to include the language and country code in the purchase-details variable. For example, this items array and country and language fields in the event snippet record a purchase from the feed targeted to French Canadians:

'items': [ { 'id': '123456788889', 'price': '19.99', 'quantity': 1 }, { 'id': '123456755559', 'price': '54.00', 'quantity': 2 } ], 'country': 'ca', 'language': 'fr'

Just make sure to use the ISO two digit country and language codes.

Add the purchase-details variable to your Floodlight tags or event snippets
After your web developer writes code to populate the purchase-details variable, you’ll need to update your Floodlight tags or event snippets so they can pass the data to Search Ads 360.

If you use Google Tag Manager, you'll need to update your container to use the data you pushed to the ecommerce.purchase.products array or create macros that pass the data to your Floodlight tag.

Manually update your tags

If you're passing purchase details directly to a Floodlight tag, most likely, your web developer has made the purchase-details variable available to the page in a JavaScript object or as a custom variable in the DOM.

For example, let’s say your web developer makes the purchase details available in a JavaScript object named floodlightSpec. You’d need to update your Floodlight event snippet to look like this:

 <script> gtag('event', 'purchase', { 'allow_custom_scripts': true, 'send_to': 'DC-1234567/group1/thank123+transactions', 'transaction_id': floodlightSpec.sessionID, 'value': floodlightSpec.revenue, 'items': [ { 'id': floodlightSpec.item[0].id, 'price': floodlightSpec.item[0].price, 'quantity': floodlightSpec.item[0].number }, { 'id': floodlightSpec.item[1].id, 'price': floodlightSpec.item[1].price, 'quantity': floodlightSpec.item[1].number } ], 'country': floodlightSpec.country, 'language': floodlightSpec.lang
} ); </script>
<noscript> <img src="https://ad.doubleclick.net/ddm/activity/src=1234567;type=group1;cat=thank123; qty=1;cost=floodlightSpec.revenue;dc_lat=;dc_rdid=; tag_for_child_directed_treatment=;tfua=;npa=; ord=floodlightSpec.sessionID;prd=i1:floodlightSpec.item[0].id|p1:floodlightSpec.item[0].price|q1:floodlightSpec.item[0].number|i2:floodlightSpec.item[1].id|p2:floodlightSpec.item[1].price|q2:floodlightSpec.item[1].number|c:floodlightSpec.country|l:floodlightSpec.lang?" width="1" height="1" alt=""> </noscript>


Note: Event snippets generated by Search Ads 360 include an optional <noscript> tag that contains a Floodlight image tag. This tag is used to report conversions in browsers that don't support JavaScript. If your site supports browsers that haven't enabled JavaScript, it's recommended that you update the Floodlight image tag to include purchase details as shown in the example.

Use Google Tag Manager to update your tags

Google Tag Manager helps you maintain tags on your site. Instead of adding and updating tags directly on your site, you add and update them in Google Tag Manager. Google Tag Manager then outputs properly formatted tags on your site as needed. Learn more about Google Tag Manager.

When you need to pass dynamically generated data—such as purchase details—to tags managed by Google Tag Manager, your web developer can do either of the following:

Use data from the data layer

If your web developer has made the purchase-details variable available in the data layer, follow these steps to pass the data to your Floodlight tag:
- Use the dataLayer.push method to make the data available in Google Tag Manager's data layer.
1. In Google Tag Manager, navigate to the container for your site.
2. Click the Tags tab and click the Floodlight transaction tag that reports sales.
3. Click the Pencil icon to make changes to the tag.
4. Under Product Reporting, check the Provide product-level sales data check box.
5. From the Data Source list, select Data Layer.
  Google Tag Manager will automatically use the data pushed to the data layer in the ecommerce.purchase.products array.
6. Click Save.
7. Preview and publish your changes.
Use a variable to access other data

If your web developer has made the purchase-details variable available somewhere other than the data layer, follow these steps to use a Google tag manager variable (formerly Macro) to pass the data on.
- Output the data elsewhere (such as in a DOM variable).
1. In Google Tag Manager, navigate to the container for your site.
2. Click the Tags tab and click the Floodlight transaction tag that reports sales.
3. Click the Pencil icon to make changes to the tag.
4. Under Product Reporting, check the Provide product-level sales data check box.
5. From the Data Source list, select one of the following:
  - JavaScript variable if the data is formatted as a JavaScript variable.
  - Floodlight formatted value if the data is formatted as a String.
6. Click the Add variable icon next to the Product Data Field.
7. Click the New variable button in the upper right.
8. Click the Pencil icon in the variable configuration card and do the following:
  1. Choose the appropriate variable type. For example, if the data is available in a JavaScript variable, select JavaScript Variable.
  2. In the next field, enter the name of the object that contains the data.
    
    For example, here's a page that outputs the String as a global JavaScript variable.
    
    <script> window.salesData="i1:sku-12345|p1:100.0|q1:1|i2:sku-67890|p2:20.0|q2:2" </script>
9. Name the variable either by editing the namespace at the top, or by clicking save and editing the name in the following window. After doing this, you should see the name enclosed in double brackets in the Product Data Field.
10. Click Save again to update the draft version of your tag.
11. Preview and publish your changes.
Validate your tags for reporting purchase details
After you add or update tags to support purchase-detail reports, you can use Google Tag Assistant to validate the tags.

To use Google Tag Assistant: In a Google Chrome browser, visit the Chrome Web Store and install Google Tag Assistant . (Learn more about using Google Tag Assistant .)

Tag Assistant will:
- Check the syntax of the purchase-details variable. For example, if you accidently define two IDs for a single product, or specify the wrong data type for a field, Tag Assistant will display an error.
- Provide a preview of the data that's collected by the tag.
- Perform checks on other variables within each tag

Purchase detail columns

Average unit price column
Displays the average price reported for sales of a product (using the price reported on each product).

Only available after you link your Merchant Center account with Search Ads 360.

Calculated as:
Revenue from units sold / Units sold
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Cross-sell average unit price column
Displays average price reported for sales of a product when it sold as a result of advertising a different product.

Only available after you link your Merchant Center account with Search Ads 360.

Calculated as
Revenue from the product when it sold as a cross sell / Cross-sell units sold
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Cross-sell cost of goods sold column
Displays the total cost of selling a product when it sold as a result of advertising a different product.

Only available after you enable your inventory feed to report on profit.

Calculated as:
Sum of cost_of_goods_sold for a given SKU over every transaction attributed to clicks on a different SKU
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Cross-sell gross profit from units sold column
Displays the total revenue generated from sales of a product as a result of advertising a different product.

Only available after you enable your inventory feed to report on profit.

Calculated as:
QUANTITY field * PRICE field - cost_of_goods_sold for a given SKU over every transaction attributed to clicks on a different SKU
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Cross-sell gross profit margin column
Displays the gross profit margin for a specific product when sold as a result of advertising a different product.

Only available after you enable your inventory feed to report on profit.

Calculated as
Cross-sell gross profit from units sold / total revenue
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Cross-sell revenue from units sold column
Displays the total revenue generated from cross sales (revenue generated as a result of advertising a different product).

Only available after you link your Merchant Center account with Search Ads 360.

Calculated as:
Revenue from units sold - Lead revenue from units sold
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Cross-sell units sold column
Displays the number of units sold as the result of cross-selling. (The number of units sold as a result of advertising a different product.)

Only available after you link your Merchant Center account with Search Ads 360.

Calculated as:
Units sold - Lead units sold
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Gross profit from units sold column
Displays the gross profit for a given SKU over every transaction in which it appears.

Only available after you enable your inventory feed to report on profit.

Calculated as:
QUANTITY field * PRICE field - cost_of_goods_sold from the inventory feed
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Gross profit margin column
Displays the gross profit margin for a specific product.

Only available after you enable your inventory feed to report on profit.

Calculated as
Gross profit from units sold / total revenue
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Lead average unit price column
Displays the average price reported for sales of a product when it sold as a result of advertising the product.

Only available after you link your Merchant Center account with Search Ads 360.

Calculated as
Revenue from this product when it sold as a result of advertising the product / Lead units sold
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Lead cost of goods sold column
Displays the total cost of selling a product when sold as a result of advertising the product.

Only available after you enable your inventory feed to report on profit.

Calculated as:
Sum of cost_of_goods_sold for a given SKU over every transaction attributed to clicks on the same SKU
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Lead gross profit from units sold column
Displays the total revenue generated from sales of a product as a result of advertising the product.

Only available after you enable your inventory feed to report on profit.

Calculated as:
QUANTITY field * PRICE field - cost_of_goods_sold for a given SKU over every transaction attributed to clicks on the same SKU
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Lead gross profit margin column
Displays the gross profit margin for a specific product as a direct result of advertising the product.

Only available after you enable your inventory feed to report on profit.

Calculated as
Lead gross profit from units sold / total revenue
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Lead revenue from units sold column
Displays the total revenue generated from a product as a result of advertising the product.

Only available after you link your Merchant Center account with Search Ads 360.

Calculated as:
Sum of the QUANTITY field * PRICE field for a given SKU over every transaction attributed to clicks on the same SKU
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Lead units sold column
Displays the number of units sold as a result of advertising the product.

Only available after you link your Merchant Center account with Search Ads 360.

Calculated as:
Sum of the QUANTITY field for a given SKU over every transaction attributed to clicks on the same SKU
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Net profit from units sold column
Displays the net profit for a given SKU over every transaction in which it appears.

Only available after you enable your inventory feed to report on profit.

Calculated as:
Gross profit from units sold - advertising cost
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Net profit margin column
Displays the net profit margin for a specific product.

Only available after you enable your inventory feed to report on profit.

Calculated as:
Net profit from units sold / revenue from units sold
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Revenue from units sold column
Displays the total revenue generated from a product (using the price reported on each product).

Only available after you link your Merchant Center account with Search Ads 360.

Calculated as:
Sum of the QUANTITY field * PRICE field for all SKUs over every transaction attributed to clicks on the same SKU
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.
Units sold column
Displays the total number of units sold for a particular product in your inventory feed.

Only available after you link your Merchant Center account with Search Ads 360.

Calculated as:
Sum of the QUANTITY field for all SKUs over every transaction attributed to clicks on the same SKU
View this column
You can view this column on the Dimension tab after you select either a Products sold dimension, a Products sold segment, or both. The Products sold dimensions and segments are only available after you link your Merchant Center account with Search Ads 360.

Navigate to an advertiser or lower scope.

Click the Dimension▼ tab and select a dimension.
For example, to view product performance organized by brand, select Brand sold.

Click the Segment button and select a Products sold segment.
For example, to view metrics for individual product IDs, select the Product ID segment.

If the column doesn't automatically appear in the reporting table, do the following:

Above the performance summary graph, click the Columns button.

Under Available columns, navigate to Products and select the column.

Click Apply.
You can use this and other purchase detail columns to automate campaign management. For example, you can add an automated rule to a keyword report that increases bids for any keyword that generates more than X dollars in cross-sell revenue. Learn more.

Update or create tags to report purchase details

Purchase detail columns

Update or create tags to report purchase details

Overview

Create a Floodlight tag or event snippet to track transactions

Generate content for the purchase-details variable

Requirements for the JSON format in a Floodlight event snippet

Requirements for the JSON format in the data layer

Requirements for the String format

Purchase-detail fields

Special characters and URL encoding

Add the purchase-details variable to your Floodlight tags or event snippets

Manually update your tags

Use Google Tag Manager to update your tags

Use data from the data layer

Use a variable to access other data

Validate your tags for reporting purchase details

Purchase detail columns

Average unit price column

Cross-sell average unit price column

Cross-sell cost of goods sold column

Cross-sell gross profit from units sold column

Cross-sell gross profit margin column

Cross-sell revenue from units sold column

Cross-sell units sold column

Gross profit from units sold column

Gross profit margin column

Lead average unit price column

Lead cost of goods sold column

Lead gross profit from units sold column

Lead gross profit margin column

Lead revenue from units sold column

Lead units sold column

Net profit from units sold column

Net profit margin column

Revenue from units sold column

Units sold column