I'm currently working on a campaign dashboard for Google Search within my project. The goal is to display date-wise metrics using a Line Graph, where the X-axis represents the date and the Y-axis encompasses metrics such as clicks, impressions, CTR (click-through rate), CPM (cost per thousand impressions), CPC (cost per click), and phone calls. The plotted lines will vary based on the dropdown selection.
However, I encountered an issue when fetching date-wise campaign metrics for the specific date range of January 23rd to January 24th using the API request provided below. The API only returns data for January 24th and does not include data for the 23rd. Nevertheless, in the summary, the aggregated values for the 23rd are included. API Request: URL: https://googleads.googleapis.com/v15/customers/{CUSTOMER_ID}/googleAds:searchStream Body: { "query": "SELECT campaign.id, campaign.name, campaign.start_date, campaign.end_date, metrics.impressions, metrics.clicks, metrics.average_cpc, metrics.average_cpm, metrics.ctr, metrics.phone_calls, metrics.search_impression_share, metrics.search_top_impression_share, metrics.top_impression_percentage, metrics.search_absolute_top_impression_share, metrics.cost_micros, segments.date, campaign_budget.total_amount_micros FROM campaign WHERE segments.date BETWEEN '2023-01-23' AND '2023-01-24' AND campaign.network_settings.target_google_search = true AND campaign.status IN ('ENABLED', 'PAUSED','REMOVED') ORDER BY segments.date", "summaryRowSetting": "SUMMARY_ROW_WITH_RESULTS" } Upon comparison with the ads.google.com portal, I noticed that on January 23rd, all metrics except for phone calls had zero values. It seems that when metrics have zero values, the Google API does not provide data for that date range. Could someone kindly guide me on how to resolve this issue? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/fa576aad-7a41-4879-a8fc-7771abb158b1n%40googlegroups.com.
