Hello, Ben Thanks for jumping to me.
Well, I got this formula from two ones. The first was given here in the forum: "You will have to compute the remaining balance by subtracting the total Cost of the Account Performance Report from your known budget." https://groups.google.com/g/adwords-api/c/M3nwAv5jlfc/m/4_02Wi0MAgAJ And the known budget was given here as: "The account budget will be equal to spendingLimit <https://developers.google.com/adwords/api/docs/reference/v201702/BudgetOrderService.BudgetOrder#spendingLimit> - totalAdjustments." https://groups.google.com/g/adwords-api/c/kQyyzdJ9_Qs/m/zwqOLh4XAgAJ Okay then, if the formula looks like "spendingLimit - Cost", I was wrong. But let's see how the right one works: For 20 August 2020 (my first message in this thread): Balance via API = (5872722560000 - 5781697901970)/1000000 = *91 024.66 RUB* "Your remaining credit" (Google Ads account) = *124 242.02 RUB *with VAT and *103 535.02 RUB *without VAT *Difference = 12 510.36 RUB* For 28 August 2020 (when I gave another data): Balance via API = (5872722560000 - 5815358461970)/1000000 = *57 364.10 RUB* "Your remaining credit" (Google Ads account) = *81 692.32* with VAT and *68076.93 RUB* without VAT *Difference = * *10 712.83 RUB* With all the respect, Ben, I think, that 12-16% is not "a slight difference". Thanks for clarifying though. вторник, 1 сентября 2020 г. в 05:27:05 UTC+3, adsapiforumadvisor: > Hi Inna, > > Apologies for the delay - I'm a Developer Programs Engineer on the Google > Ads API jumping in here to help with your problem. > > I was wondering if you could give me a bit more background on where you > got the equation: spendingLimit - totalAdjustments - Cost = remaining > balance > > Based on the documentation spendingLimit should already include > totalAdjustments when retrieved via a BudgetOrderService.get. You should > only need to subtract totalAdjustments when trying to determine the amount > that was originally set before adjustments were applied. > > With that said, adjusting your equation below still doesn't yield the same > values, thought they appear closer. I think it's possible that there may > always be slight differences between the values retrieved in the API and > what's visible via the UI. I'm going to try to get some better information > on that and will follow up, meanwhile let me know if updating your equation > to remove totalAdjustments is helpful. > > Thanks, > Ben Karl, Google Ads API Team > > ref:_00D1U1174p._5004Q23tJDV:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/7b31ca9c-190c-4933-9f60-64c59a24668fn%40googlegroups.com.
