CAMPAIGN_LOCATION_TARGET_REPORT returns mismatching information to Google Ads website

[Rashel C]

Hello,

I'm trying to execute this query:

var report = AdsApp.report(
    "SELECT Id, CampaignName, CampaignId, BidModifier, Conversions, ConversionValue, Cost " +
    "FROM CAMPAIGN_LOCATION_TARGET_REPORT " +
    "WHERE IsNegative = FALSE " +
    "AND CampaignName = '" + config.CAMPAIGN_NAME +
    " AND CampaignStatus = ENABLED " +
    " DURING " + config.DATE_RANGE
  );

I set the date range to the last 30 days. For example, for the same campaign, in the last 30 days, it returns that, for Florida, the Cost was $2.41. Meanwhile, if I look at Florida via Google Ads website,  I see the cost was $2.83. I checked multiple locations and there was a lot of mismatches. The differences are usually small, but significant when I'm trying to calculate ROAS. 

Any idea how I can solve this? I really need the info from the query to match the website.

Thanks

[Google Ads API Forum Advisor]

Hello,

Thank you for reaching out to Google Ads API Support.

Can you please provide us with the complete request and response logs with request ID generated on your end and an uncropped screenshot of the Google Ads UI showing “if I look at Florida via Google Ads website, I see the cost was $2.83”? so we can investigate the discrepancies further?

If you haven't enabled logging yet, it can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation(via this link https://developers.google.com/google-ads/api/docs/best-practices/logging#client_library_logging), which you can access from this link. For REST interface requests, you can enable logging via the curl command by using the -i flag.

You can provide it via Reply privately to the author option. If this option is not available, then send it instead on this email address googleadsa...@google.com. 

Reference Links:
Request - https://developers.google.com/google-ads/api/docs/concepts/field-service#request
Response Logs - https://developers.google.com/google-ads/api/docs/concepts/field-service#response
Request ID - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id

Regards,

Google Ads API Team

ref:_00D1U1174p._5004Q2kVj6c:ref

[Rashel C]

I'm sorry, I'm not sure where I can find that. I just go to Bulk Actions -> Scripts on the Ads website and run the script. I don't see any request ID or response logs.

[Google Ads API Forum Advisor]

Hi Rashel,

Thank you for your clarification.

Please note that our support channel can provide assistance related to Google Ads API technical issues only. It appears that your concerns are more related to the  Google Ads Scripts. That said, we suggest reaching out to their support team via Google Ads Scripts Forum with the information that you provide here.

Please refer to the link below:

• Google Ads API - https://developers.google.com/google-ads/api/docs/start
• Google Ads Scripts Forum - https://groups.google.com/g/adwords-scripts

Best regards,