I'm trying to code a similar functionality to how the Adwords web interface manages the change between the 2 main campaign bidding strategies;
ManualCPC (CPC bidding) and
ConversionOptimizer (CPA bidding).
The Adgroup_Performance_Report has two corresponding columns:
- KeywordMaxCpc which will be populated if the campaign bidding strategy is ManualCPC.
- TargetCpa which will be populated if the campaign bidding strategy is ConversionOptimizer.
At any point in time, we have only one of the two above values, while the other is NULL. We download and store the Adgroup_Performance_Report with the above two fields.
The challenge we have is when the user switches between the 2 bidding strategies, we need to update the above 2 columns in our database accordingly and hence need to find out what the other value is.
We can obviously download the Adgroup_Performance_Report for all the adgroups within that campaign to get the correct values for the column that used to be NULL.
I'm just wondering though if that's the best solution? Has anyone else got a better idea of how to find these values?
Many thanks
Oliver