geographic_view - report help

[AdWordsAPI-Gnr]

Hi,
This report shows two items. What can I do for it to show only one item? How do I group these two rows?(AREA_OF_INTEREST ,  LOCATION_OF_PRESENCE) 

Thanks.

QUERY 

SELECT campaign.id, campaign.name,geographic_view.country_criterion_id, metrics.cost_micros, metrics.clicks, metrics.all_conversions,metrics.all_conversions_from_interactions_rate, metrics.average_cost, metrics.average_cpc, metrics.average_cpm, metrics.average_cpv, metrics.impressions, metrics.interaction_rate, metrics.interactions,metrics.interaction_event_types
FROM geographic_view

RESULT

array(2) {
  ["results"]=>
  array(2) {
    [0]=>
    array(2) {
      ["metrics"]=>
      array(11) {
        ["interactionEventTypes"]=>
        array(1) {
          [0]=>
          string(5) "CLICK"
        }
        ["clicks"]=>
        string(3) "316"
        ["costMicros"]=>
        string(9) "755528951"
        ["allConversionsFromInteractionsRate"]=>
        float(0.12658227848101)
        ["allConversions"]=>
        int(40)
        ["averageCost"]=>
        float(2390914.4018987)
        ["averageCpc"]=>
        float(2390914.4018987)
        ["averageCpm"]=>
        float(188129718.8745)
        ["impressions"]=>
        string(4) "4016"
        ["interactionRate"]=>
        float(0.078685258964143)
        ["interactions"]=>
        string(3) "316"
      }
      ["geographicView"]=>
      array(2) {
        ["resourceName"]=>
        string(58) "customers/xxxxxxxxx/geographicViews/2792~AREA_OF_INTEREST"
        ["countryCriterionId"]=>
        string(4) "2792"
      }
    }
    [1]=>
    array(2) {
      ["metrics"]=>
      array(11) {
        ["interactionEventTypes"]=>
        array(1) {
          [0]=>
          string(5) "CLICK"
        }
        ["clicks"]=>
        string(3) "179"
        ["costMicros"]=>
        string(9) "285560000"
        ["allConversionsFromInteractionsRate"]=>
        float(0.050279329608939)
        ["allConversions"]=>
        int(9)
        ["averageCost"]=>
        float(1595307.2625698)
        ["averageCpc"]=>
        float(1595307.2625698)
        ["averageCpm"]=>
        float(118686616.79135)
        ["impressions"]=>
        string(4) "2406"
        ["interactionRate"]=>
        float(0.074397339983375)
        ["interactions"]=>
        string(3) "179"
      }
      ["geographicView"]=>
      array(2) {
        ["resourceName"]=>
        string(62) "customers/xxxxxxxxx/geographicViews/2792~LOCATION_OF_PRESENCE"
        ["countryCriterionId"]=>
        string(4) "2792"
      }
    }
  }
  ["fieldMask"]=>
  string(305) "geographicView.countryCriterionId,metrics.costMicros,metrics.clicks,metrics.allConversions,metrics.allConversionsFromInteractionsRate,metrics.averageCost,metrics.averageCpc,metrics.averageCpm,metrics.averageCpv,metrics.impressions,metrics.interactionRate,metrics.interactions,metrics.interactionEventTypes"
}

[Google Ads API Forum Advisor]

Hello,

 

I'm Kevin from the Google Ads API Team.

 

Can you please provide the complete request and response logs with request ID in order for us to better investigate the issue? You may send this to me via Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

 

Regards,

Kevin Gil Soriano Google Ads API Team

ref:_00D1U1174p._5004Q2VPaoD:ref

[AdWordsAPI-Gnr]

I shared the query and the returned data. How can I get one item to return for each campaign? Could you help. 

How can I get request id with rest api? I couldn't solve it.

thanks

26 Ocak 2022 Çarşamba tarihinde saat 12:01:55 UTC+3 itibarıyla adsapi şunları yazdı:

[Google Ads API Forum Advisor]

Hello,

Thanks for getting back to us.
With regards to your 1st query on how I can get one item to return for each campaign, can you please give us more clarity on your concern so that our team can provide specific recommendations? 
And with your 2nd  query, we support command line curl. By using command curl you can receive 3rd party software issues. Please refer to this page for more details.

To investigate the issue, kindly please share the complete request and response logs with request ID and request header generated on your end. Please use the Reply privately to the author option while sharing the details.

Best regards,

Jakeia Sabrina Google Ads API Team

 

ref:_00D1U1174p._5004Q2VPaoD:ref