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.

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

CFV as Raw Event Attributes in the Conversion Resource

In the 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