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 
<https://www.loom.com/share/e7ba89f75bb5480688cb7e27222964df>

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. 
[image: mcc-reports-screenshot-02222023.png]

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. 


-- 
Confidentiality 
      Note: This email and any attachment(s) are for the 
sole use of the 
      intended recipient(s) and may be confidential and/or 
privileged. Any 
      unauthorized use, disclosure or copying is strictly 
prohibited and may be 
      unlawful. If you have received this 
communication in error, please 
      immediately notify the sender by 
return email, and delete the 
      message.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"Google Ads API and AdWords 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/a44c2a32-3757-49af-9894-065625f7f4c2n%40googlegroups.com.

Reply via email to