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