fetch metrics for large mcc accounts

2023-02-09 Thread Vipul
How can I request metrics form shopping_performance_view for all sub accounts of google ad manager account in single query ? I have more than 500+ active sub accounts. Currently I making request for each sub account one by one and aggregating them manually but this causes huge performance issue

Fetch Metrics for large manager account

2023-02-09 Thread Vipul
Is there any way to fetch metrics from shopping_performance_view resource for all manager sub accounts using single query. I have large manager account which has more than 500 sub accounts. Currently I making request for each sub account one by one and aggregating them manually but this causes

Reporting data on campaign-level vs item-level cost matching

2023-03-31 Thread Vipul
Hello, on Google Ads reports When I build a report with columns "campaign," "campaign type," and "cost" the total cost displayed is matched with the cost displayed on the dashboard UI. but when I add the item id column (i.e. segments.product_item_id) in the report, the cost reduces and doesn't

Transaction wise conversions on google ads report

2024-07-07 Thread Vipul
Hi, I require transaction wise conversion report to identify selling pattern of items available in my inventory. I have researched but was not able to find the actual way of doing so as the transaction ids are just to avoid duplications in conversions (as per google doc) and they are not report

Re: [Google Ads API] Overall account performance using criteria_view (migration from CRITERIA_PERFORMANCE_REPORT in Adwords API)

2023-05-18 Thread Vipul
is there any update for this feature ? because I also have large manager account and have more than 500+ customer IDs. currently I am manually performing aggregation for all customer IDs to get overall data which takes more than 20mins. On Thursday, May 23, 2019 at 11:39:54 PM UTC+5:30 Google

Re: Fetch Metrics for large manager account

2023-05-18 Thread Vipul
Hello After research I have found this API https://developers.google.com/ad-manager/api/reporting Can this API overcome this issue I mentioned previously ? On Friday, February 10, 2023 at 2:47:44 AM UTC+5:30 Google Ads API Forum Advisor wrote: > Hi, > > Thank you for reaching out to the Googl

Re: transaction wise conversions on google ads report

2024-07-08 Thread Vipul G
is this an automated response? I have added enough details here and I am not able to find the exact thing in the google ads report UI that's why I have added it in descriptive way ! if I could get the report, I wasn't posting here ! On Monday, July 8, 2024 at 4:43:05 PM UTC+5:30 Google Ads API

Hour wise ad cost for item query

2023-07-17 Thread Vipul G
Hello I am expecting hour wise ad cost for items. currently I have created below query: *SELECT segments.product_item_id, segments.date FROM shopping_performance_view WHERE segments.date = '2023-01-05' AND segments.hour = 2*I am getting error like this,* 'segments.hour' is not

Re: hour wise ad cost for item query

2023-07-18 Thread Vipul G
API Forum Advisor wrote: > Hi Vipul, > > Thank you for reaching out to us. > > Upon checking, I could confirm that 'segments.hour' is not a valid field > in the WHERE clause when 'shopping_performance_view' is the resource in the > FROM clause. T

How Often Google ads stats are updated ?

2024-02-22 Thread Vipul G
How ofter google ads stats data are updated ? I am working on system which uses google ads api report data for analysis purpose, I am updating last 14 days data in my system form google ads api report But I can see there is minor difference between past data that was updated month ago in my sys

Re: how often google ads stats are updated ?

2024-02-25 Thread Vipul G
Yes, I have referred to the doc before posting a question here. Is there any chance that Google ads data is refreshed after 14 days? On Friday, February 23, 2024 at 5:58:10 PM UTC+5:30 Google Ads API Forum Advisor wrote: > Hi, > > Thank you for reaching out to the Google Ads API support team. >