Re: Report query result via API doesn't match with AdWords UI

2018-04-13 Thread Khoa Nguyen 
Thanks Bharani for the useful information. I thought the AdWords API maps 
to the report using Report Editor but now I know that it matches the one in 
the AdWords dashboard 
(https://adwords.google.com/aw/?ocid). However, 
about in-matching results of API call & UI, I would like to ask 2 questions:

1. With the same report query: "SELECT Id, CampaignName, AdGroupName, 
Clicks, Impressions, Ctr, AverageCpc, Cost, Conversions, 
ViewThroughConversions, CostPerConversion, ConversionRate FROM 
AD_PERFORMANCE_REPORT DURING LAST_WEEK" now returns 21978 rows (API), but 
when I use the AdWords UI (https://adwords.google.com/aw/ads?ocid=...), it 
shows only 21246 rows. Note that I selected ALL Campaign status, ALL Group 
status and ALL Ad status already. Similar thing happens for AdGroup 
Performance or Campaign Performance reports. For example, I found that the 
API result contains some campaign names which I couldn't find them on the 
UI:

< AWN_001:013edd3b_013edef8
< AWN_001:013edd3b_013ef211
< AWX_001:013edd3b_013edef8
< AWX_001:013edd3b_013edef8_content
< AWX_001:013edd3b_013ef211
< AWX_001:013edd3b_013ef211_content

Am I missing something? Is there any hidden filter on AdWords UI that 
causes this? I would like to know them all as we rely on the AdWords UI to 
compare it with the result of our API call. 

2. I found that the AdWords Report Editor works differently from API call 
on the same Attributes, Segments & Metrics. For example, if I use AdWords 
Report Editor to select row keys (Ad Id, Year), and metrics (Clicks, 
Impressions), the result seems to be aggregated by Year and the number of 
rows gets reduced significantly. Whereas, in the API call's result using Ad 
Performance Report, there are about the same number of Ad items (~21978 
rows). Is there any way to build query using API so that the result can 
match with the one in Report Editor UI?

Thanks in advance!

On Friday, April 13, 2018 at 2:54:37 AM UTC+7, Bharani Cherukuri (AdWords 
API Team) wrote:
>
> Hello, 
>
> I was able to take a look at the discrepancy you're noticing. The AdWords 
> API have similar naming conventions as UI reports. However, the stats 
> pulled through the API map to the corresponding Ads tab metrics in the UI. 
> Please refer to this guide 
> <https://developers.google.com/adwords/api/docs/guides/uireports> on how 
> API reports are mapped in the UI. 
>
> Let me know if you have any other questions.
>
> Thanks,
> Bharani, AdWords API Team
>
> On Thursday, April 12, 2018 at 6:09:11 AM UTC-4, Khoa Nguyen wrote:
>>
>> Hi AdWords API support team,
>>
>> It seems the result of report query by API and AdWords UI is different:
>> - With the following report query: 
>> SELECT Id, CampaignName, AdGroupName, Clicks, Impressions, Ctr, 
>> AverageCpc, Cost, Conversions, ViewThroughConversions, CostPerConversion, 
>> ConversionRate
>> FROM AD_PERFORMANCE_REPORT DURING LAST_WEEK
>>
>> In the AdWords UI (I used predefined "Basic / Ad" report), it shows 21240 
>> rows whereas the API returns 21972 rows. I found that there are some Ids in 
>> the API result not found in the AdWords UI.
>> - With this report query (add Year segment):
>>
>> SELECT Id, CampaignName, AdGroupName, Year, Clicks, Impressions, Ctr, 
>> AverageCpc, Cost, Conversions, ViewThroughConversions, CostPerConversion, 
>> ConversionRate
>> FROM AD_PERFORMANCE_REPORT DURING LAST_WEEK
>>
>> In the AdWords UI, once I add "Year" to the row key, it shows 222 rows 
>> whereas the API still returns 21972 rows and the "Year" column all contains 
>> "2018" value
>>
>> Do you have any idea why it's like that?
>>
>> Thank you.
>>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/816edae7-aff4-49a8-92c1-fb3943778d98%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Report query result via API doesn't match with AdWords UI

2018-04-12 Thread khoa 
Hi AdWords API support team,

It seems the result of report query by API and AdWords UI is different:
- With the following report query: 
SELECT Id, CampaignName, AdGroupName, Clicks, Impressions, Ctr, AverageCpc, 
Cost, Conversions, ViewThroughConversions, CostPerConversion, ConversionRate
FROM AD_PERFORMANCE_REPORT DURING LAST_WEEK

In the AdWords UI (I used predefined "Basic / Ad" report), it shows 21240 
rows whereas the API returns 21972 rows. I found that there are some Ids in 
the API result not found in the AdWords UI.
- With this report query (add Year segment):

SELECT Id, CampaignName, AdGroupName, Year, Clicks, Impressions, Ctr, 
AverageCpc, Cost, Conversions, ViewThroughConversions, CostPerConversion, 
ConversionRate
FROM AD_PERFORMANCE_REPORT DURING LAST_WEEK

In the AdWords UI, once I add "Year" to the row key, it shows 222 rows 
whereas the API still returns 21972 rows and the "Year" column all contains 
"2018" value

Do you have any idea why it's like that?

Thank you.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/65a0f60d-0df9-4e21-994d-af62cbbdf4cd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: API developer token taking crazy long

2012-07-05 Thread Khoa Nguyen 
I've been waiting for 8 months and there's always some sort of reason the 
team can't approve me: 910-068-6100
Can you look into my case as well? Khoa


On Thursday, July 5, 2012 4:06:39 PM UTC+7, pim wrote:

 Kevin,

 Same here.  Customer ID: 345-794-7473 
 I have been waiting 11 weeks where it said 4-6 weeks. If you can't help me 
 now, please let me know in what timeframe you can?!

 Regards, Pim

 On Tuesday, May 1, 2012 3:19:01 PM UTC+2, Maarten Deinema wrote:

 Hi,

 Could someone tell me what the normal duration is for the API developer 
 token approval? We have requested access late 2011, and the token is still 
 Pending Approval. We have had requests for additional information three 
 times now, and have sent the information each time.

 Is there any way to speed up the process? We have customers waiting for 
 our software, and they are getting very impatient. When sending email to 
 adwordsapi-tok...@google.com there is no reply at all.

 Regards,

 Maarten



-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups AdWords 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

Re: Using the AdHoc Reports in v201109 .NET library Cross client

2012-02-14 Thread anh khoa nguyen 
Hi OldSkool,

I've already changed my ClientCustomerId to my MCC account but I'm
still facing the same problem. Any idea?


Thanks,

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups AdWords 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

API v201109: Exception: Report contents are invalid. - !!!2|||-1|||[ReportDefinitionError.CUSTOMER_SERVING_TYPE_REPORT_MISMATCH @ selector]???

2012-02-14 Thread anh khoa nguyen 
Hi all,

I got this exception when trying to download the report: Report
contents are invalid. - !!!2|||-1|||
[ReportDefinitionError.CUSTOMER_SERVING_TYPE_REPORT_MISMATCH @
selector]???

After researching in forum I found some recommend to using MMC account
instead of MMCs, I've already account but the exception is still being
raised,


Below is my code:

definition.reportName = reportName;
definition.reportType =
ReportDefinitionReportType.ADGROUP_PERFORMANCE_REPORT;
definition.downloadFormat = DownloadFormat.XML;
definition.dateRangeType =
ReportDefinitionDateRangeType.YESTERDAY;

Selector selector = new Selector();
selector.fields = new string[] { AccountDescriptiveName,
ExternalCustomerId, CampaignName, CampaignStatus, AdGroupName,
Status, AdGroupId, Cost };

definition.selector = selector;
definition.includeZeroImpressions = true;


 ReportUtilities service = new ReportUtilities(_user);
 service.MaxPollingAttempts = 5;
 service.DownloadClientReport(definition, fileName);


Do you have any idea on this?


Thanks

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups AdWords 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

Re: API v201109: Exception: Report contents are invalid. - !!!2|||-1|||[ReportDefinitionError.CUSTOMER_SERVING_TYPE_REPORT_MISMATCH @ selector]???

2012-02-14 Thread anh khoa nguyen 
Solved, refer to this link:
http://groups.google.com/group/adwords-api/browse_thread/thread/370b561afee3fcec/22ddd5debecac740?lnk=gstq=Report+contents+are+invalid.+-+!!!2|||-1|||[ReportDefinitionError.CUSTOMER_SERVING_TYPE_REPORT_MISMATCH+%40+selector]%3F%3F%3F#22ddd5debecac740





On Feb 14, 4:11 pm, anh khoa nguyen khoacoi1...@gmail.com wrote:
 Hi all,

 I got this exception when trying to download the report: Report
 contents are invalid. - !!!2|||-1|||
 [ReportDefinitionError.CUSTOMER_SERVING_TYPE_REPORT_MISMATCH @
 selector]???

 After researching in forum I found some recommend to using MMC account
 instead of MMCs, I've already account but the exception is still being
 raised,

 Below is my code:

             definition.reportName = reportName;
             definition.reportType =
 ReportDefinitionReportType.ADGROUP_PERFORMANCE_REPORT;
             definition.downloadFormat = DownloadFormat.XML;
             definition.dateRangeType =
 ReportDefinitionDateRangeType.YESTERDAY;

             Selector selector = new Selector();
             selector.fields = new string[] { AccountDescriptiveName,
 ExternalCustomerId, CampaignName, CampaignStatus, AdGroupName,
 Status, AdGroupId, Cost };

             definition.selector = selector;
             definition.includeZeroImpressions = true;

              ReportUtilities service = new ReportUtilities(_user);
              service.MaxPollingAttempts = 5;
              service.DownloadClientReport(definition, fileName);

 Do you have any idea on this?

 Thanks

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups AdWords 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