Facebook Logs Stored Procedures: Modify to monitor Only Configuration Fields. Exclude Balances and Remaining Budgets

[CesarITD]

The rows that look like duplicated were found not to be duplicates, it is not necessary to modify the tracking detection fields in the procedures. We just need to be aware that the report in the Log Detail table includes all the Tracking Detection change fields. These are:

[CesarITD]

Ads: WHERE l.id = r.id AND ( l.name <> r.name OR l.target <> r.target OR l.AdStatus <> r.AdStatus OR l.BidInfo <> r.BidInfo OR l.BidType <> r.BidType OR l.CampaignId <> r.CampaignId OR l.AdSetId <> r.AdSetId OR l.AdCreativeId <> r.AdCreativeId OR l.ConfiguredStatus <> r.ConfiguredStatus ) ;

[CesarITD]

AdSets: WHERE l.id = r.id AND ( l.name <> r.name OR l.target <> r.target OR l.AdSetStatus <> r.AdSetStatus OR l.BillingEvent <> r.BillingEvent OR l.DailyBudget <> r.DailyBudget OR l.LifetimeBudget <> r.LifetimeBudget OR l.EndTime <> r.EndTime OR l.StartTime <> r.StartTime OR l.Recommendations <> r.Recommendations OR l.TargetingGeoMarkets <> r.TargetingGeoMarkets OR l.TargetingInterests <> r.TargetingInterests OR l.TargetingBehaviors <> r.TargetingBehaviors OR l.TargetingPageTypes <> r.TargetingPageTypes ) ;

[CesarITD]

Campaigns: WHERE l.id = r.id AND ( l.name <> r.name OR l.target <> r.target OR l.BuyingType <> r.BuyingType OR l.ConfiguredStatus <> r.ConfiguredStatus OR l.EffectiveStatus <> r.EffectiveStatus OR l.Status <> r.Status OR l.Objective <> r.Objective OR l.SpendCap <> r.SpendCap OR l.StartTime <> r.StartTime OR l.StopTime <> r.StopTime OR l.DailyBudget <> r.DailyBudget ) ;

[CesarITD]

AdAccounts: WHERE l.id = r.id AND ( l.name <> r.name OR l.target <> r.target OR l.AccountStatus <> r.AccountStatus OR l.Capabilities <> r.Capabilities OR l.MinCampaignGroupSpendCap <> r.MinCampaignGroupSpendCap OR l.Name <> r.Name OR l.OwnerId <> r.OwnerId OR l.SpendCap <> r.SpendCap OR l.TimezoneId <> r.TimezoneId ) ;