`PreviousPeriodTotalCost` not matching `currentPeriodTotalCost` from the previous month in the API

[Matthew Mcguff]

Support:

I am having an issue involving the previousPeriodTotalCost not matching what the currentPeriodTotalCost from the previous month.  

I demonstrate and explain this issue in the following video: 

loom video of the data issue

When I call the following API call and look for the result for accountId: '1005896713' get the following when I query the full month of Jan 2023

        {

            "accountId": "1005896713",

            "businessName": "Law Office of Christopher P. Walker, P.C.",

            "averageWeeklyBudget": 411,

            "averageFiveStarRating": 4.8,

            "totalReview": 43,

            "phoneLeadResponsiveness": 0.46,

            "currentPeriodChargedLeads": "6",

            "previousPeriodChargedLeads": "7",

            "currentPeriodTotalCost": 981.65,

            "previousPeriodTotalCost": 806,

            "currencyCode": "USD",

            "currentPeriodPhoneCalls": "21",

            "previousPeriodPhoneCalls": "23",

            "currentPeriodConnectedPhoneCalls": "16",

            "previousPeriodConnectedPhoneCalls": "0",

            "impressionsLastTwoDays": "0"

        }

Note the currentPeriodTotalCost is 981.65.  I would expect if I were to query the month of February that the previousPeriodTotalCost for this accountId should be 981.65.  However I get the following: 

        {

            "accountId": "1005896713",

            "businessName": "Law Office of Christopher P. Walker, P.C.",

            "averageWeeklyBudget": 411,

            "averageFiveStarRating": 4.8,

            "totalReview": 43,

            "phoneLeadResponsiveness": 0.46,

            "currentPeriodChargedLeads": "9",

            "previousPeriodChargedLeads": "5",

            "currentPeriodTotalCost": 971.23,

            "previousPeriodTotalCost": 844.65,

            "currencyCode": "USD",

            "currentPeriodPhoneCalls": "20",

            "previousPeriodPhoneCalls": "17",

            "currentPeriodConnectedPhoneCalls": "15",

            "previousPeriodConnectedPhoneCalls": "15",

            "impressionsLastTwoDays": "0"

        }

I'm not sure where 844.65 is coming from.  This value isn't showing in MCC Reports. 

Is there something we are doing wrong in how we are calling the API?  

Here are the curls we are using from the API calls we are making: 

January API call

curl --location 'https://localservices.googleapis.com/v1/accountReports:search?query=manager_customer_id%3A5401188294&startDate.day=1&startDate.month=1&startDate.year=2023&endDate.day=31&endDate.month=1&endDate.year=2023' \
--header 'Authorization: Bearer <Token removed for security>

February API Call

curl --location 'https://localservices.googleapis.com/v1/accountReports:search?query=manager_customer_id%3A5401188294&startDate.day=1&startDate.month=2&startDate.year=2023&endDate.day=28&endDate.month=2&endDate.year=2023' \

--header 'Authorization: Bearer <Token removed for security>

Please advise what the best course of action to take should be.   If this is working as expected, please advise what I should be doing to the value int the API to arrive the value in MCC Reports for the previous month.  I suppose I could disregard previous month from the API call and when populating our database with the data, we could only use current month and prepopulate the previous month of next row with the current of the previous but don't like going down the road of only trusting some of the values the API calls we make Google Ad Words.  

Thanks for you all the great work you do in advance. 

[Google Ads API Forum Advisor]

Hi Matthew,

Thank you for reaching us out. I am Sherwin from Google Ads API support team. I hope that you are doing well today.

Moving forward to your concern, I can see that your concern is related to Local Services. Please note this is out of our scope for Google Ads API support team. We only provide support for Google Ads API related concerns. What we can do is to advise you to reach out to the Local Services support team via this link.

Kind regards,

Sherwin Vincent Google Ads API Team

ref:_00D1U1174p._5004Q2jFkyB:ref