ads disapproved when the user updates an account with a new URL and happens to delete a campaign.

In Hibu, this issue was observed for the following merchant: http://ExtremeCarAudioWeymouthMA.com The account ID for the account is: 75fb0fe9-7972-43df-960d-29e6ecfc1539 mysql> select * from accounts where domain LIKE '%ExtremeCarAudioWeymouthMA.com%'; --- ------------------------------------ ------------------------------ id bpID domain --- ------------------------------------ ------------------------------ 31 75fb0fe9-7972-43df-960d-29e6ecfc1539 ExtremeCarAudioWeymouthMA.com --- ------------------------------------ ------------------------------ 1 row in set (0.00 sec) It looks like this account has two ad’s: mysql> select distinct displayURL from gce_adGroup ag join gce_textAd ta on ta.adGroupID = ag.id and ag.name LIKE '%75fb0fe9-7972-43df-960d-29e6ecfc1539%'; ------------------------------- displayURL ------------------------------- www.extremecaraudioinc.com ExtremeCarAudioWeymouthMA.com ------------------------------- 2 rows in set (0.08 sec) Looking at one of the campaigns as an example, the issue I suspect seems to be that, even though the old ad www.extremecaraudioinc.com was disabled in the gce_textAd, it is still enabled in the adgroup. Basically there are two ad’s enabled in the ad group. Please see below. mysql> select ag.name, ta.displayURL, ag.status, ta.status from gce_adGroup ag join gce_textAd ta on ta.adGroupID = ag.id and ag.name LIKE '%75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172%' ; ------------------------------------------------------------------------- ----------------------------- ------- ---------+ name displayURL status status ------------------------------------------------------------------------- ----------------------------- ------- ---------+ 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy, MA www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy, MA www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy, MA www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy, MA www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy, MA www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy, MA www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy, MA ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy, MA ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy, MA ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy, MA ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 www.extremecaraudioinc.com Enabled Disabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172 ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy Massachusetts ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy Massachusetts ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy Massachusetts ExtremeCarAudioWeymouthMA.com Enabled Enabled 75fb0fe9-7972-43df-960d-29e6ecfc1539_10270_6244_172_Quincy Massachusetts ExtremeCarAudioWeymouthMA.com Enabled Enabled ------------------------------------------------------------------------- ----------------------------- ------- ---------+ 34 rows in set (0.03 sec)