Google Ads API - get app campaign data

[Tal Hashahar]

Hey all,

I tried to pull data from our app campaigns.

the query is:

q_campaign = ('''

        SELECT

          campaign.resource_name,

          campaign.id,

          campaign.name,

          campaign.status,

          campaign.serving_status,

          campaign.ad_serving_optimization_status,

          campaign.advertising_channel_type,

          campaign.advertising_channel_sub_type, 

          campaign.tracking_url_template, 

          campaign.advertising_channel_type,

          campaign.advertising_channel_sub_type,

          

          campaign.experiment_type,

          campaign.base_campaign,

          campaign.campaign_budget,

          campaign.bidding_strategy_type,

          campaign.start_date,

          campaign.end_date,

          campaign.final_url_suffix,

          campaign.frequency_caps,

          campaign.video_brand_safety_suitability,

          campaign.payment_mode,

          campaign.bidding_strategy,

          campaign.manual_cpv,

          campaign.maximize_conversions,

          campaign.target_cpm,

          

          campaign.app_campaign_setting.app_id,

          campaign.app_campaign_setting.app_store,

          campaign.app_campaign_setting.bidding_strategy_goal_type,

          

          metrics.impressions,

          metrics.clicks

        FROM campaign

        WHERE segments.date DURING LAST_30_DAYS

    ''')

the value of campaign.campaign_budget is 'customers/xyzxyz/campaignBudgets/xyzxyz'

xyzxyz == number with 10 digit.

[Google Ads API Forum Advisor Prod]

Hi Tal,

Thank you for reaching out. That 10 digit number is the ID of the campaign budget. If you want to get the value of the budget, you should add campaign_budget.amount_micros to your SELECT query. Just be aware that this value is in micros.

Regards,
Mitchell
Google Ads API Team

ref:_00D1U1174p._5001UXWE0Z:ref