Update or create tags to report purchase details

  1. 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 global site 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 global site 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

  2. 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; just make sure that the tag you create in Campaign Manager 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.
  3. 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:

    Requirements for the JSON format in a Floodlight event snippet

    If you use the global site 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:

    <!--
    Event snippet for Thank You on http://www.example.com/thanks: Please do not remove.
    Place this snippet on pages with events you’re tracking. 
    Creation date: 11/01/2017
    -->
    <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>
    <!-- End of event snippet: Please do not remove -->

    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 Sting 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 global site tag with the event snippet would look like this:
    <!-- 
    Start of global snippet: Please do not remove
    Place this snippet between the <head> and </head> tags on every page of your site.
    -->
    <!-- Global site tag (gtag.js) - DoubleClick -->
    <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>
    <!-- End of global snippet: Please do not remove -->

    <!--
    Event snippet for Thank You on http://www.example.com/thanks: Please do not remove.
    Place this snippet on pages with events you’re tracking. 
    Creation date: 11/01/2017
    -->
    <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>
    <!-- End of event snippet: Please do not remove -->

     

    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.

  4. 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:

    <!--
    Event snippet for Thank You on http://www.example.com/thanks: Please do not remove.
    Place this snippet on pages with events you’re tracking. 
    Creation date: 11/01/2017
    -->
    <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>

    <!-- End of event snippet: Please do not remove -->

    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 makes it easy to 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 Pencil Edit 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 Pencil Edit 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:

    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 Pencil Edit 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.

  5. 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

  1. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  2. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  3. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  4. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  5. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  6. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  7. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  8. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  9. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  10. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  11. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  12. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  13. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  14. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  15. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  16. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  17. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  18. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.
  19. 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.

    1. Navigate to an advertiser or lower scope.

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

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

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

      1. Above the performance summary graph, click the Columns button.

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

      3. 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.