all_conversion_value returns zero in Google Ads API, but works in Google Adwords API

89 views
Skip to first unread message

Ершов Александр

unread,
Mar 9, 2022, 9:51:58 PM3/9/22
to Google Ads API and AdWords API Forum
Hello!
This code works correctly in the Google Adwords API

$query = (new ReportQueryBuilder())


->select([


'AllConversionValue', 'Cost', 'Device'


])


->from(ReportDefinitionReportType::ACCOUNT_PERFORMANCE_REPORT)


->duringDateRange(ReportDefinitionDateRangeType::TODAY)


->build();

but the new one ( I used conversion tool https://developers-dot-devsite-v2-prod.appspot.com/google-ads/api/docs/migration/query-migration-tool_a8523c3e61730f1a26af89941c07e858bcc10faf0d6c1a006181be96d8c0b4fb.frame?hl=ru#loaded  ) returns all_conversion_value, equal to zero (but cost value is correct for all segments)

SELECT metrics.all_conversions_value, metrics.cost_micros, segments.device FROM customer WHERE segments.date DURING TODAY

The requests are done to the same account, it's been verified.


Could you please take a look, when you have time?


Best regards API

Google Ads API Forum Advisor

unread,
Mar 10, 2022, 12:42:10 AM3/10/22
to elektrik...@gmail.com, adwor...@googlegroups.com
Hi,

Thank you for posting your concern to our team.

To investigate the issue, could you provide the complete request and response logs with request ID and request header generated on your end where we can see the error?

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

Regards,
Google Logo
Ernie John
Google Ads API Team
 


ref:_00D1U1174p._5004Q2XnAQ2:ref

Ершов Александр

unread,
Mar 10, 2022, 11:19:14 PM3/10/22
to Google Ads API and AdWords API Forum
Hello!
Found out the issue, it was on my side.
I was using the method to get Conversions.
Should have use getAllConversionsValue(). 
When switched to it, data started coming.

Only one question left.
When I was calculating the data in the Google Adwords API (ROAS), to make sure it's equal to the UI value of ROAS,
I had to subtract the cost of mobile calls via the code below.
Should I use it in the new Google Ads API, too?
May be you know, just wanted to check with you

$query = (new ReportQueryBuilder())

                    ->select([

                        'AllConversionValue', 'Cost', 'Device'

                    ])

                    ->from(ReportDefinitionReportType::ACCOUNT_PERFORMANCE_REPORT)

                    ->where('ClickType')->in(['CALLS'])

                    ->where('Device')->in(['HIGH_END_MOBILE'])

                    ->duringDateRange(ReportDefinitionDateRangeType::TODAY)

                    ->build();


                $reportSettingsOverride = (new ReportSettingsBuilder())

                    ->build();


Google Ads API Forum Advisor

unread,
Mar 11, 2022, 3:25:41 AM3/11/22
to elektrik...@gmail.com, adwor...@googlegroups.com

Hi there,

Thanks for getting back to us.

We’re glad to know your issue has been resolved. For us to check what value of ROAS you’re referring to, could you please provide us with the complete Ads UI screenshot via Reply privately to author option, so that I can verify the appropriate field using the Google Ads API?

Regards,

Google Logo
Yasar
Google Ads API Team
 


ref:_00D1U1174p._5004Q2XnAQ2:ref
Reply all
Reply to author
Forward
0 new messages