Welcome to the help center for Search Ads 360, a platform for managing search marketing campaigns.  While the help center is available to the public, access to the Search Ads 360 product is available only to subscribing customers who are signed in. To subscribe or find out more, contact our sales team.

Create formula columns

Report 7-day trend in conversion rates

This collection of formula columns report on the trend in Floodlight conversion rates at any scope. For example, scope to an advertiser and add the columns to the Campaigns tab. You can then see which campaigns experienced increased, flat, or decreased conversions over the past 7 days.

Formula name Formula Description
Conv. rate ( Actions + Trans ) / Clicks The total number of Floodlight conversions per click.
Conv. rate 30 c:"Conv. rate".for_date_range(last_30_days()) The conversion rate for the last 30 days.
Conv. rate 7 c:"Conv. rate".for_date_range(last_7_days()) The conversion rate for the last 7 days.
Conv. rate trend % to_percent((c:"Conv. rate 7"/c:"Conv. rate 30")-1) The change in conversion rate over the past 7 days, converted to a percent.
Conv. rate trend IF(
AND (c:"Conv. rate trend %" >10% ,
c:"Conv. rate trend %" < 30%),"Increasing",
c:"Conv. rate trend %" > 30%,"Strongly increasing",
AND ( c:"Conv. rate trend %" < -10%,
c:"Conv. rate trend %" > -30% ),"Decreasing",
c:"Conv. rate trend %" < -30%,"Strongly decreasing","Flat")
Outputs an analysis of the change in conversion rate. 


If you scoped to an advertiser and added these columns to the Campaigns tab, you'd see something like the following:

c:"Conv. rate 30" c:"Conv. rate 7" c:"Conv. rate trend %" c:"Conv. rate trend
12.18 14.07 15.53% Increasing
11.84 11.82 0.11% Flat
15.12 20.62 36.38% Strongly increasing
10.26 8.72 -17.61% Decreasing


Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center