Why Are Updates to spend_cap
, daily_budget
, or lifetime_budget
Not Synced to the CAMPAIGN_HISTORY
Table?link
Questionlink
Why are updates to spend_cap
, daily_budget
, or lifetime_budget
not synced to the CAMPAIGN_HISTORY
table?
Environmentlink
Connector: Facebook Ads
Answerlink
The CAMPAIGN_HISTORY
table updates incrementally based on changes to the updated_time
field from Meta's Marketing API. Following each sync, we store the latest updated_time
. During subsequent syncs, we fetch only those entities whose updated_time
value is greater than the cursor value.
However, the updated_time
field does not automatically update when the spend_cap
, daily_budget
, or lifetime_budget
fields are updated. See Meta's Marketing API documentation for more information.
Due to this limitation with Meta's Marketing API, it is not possible to incrementally sync updates to the spend_cap
, daily_budget
, or lifetime_budget
fields. We will only sync updates to these fields when the updated_time
field updates due to another field update.