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

Flag significant changes in clickthrough rate (CTR)

This collection of formula columns report on changes in clickthrough rates. You can include the columns at any scope. For example, scope to an advertiser and add the columns to the Campaigns tab. The CTR Flag will indicate which campaigns experienced more than a 3% change in clickthrough rate yesterday as compared to the previous day.

Formula name Formula Description
CTR yesterday CTR.for_date_range(yesterday()) Yesterday's clickthrough rate.
CTR day before yesterday CTR.for_date_range(yesterday(), days(-1)) Clickthrough rate for the day before yesterday.
CTR Flag % to_percent((c:"CTR yesterday"-c:"CTR day before yesterday")/c:"CTR day before yesterday" ) The percent change in clickthrough rate.
CTR Flag

IF(
 OR
    (c:"CTR Flag %" > 3%), 
    (c:"CTR Flag %" < -3%) 
  ), 
"True", 
"False"
)

Displays "True" if the clickthrough rate has changed more than 3%, otherwise displays "False".

 

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

c:"CTR yesterday" c:"CTR day before yesterday" c:"CTR Flag %" c:"CTR Flag"
4.21% 2.80% 50.53% True
3.33% 5.45% -38.89% True
7.14% 0.00% -- --
Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
263
false