# Custom Floodlight metrics

Custom Floodlight variables (CFVs) enable you to collect details about each
conversion tracked in a Floodlight activity. These variables can include
information like the type of product purchased, the loyalty status of the
customer, or the amount of discount applied.

For more information, see [About custom Floodlight metrics and dimensions in the
new Search Ads 360](https://support.google.com/sa360/answer/13567857).

## CFVs as metrics and segments

Search Ads 360 aggregates the values of variables set as metrics. For example,
if an advertiser tracks customer lifetime value (CLV) as a custom Floodlight
variable metric, including this in the [ad group](https://developers.google.com/search-ads/reporting/api/reference/fields/v0/ad_group) resource
would show the aggregated CLV for each ad group within the resource.

CFVs defined as dimensions can be used to segment resources. For example, an
advertiser could use a CFV to track product categories. Once set as a dimension,
this allows segmentation of an ad group resource to show the number of
conversions attributed to each product category within the ad group.

To get all available custom variables, execute the following:

    SELECT conversion_custom_variable.id,
           conversion_custom_variable.name,
           conversion_custom_variable.tag,
           conversion_custom_variable.floodlight_conversion_custom_variable_info.floodlight_variable_type
    FROM conversion_custom_variable

### CFV as metrics and segments examples

After you have the conversion_custom_variable ID and variable type, you can
build your own query similar to the following examples:

    SELECT conversion_custom_metrics.id[1234]
    FROM campaign
    WHERE segments.date=20240118

    SELECT conversion_custom_dimensions.id[1234]
    FROM campaign
    WHERE segments.date=20240118

#### Restrictions

- Only one conversion_custom_dimensions segment can be selected per query.

- conversion_custom_metrics and conversion_custom_dimensions cannot be
  selected in the same query.

- conversion_custom_metrics and conversion_custom_dimensions
  can only be used with ad_group, ad_group_ad, ad_group_criterion, campaign and
  customer resources.

## CFV as Raw Event Attributes in the Conversion Resource

In the [Conversion](https://developers.google.com/search-ads/reporting/api/reference/fields/v0/conversion) resource, custom Floodlight variables
(CFVs) provide detailed, unaggregated data about individual conversions. When a
custom dimension is added to the query, its specific value for each event is
visible. For example, if you track product types and brands as CFVs, you could
create a report showing the following data:

| Conversion ID | Timestamp | Product Type | Brand |
|---|---|---|---|
| 20001 | 202311101030 | Electronics | Example Brand 1 |
| 20002 | 202311101045 | Apparel | Example Brand 2 |
| 20003 | 202311101215 | Electronics | Example Brand 3 |

It's important to note that in the conversion resource, metrics such as Number
Sold are presented as individual event data, not as aggregated figures. Each
conversion event is detailed separately, treating both CFV metrics and
dimensions as specific event attributes.

To get all available custom variables, execute the following:

    SELECT conversion_custom_variable.id,
           conversion_custom_variable.name,
           conversion_custom_variable.tag,
           conversion_custom_variable.floodlight_conversion_custom_variable_info.floodlight_variable_type
    FROM conversion_custom_variable

After you have the conversion_custom_variable ID and variable type, you can
build your own query similar to the following example

### CFV as a raw event example

    SELECT raw_event_conversion_dimensions.id[1234],
           raw_event_conversion_metrics.id[5678]
    FROM conversion
    WHERE segments.date=20240118

> [!NOTE]
> **Note:** raw_event_conversion_dimensions and raw_event_conversion_metrics can only be used with the conversion resource.