Re: API developments for Trueview
Still no news unfortunately. -Danial. On Tuesday, January 21, 2014 4:11:31 PM UTC+4, Thomas Meindl wrote: any updates on this? we need to fetch stats through the adwords reporting api for youtube/trueview/video ads.. On Monday, June 24, 2013 1:57:31 PM UTC+2, Danial Klimkin wrote: Hello David, Not yet unfortunately. -Danial, AdWords API Team. On Thursday, June 20, 2013 4:25:34 PM UTC+4, David H wrote: Hi Sorry I know this has been asked before, but I wondered if it was any closer? When will we be able to pull trueview through the API? Or is there an alternative script or automation that can get daily spends? Thanks David -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: The DESTINATION URL REPORT is not returning the actual clicked URL and the KeyWord.
Closing as duplicate of: https://groups.google.com/forum/#!topic/adwords-api/5kmhvJIW_ZQ -Danial. On Wednesday, January 22, 2014 5:29:39 AM UTC+4, Bikram Bhuyan wrote: Hello, For one of our Ad we have defined the destination URL as *http://www.xxx.com/landing/gaw//?mt={matchtype}kw={keyword}cid={creative} http://www.xxx.com/landing/gaw//?mt=%7Bmatchtype%7Dkw=%7Bkeyword%7Dcid=%7Bcreative%7D* and from the adwords screen we see that for the date range of last 1 week, 11 clicks are reported. When I run the report DESTINATION_URL_REPORT I get AdGroupId, CampaignId, EffectiveDestinationUrl Date for that date range. I have couple of question on the report data. Could you please help me in getting some input on this. 1. I see only 7 entries in the report for this URL where as the online adwords report says 11 clicks. 2. The EffectiveDestinationUrl of the report returning the actual URL which was setup. That is *http://www.xxx.com/landing/gaw/ http://www.xxx.com/landing/gaw//?mt={matchtype}kw={keyword}cid={creative}* . 3. I was expecting the actual generated URL like http://www.xxx.com/landing/gaw//?mt=bkw=lead%20generationcid=35078677933gclid=CO313Nuil7sCFUWTfgodu2AA-Q; but it is not the generated URL. If this report does not return this URL then which other report will return this value. I need to know the final generated URL for the performance report of our AD. 4. Also how can I get the Key Word or Criteria which was responsible for this Ad To show up. There might be 10 diff keywords which is responsible for this Ad to show up, but I exactly want to know which keyword was responsible for this clicked AD. I am having a lot of difficulties to find this information from the list of report. If you could help me in identifying the actual report which will return Point 3 and 4 that will be great. I am attaching the sample report which I generated for last 1 week date range in the email for your reference. Thanks, Bikram. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: Cannot upload offline conversions.
Hello, Have you tried pulling the click performance report and comparing strings from it with your URL parameters? If still in doubt, please send me the exact XML request and server response for the error *over email* (reply to author button). -Danial, AdWords API Team. On Tuesday, January 21, 2014 4:03:01 PM UTC+4, tra...@888holdings.com wrote: Hello Daniel, Thanks for the response. The I tried several sources, none of them from the report you mentioned: - from our data warehouse - directly from on of our ads (clicked on an ad and extracted the gclid from the url query string) Could it be some charset encoding issue? What should I try to do? Thanks. On Monday, January 20, 2014 2:19:42 PM UTC+2, Danial Klimkin wrote: Hello, This error means the GLCID string provided is not a valid Google Click ID. Did you get the ID from the CLICK_PERFORMANCE_REPORT? -Danial, AdWords API Team. On Thursday, January 16, 2014 1:05:42 PM UTC+4, moshe@888holdings.comwrote: Hi, We're using the latest Php Api source code example ( */examples/AdWords/v201309/AdvancedOperations/UploadOfflineConversions.php*) to test upload offline conversions, but we keep getting the same error: [OfflineConversionError.UNPARSEABLE_GCLID @ operations[0].operand] The source was downloaded from here: https://github.com/googleads/googleads-php-lib. Why is this happening? lease assist.. Thanks! -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: AdId mismatch in Ad Performance Report
Hello Bikram, The report you are requesting is for date range of Jan 1, 2013-Feb 1, 2013. The ads you are getting back are now deleted and not returned by service by default. You need to either request for current data, or add a predicate to include deleted ads as well. -Danial, AdWords API Team. On Tuesday, January 21, 2014 9:44:51 PM UTC+4, Bikram Bhuyan wrote: Hi Danial, Thanks a lot for your response. When I run my program to fetch the Ads for this group id, I am getting 49 rows returned by query. I am using AWQL and below if the query I am firing. SELECT Id, Url, DisplayUrl, Type, Status WHERE AdGroupId = 1301383813 ORDER BY Id In the output of this result I dont see the following AdIds which are returned by my report service based on my previous email. Could you please suggest what am I doing wrong. These are the ad ids which are returned by the report service where as it is not returned in the above call (3107387353, 3107388613, 3107389063, 18108856933, 18108885133, 1810493) Thanks, Bikram. On Tuesday, January 21, 2014 3:03:03 AM UTC-8, Danial Klimkin wrote: Hello Bikram, What are you comparing these IDs to? I've checked AdGroup 1301383813 and I see ads with the IDs listed under it. -Danial, AdWords API Team. On Saturday, January 18, 2014 5:35:22 AM UTC+4, Bikram Bhuyan wrote: Hello, We are fetching the Stats from the Ad Performance Report based on a particular date range. What we found out is that the output which I got from the report (in XML format) contains AdId which does not exists in the system where as the campaign id and ad group id matches good. I can provide more details if you need by not sure how to validate it. Attached is the sample XML response we got for the Ad Performance Report. Let me know if you need any specific input on our account and I can send you in email. Thanks, Bikram. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: AdWords Ad Details like % Served, Clicks etc... Which API call will return these information.
Hello Bikram, Unfortunately we cannot provide complete solutions as part of answering on the forum. Please check if your requirements can be met with the following report: https://developers.google.com/adwords/api/docs/appendix/reports#destination-url As per value track parameters, they are normally used to track parameters on the web server side. As they are part of the URL you can pull statistics from your web server logs. -Danial, AdWords API Team. On Tuesday, January 21, 2014 9:56:24 PM UTC+4, Bikram Bhuyan wrote: Hi Danial, Thanks a lot for your response. I think I did not mention my requirement clearly. I am calling the Ad Performance Report and getting all the Stats information like Clicks, Impressions etc which are all fine. There are some more information I need to gather for this ad which I am unable to figure out. Say for an ad AD1 I set the value track URL as http://www.example.com/?matchtype={matchtype}*keyword={keyword}*;. So when any particular user clicks on this URL, the final url will be generated as http://www.example.com/?matchtype=XXXkeyword=YYY; and the user will be redirected to this page. I wanted to know for a particular date range, how many users click this URL (the final destination URL) and on what exact time they clicked. I need this for individual ad id. Could you please suggest what exactly I need to do get this information. All other information are I am getting from diff report, but this information I am unable to find out. Thanks, Bikram. On Tuesday, January 21, 2014 2:01:24 AM UTC-8, Danial Klimkin wrote: Hello Bikram, Please check out the reporting reference available here: https://developers.google.com/adwords/api/docs/appendix/reports Note you may need to join several reporting. For example, Ad IDs are available with Id field of Ad Performance Report, matched keywords as KeywordText of Keywords Performance Report. Date can be added with Date field available for the most of the reports. -Danial, AdWords API Team. On Tuesday, January 21, 2014 5:48:37 AM UTC+4, Bikram Bhuyan wrote: Hi Danial, I am working on this report now. But I don't get the below information from this report. 1. Ad Id (It return only Campaign Id and Group Id, But not Ad Id). 2. Final Destination URL (the url generated with all the ValueTrack parameters added). Not sure which column will return this. 3. Keywords which triggered the ad to show up. 4. Date on which the URL was clicked by the user. Could you please let me know if any other report might give these information? I need to group the result at ad level. So I need the AdId and the Date on which the link was clicked for our report. Thanks, Bikram. On Tuesday, November 26, 2013 1:54:50 AM UTC-8, Danial Klimkin wrote: Hello Bikram, 1. Free search links will not be logged in AdWords, so all impressions / clicks returned is the AdWords Ads data. You can use ValueTrack parameters to obtain more information about the click: https://support.google.com/adwords/answer/2375447 2. See the destination URL report: https://developers.google.com/adwords/api/docs/appendix/reports#destination-url It has AdGroupId / CampaignId columns that can be used to join data with other reports. -Danial, AdWords API Team. On Tuesday, November 26, 2013 3:48:56 AM UTC+4, Bikram Bhuyan wrote: Hi Danial, Thanks a lot the information. Based on your details I went through all the available reports and found out the data that is returned by the reporting APIs. However there are some data requirements for out project I am yet to find the information. I might be missing these details, but if you could point me to the specific report which might return the information. 1. When the person click on the link from the Ad-words ad link, how do I know if that page is referred from the AdWords ad link, Not from the free search link. Here I am interested to know - The URL of the page associated with the ad link click. - How do I distinguish from my page that this page is called from the AdWords link click. Not from the free search either from Google search (not adwords link click) or any other search engine click. - What are the information being passed in the URL to our landing page, to know that it is coming from the AdWords search click. 2. Which report can return the associated landing page URL for each search criteria for a particular ad. Thanks, Bikram. On Monday, November 11, 2013 7:29:24 AM UTC-8, Danial Klimkin wrote: Hello Bikram, You need to use AdWords API Reporting to access this data. See: https://developers.google.com/adwords/api/docs/guides/reporting https://developers.google.com/adwords/api/docs/guides/reporting-concepts -Danial, AdWords API Team. On Friday, November 8, 2013 11:34:44 PM UTC+4, Bikram Bhuyan wrote: Hello, Could you please let me know
Re: Permission problem
Hello, It looks like you've authorized as the developer. Normally, you log in as developer user when generate client ID and client secret. Please make sure to log off and log in as the AdWords user when generating OAuth2 credentials. -Danial, AdWords API Team. On Sunday, January 19, 2014 10:44:38 PM UTC+4, skat...@yahoo.com wrote: Im using a production MCC account's developer token with billing setup and accepted the ToS. Im trying to mange with this dev token a Test Client under a Test MCC account. Im using the client_id and client_secret of the test MCC and Im setting the customer_id with SetClientId to the Test Client's customer id. I succesfully get an access token and a refresh token. But whenever I try to do something with the API (eg GetService) I get the error: An error has occurred: [AuthorizationError.USER_PERMISSION_DENIED @ ; trigger:''] . Do you have any idea why this is happening? Ive read somewhere that I need ssl activated on my domain to use the adwords API. Do you think this is the problem's source? btw Im using v201309 of the php library. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: Get Location Extension Report
Thanks by the answer! On Monday, January 20, 2014 10:24:07 AM UTC-2, Danial Klimkin wrote: Hello Sidnei, Location extensions have not yet been replaced with feeds-based ones. They should still show up in the legacy report. Social extensions are not yet supported. -Danial, AdWords API Team. On Friday, January 17, 2014 5:30:16 PM UTC+4, Sidnei Pereira wrote: I saw at the following page of the AdWords documentation, that the AD_EXTENSIONS_PERFORMANCE_REPORT will bring only legacy campaign extensions[1]. It also says that to use upgraded extensions I've to use the PLACEHOLDER_FEED_ITEM_REPORT, but this last report type doesn't has the option to choice the Location Extension. As shown in the second link[2], the avaible types are only: SITELINKS, CALL and APP. I now that Social Extension isn't supported yet as were declared, but that is the same for Location Extension or there's such a way to get it? If not, there will be somehow? [1]https://developers.google.com/adwords/api/docs/appendix/reports#ad-extensionshttps://developers.google.com/adwords/api/docs/appendix/reports#ad-extensions [2]https://developers.google.com/adwords/api/docs/appendix/placeholdershttps://developers.google.com/adwords/api/docs/appendix/placeholders Thanks in advance! --- Att, Sidnei Pereira System Analyst/Developer at dp6 http://www.dp6.com.br sidnei@dp6.com.br -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: problem displaying the right MaxCPC
Hi, I see that you are creating a *Cpm*Bid but your campaign's bidding scheme is MANUAL_*CPC*. If you change your bid to a CpcBid then you should see your changes applied as expected. Per the BiddingStrategyConfiguration documentationhttps://developers.google.com/adwords/api/docs/reference/v201309/AdGroupService.BiddingStrategyConfiguration, only bids that apply to the campaign's bidding strategy (MANUAL_CPC in this case) will be used. Thanks, Josh, AdWords API Team On Sunday, January 19, 2014 6:17:40 PM UTC-5, karima Mechergui wrote: Hi Team, I have to see the right *max cpc* in my ads adgroup,*it is always € 0.01 instead of € 0.79.* So i use php API google adwords version v201309, here are my code: $campaignId = '62349681'; $adGroupService = $user-GetService('AdGroupService', ADWORDS_VERSION); $numAdGroups = 0; $operations = array(); $adGroup = new AdGroup(); $adGroup-campaignId = $campaignId; $adGroup-name = 'Livre'; // Set bids (required). $bid = new CpmBid(); *$bid-bid = new Money(79);* $biddingStrategyConfiguration = new BiddingStrategyConfiguration(); $biddingStrategyConfiguration-bids[] = $bid; $adGroup-biddingStrategyConfiguration = $biddingStrategyConfiguration; // Set additional settings (optional). $adGroup-status = 'ENABLED'; // Create operation. $operation = new AdGroupOperation(); $operation-operand = $adGroup; $operation-operator = 'ADD'; $operations[] = $operation; //} // Make the mutate request. $result = $adGroupService-mutate($operations); // Display result. $adGroups = $result-value; foreach ($adGroups as $adGroup) { printf(Ad group with name '%s' and ID '%s' was added.\n, $adGroup-name, $adGroup-id); } Thank you a lot for your help -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: Creating a MCC test account.
Hi, Yes - the resolved link looks right - once created a new account it should be the test MCC account. Thanks! -- Ray Tsang (AdWords API Advisor) On Tuesday, January 21, 2014 3:20:49 PM UTC-5, Adwords Test wrote: Hello, Sorry for the delay. So I attempted to create a new test account using the same link, it seems to redirect me to this new page ( https://accounts.google.com/ServiceLogin?service=adwordshl=en-USltmpl=signuppassive=falseifr=falsealwf=truecontinue=https://adwords.google.com/um/MccSignupToken?testAccount%3Dtrueapp=MccSignupsacu=1sourceid=awosubid=ww-en-et-awhp_nelsontest_con ) and that has no indication of any test account being created. This was after I logged out from this current account. Should I go ahead with the account creation process? Thanks, Toan On Friday, January 17, 2014 1:54:12 PM UTC-6, Ray Tsang (AdWords API Team) wrote: Hi, Could I trouble you to create a new test account with the same link? As you create the account, please make sure you are logged out and you may need to use a different email address than this one. Thanks! -- Ray Tsang (AdWords API Advisor) On Thursday, January 16, 2014 1:07:13 PM UTC-5, Adwords Test wrote: Thank you for your response. I don't see any red banner or any other indications that the account is a test one. The account log in is my current email address. On Wednesday, January 15, 2014 6:26:06 PM UTC-6, Ray Tsang (AdWords API Team) wrote: Hi, The test account creation steps may look very similar to a live account creation. However, after you've created the test account and logged in - you should notice a red banner on the top right hand corner indicating that the MCC account is a test account. Please let me know if this isn't the case. Thanks! -- Ray Tsang (AdWords API Advisor) On Tuesday, January 14, 2014 12:32:16 PM UTC-5, Adwords Test wrote: Hello, I follow this page ( https://developers.google.com/adwords/api/docs/test-accounts) to create a MCC test account. But the given link ( https://adwords.google.com/um/StartNewMccAccount?testAccount=true) takes me to another page which creates a live account. Any ideas what I've done wrong here? Thanks! -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: Data Mismatch Between GEO_PERFORMANCE_REPORT and CLICK_PERFORMANCE_REPORT
Hi, I ran both reports for your campaign and adgroup and I verified there are some differences between the two, specifically on the *Metro area* and *City* fields. We're looking into this and I will post back when I have an update. One thing to note is that the Geo Performance Report also includes impressions, so when testing I included a *Predicate* that filtered to *Clicks 0*. With that filter in place I was able to tie the # of clicks between the two reports and identify the rows with mismatched values. As mentioned previously, there is currently an issue with the Ad ID (AdGroupCreativeId) in the Click Performance Report. As a result, the ID returned will not tie back to Ad ID values in other reports. We're aware of this one as well and are working on it. Best regards, Josh, AdWords API Team On Saturday, January 4, 2014 6:16:02 AM UTC-5, Ittai Chorev wrote: Hi, We've also seen this problem and have posted about it a few months ago: https://groups.google.com/d/msg/adwords-api/faoaijq2xjo/9lmhrWiYoUAJ The Click Performance Report reports incorrect Geos and incorred AdGroupCreativeId. I think it would be a good idea to note the bug in the documentation if there's no plan on fixing it soon. It's a pity that we're all wasting time on known bugs. (Of course actually fixing it would be a lot more preferable!) Ittai On Friday, January 3, 2014 5:33:28 PM UTC+2, Josh Radcliff (AdWords API Team) wrote: Hi, Could you send over the reporting requests you are using for each of the reports (please make sure to remove any sensitive data such as refresh or access tokens, client secret, etc.). It would also help to know the customer ID of the accounts you are querying. You can send this *only to me* by clicking *Reply to author*. Thanks, Josh, AdWords API Team On Thursday, December 26, 2013 5:30:25 AM UTC-5, Hazar Hayat wrote: I am using GoogleClickID from CLICK_PERFORMANCE_REPORT to get my user locations against the revenue. I am using GEO_PERFORMANCE_REPORT to get clicks and cost data on user locations. I am using the following query to join both the reports. select a.ClientID,a.CampaignID,a.AdGroupID,a.Country,a.Metro,a.Region,a.City,b.Country,b.Metro,b.Region,b.City from GEO_PERFORMANCE_REPORT a join CLICK_PERFORMANCE_REPORT b on a.ClientID=b.ClientID and a.CampaignID=b.CampaignID and a.AdGroupID=b.AdGroupID and a.Country=b.Country and a.Metro=b.Metro and a.Region=b.Region and a.City=b.City where Clicks0 After reviewing the results i see that some clicks data from GEO_PERFORMANCE_REPORT is missing in the CLICK_PERFORMANCE_REPORT. For example for ClientId=xxx and CampaignId=yyy and AdgroupId=zzz we have the following data in the GEO_PERFORMANCE_REPORT Day ClientId CampaignId AdgroupId Country Metro Region City Clicks 12/10/2013 0:00 xxx yyy zzz United States Arizona Tucson 1 And for the same ad group we have the following data in the CLICK_PERFORMANCE_REPORT. Day ClientId CampaignId AdgroupId Country Metro Region City 12/10/2013 0:00 xxx yyy zzz United States Minnesota Unspecified Is there any reason why all clicks data is not present in the CLICK_PERFORMANCE_REPORT or there is any mismatch in the location data of the both the reports. Thanks Regards -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: AdId mismatch in Ad Performance Report
Hi Danial, Thanks a lot for the response. I wanted to match my report with the report information which are shown in the google adwords UI screens. I guess the UI must not be showing the deleted ads I guess. If this is the case could you please let me know how to exclude the deleted ads (current data) from the AD_PERFORMANCE_REPORT. From my observation I see that Ad Performance report is returning deleted ads by default where as GetAd calls does not. I wanted to sync the data with respect to google adwords UI. So please suggest what should I do now. Thanks, Bikram, On Wednesday, January 22, 2014 3:20:44 AM UTC-8, Danial Klimkin wrote: Hello Bikram, The report you are requesting is for date range of Jan 1, 2013-Feb 1, 2013. The ads you are getting back are now deleted and not returned by service by default. You need to either request for current data, or add a predicate to include deleted ads as well. -Danial, AdWords API Team. On Tuesday, January 21, 2014 9:44:51 PM UTC+4, Bikram Bhuyan wrote: Hi Danial, Thanks a lot for your response. When I run my program to fetch the Ads for this group id, I am getting 49 rows returned by query. I am using AWQL and below if the query I am firing. SELECT Id, Url, DisplayUrl, Type, Status WHERE AdGroupId = 1301383813 ORDER BY Id In the output of this result I dont see the following AdIds which are returned by my report service based on my previous email. Could you please suggest what am I doing wrong. These are the ad ids which are returned by the report service where as it is not returned in the above call (3107387353, 3107388613, 3107389063, 18108856933, 18108885133, 1810493) Thanks, Bikram. On Tuesday, January 21, 2014 3:03:03 AM UTC-8, Danial Klimkin wrote: Hello Bikram, What are you comparing these IDs to? I've checked AdGroup 1301383813 and I see ads with the IDs listed under it. -Danial, AdWords API Team. On Saturday, January 18, 2014 5:35:22 AM UTC+4, Bikram Bhuyan wrote: Hello, We are fetching the Stats from the Ad Performance Report based on a particular date range. What we found out is that the output which I got from the report (in XML format) contains AdId which does not exists in the system where as the campaign id and ad group id matches good. I can provide more details if you need by not sure how to validate it. Attached is the sample XML response we got for the Ad Performance Report. Let me know if you need any specific input on our account and I can send you in email. Thanks, Bikram. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: AdWords Ad Details like % Served, Clicks etc... Which API call will return these information.
Hi Danial, I checked the output of the report DESTINATION_URL_REPORT and the url that is returned by the report is with the value track (i.e - http://www.example.com/?matchtype={matchtype}*keyword={keyword}*;). Not the actual clicked generated URL (http://www.example.com/?matchtype=XXX keyword=YYY). I wanted to know does any of the report return the generated URL. If I can not get this information from any of the report then we need to change our design accordingly. I am unable to find this information from all the report definitions. Thanks, Bikram. On Wednesday, January 22, 2014 3:24:31 AM UTC-8, Danial Klimkin wrote: Hello Bikram, Unfortunately we cannot provide complete solutions as part of answering on the forum. Please check if your requirements can be met with the following report: https://developers.google.com/adwords/api/docs/appendix/reports#destination-url As per value track parameters, they are normally used to track parameters on the web server side. As they are part of the URL you can pull statistics from your web server logs. -Danial, AdWords API Team. On Tuesday, January 21, 2014 9:56:24 PM UTC+4, Bikram Bhuyan wrote: Hi Danial, Thanks a lot for your response. I think I did not mention my requirement clearly. I am calling the Ad Performance Report and getting all the Stats information like Clicks, Impressions etc which are all fine. There are some more information I need to gather for this ad which I am unable to figure out. Say for an ad AD1 I set the value track URL as http://www.example.com/?matchtype={matchtype}*keyword={keyword}*;. So when any particular user clicks on this URL, the final url will be generated as http://www.example.com/?matchtype=XXXkeyword=YYY; and the user will be redirected to this page. I wanted to know for a particular date range, how many users click this URL (the final destination URL) and on what exact time they clicked. I need this for individual ad id. Could you please suggest what exactly I need to do get this information. All other information are I am getting from diff report, but this information I am unable to find out. Thanks, Bikram. On Tuesday, January 21, 2014 2:01:24 AM UTC-8, Danial Klimkin wrote: Hello Bikram, Please check out the reporting reference available here: https://developers.google.com/adwords/api/docs/appendix/reports Note you may need to join several reporting. For example, Ad IDs are available with Id field of Ad Performance Report, matched keywords as KeywordText of Keywords Performance Report. Date can be added with Date field available for the most of the reports. -Danial, AdWords API Team. On Tuesday, January 21, 2014 5:48:37 AM UTC+4, Bikram Bhuyan wrote: Hi Danial, I am working on this report now. But I don't get the below information from this report. 1. Ad Id (It return only Campaign Id and Group Id, But not Ad Id). 2. Final Destination URL (the url generated with all the ValueTrack parameters added). Not sure which column will return this. 3. Keywords which triggered the ad to show up. 4. Date on which the URL was clicked by the user. Could you please let me know if any other report might give these information? I need to group the result at ad level. So I need the AdId and the Date on which the link was clicked for our report. Thanks, Bikram. On Tuesday, November 26, 2013 1:54:50 AM UTC-8, Danial Klimkin wrote: Hello Bikram, 1. Free search links will not be logged in AdWords, so all impressions / clicks returned is the AdWords Ads data. You can use ValueTrack parameters to obtain more information about the click: https://support.google.com/adwords/answer/2375447 2. See the destination URL report: https://developers.google.com/adwords/api/docs/appendix/reports#destination-url It has AdGroupId / CampaignId columns that can be used to join data with other reports. -Danial, AdWords API Team. On Tuesday, November 26, 2013 3:48:56 AM UTC+4, Bikram Bhuyan wrote: Hi Danial, Thanks a lot the information. Based on your details I went through all the available reports and found out the data that is returned by the reporting APIs. However there are some data requirements for out project I am yet to find the information. I might be missing these details, but if you could point me to the specific report which might return the information. 1. When the person click on the link from the Ad-words ad link, how do I know if that page is referred from the AdWords ad link, Not from the free search link. Here I am interested to know - The URL of the page associated with the ad link click. - How do I distinguish from my page that this page is called from the AdWords link click. Not from the free search either from Google search (not adwords link click) or any other search engine click. - What are the information being passed in the URL to
Re: How to get report data for multiple client accounts in single report?
Ok. Thanks for reply. On Monday, January 20, 2014 4:35:11 AM UTC-8, Danial Klimkin wrote: Hello Tom, Any API request can be executed against one account only. To get a report for multiple accounts, run one for each of them and combine them on your side. -Danial, AdWords API Team. On Friday, January 17, 2014 12:23:03 AM UTC+4, Tom wrote: Hi All, I want to download the report for all my clients in single request. I have specified clientCustomerId for one of the client in ads.properties file. Is there any way to specify the parameter clientCustomerId for more than one client id? If not, whats is the workaround for this? Any help is appricated ! Thanks ! -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: Get the Keyword Stats
Ok. Thanks for reply. On Tuesday, January 14, 2014 4:08:16 PM UTC-8, Tom wrote: Hi All, How can I get the keyword level stats like Max.CPC, clicks,cost etc? I don't want to download the report as I want to add few more of my fields. I tried it using 'GetKeyword' but it does not list clicks/costs at keyword level. Please let me know which class (as I am using Java API ) to use for it ? Thanks for help ! - Tom -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Search Query Performance Report
I noticed that the Search Query Performance Report does not have a field that indicates if a search query is ADDED, EXCLUDED or NONE (neither added nor excluded). Is that by design? Is there a workaround for me to get this data as part of this report or from another source and do a join? Thanks. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: Creating a MCC test account.
Just to confirm: I was able to create a test MCC account using a brand new email address. Don't know what went wrong the last 2 times I did it. Thanks again! On Wednesday, January 22, 2014 10:50:18 AM UTC-6, Ray Tsang (AdWords API Team) wrote: Hi, Yes - the resolved link looks right - once created a new account it should be the test MCC account. Thanks! -- Ray Tsang (AdWords API Advisor) On Tuesday, January 21, 2014 3:20:49 PM UTC-5, Adwords Test wrote: Hello, Sorry for the delay. So I attempted to create a new test account using the same link, it seems to redirect me to this new page ( https://accounts.google.com/ServiceLogin?service=adwordshl=en-USltmpl=signuppassive=falseifr=falsealwf=truecontinue=https://adwords.google.com/um/MccSignupToken?testAccount%3Dtrueapp=MccSignupsacu=1sourceid=awosubid=ww-en-et-awhp_nelsontest_con ) and that has no indication of any test account being created. This was after I logged out from this current account. Should I go ahead with the account creation process? Thanks, Toan On Friday, January 17, 2014 1:54:12 PM UTC-6, Ray Tsang (AdWords API Team) wrote: Hi, Could I trouble you to create a new test account with the same link? As you create the account, please make sure you are logged out and you may need to use a different email address than this one. Thanks! -- Ray Tsang (AdWords API Advisor) On Thursday, January 16, 2014 1:07:13 PM UTC-5, Adwords Test wrote: Thank you for your response. I don't see any red banner or any other indications that the account is a test one. The account log in is my current email address. On Wednesday, January 15, 2014 6:26:06 PM UTC-6, Ray Tsang (AdWords API Team) wrote: Hi, The test account creation steps may look very similar to a live account creation. However, after you've created the test account and logged in - you should notice a red banner on the top right hand corner indicating that the MCC account is a test account. Please let me know if this isn't the case. Thanks! -- Ray Tsang (AdWords API Advisor) On Tuesday, January 14, 2014 12:32:16 PM UTC-5, Adwords Test wrote: Hello, I follow this page ( https://developers.google.com/adwords/api/docs/test-accounts) to create a MCC test account. But the given link ( https://adwords.google.com/um/StartNewMccAccount?testAccount=true) takes me to another page which creates a live account. Any ideas what I've done wrong here? Thanks! -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out.
AD_PERFORMANCE_REPORT Date Range Query Help Needed.
Hello Guys, We are currently making call to Ad Performance Report to fetch the stats. Our application runs daily and during the initial load of the application (when the application goes live for the first time) I need to fetch the stats for last 1 year for each day and store it. Going forward I can fetch the data for last 24 hours and populate it. I was testing the data from the report and I see some mismatch. So I am guessing I am not passing the right date parameters to the report. Could you please help me in point out the issues if any? When I am fetching the data for last 7 days (today's date is 22nd Jan) I am passing the date range as DURING 20140115, 20140121. So this report is fetching the data from 15th till 21st. This report returns 10 clicks. 1. When I am fetching the data for 15th Jan I am using DURING 20140115, 20140116 and clicks are returned as - 3. 2. When I am fetching the data for 16th Jan I am using DURING 20140116, 20140117 and clicks are returned as - 4. 3. When I am fetching the data for 17th Jan I am using DURING 20140117, 20140118 and clicks are returned as - 3. 4. When I am fetching the data for 18th Jan I am using DURING 20140118, 20140119 and clicks are returned as - 2. 5. When I am fetching the data for 19th Jan I am using DURING 20140119, 20140120 and clicks are returned as - 4. 6. When I am fetching the data for 20th Jan I am using DURING 20140120, 20140121 and clicks are returned as - 3. 7. When I am fetching the data for 21th Jan I am using DURING 20140121, 20140122 and clicks are returned as - 0. If we sum all the clicks the count is coming as 19 where as the last 1 week data is returning 10. Not sure where I am doing wrong. As there is no timestamp in the data field I am not sure if I need to fetch the data for a particular day what value should I pass in the during clause. Please help me in this providing some details. For your reference I am attaching all the XML output for all the individial date range as well as for last 7 days. Thanks, Bikram. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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 --- 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. For more options, visit https://groups.google.com/groups/opt_out. AdPerformance-35078677933-20 TO 21.xml Description: XML document AdPerformance-35078677933-19 TO 20.xml Description: XML document AdPerformance-35078677933-18 TO 19.xml Description: XML document AdPerformance-35078677933-17 TO 18.xml Description: XML document AdPerformance-35078677933-16 TO 17.xml Description: XML document AdPerformance-35078677933-15 TO 16.xml Description: XML document AdPerformance-35078677933-Last7Days (15 TO 21).xml Description: XML document
TokenResponseException
Hi, We are using the Java client libraries to access the AdWords API. Lately we have started to get this kind of errors: Caused by: java.lang.reflect.UndeclaredThrowableException at $Proxy218.get(Unknown Source) at com.keybroker.services.publish.google.GoogleDownloadCampaignBudgetService$2.call(GoogleDownloadCampaignBudgetService.java:66) at com.keybroker.services.publish.google.GoogleDownloadCampaignBudgetService$2.call(GoogleDownloadCampaignBudgetService.java:63) at com.keybroker.services.GoogleSoapDownloadService$1.call(GoogleSoapDownloadService.java:32) at com.keybroker.services.GoogleSoapDownloadVisitorService$1.doRetryingSoapCall(GoogleSoapDownloadVisitorService.java:35) at com.keybroker.services.GoogleSoapDownloadVisitorService$1.doRetryingSoapCall(GoogleSoapDownloadVisitorService.java:33) at com.keybroker.util.SoapCallerImpl.executeWithExceptionHandler(SoapCallerImpl.java:38) ... 26 more Caused by: com.google.api.ads.common.lib.exception.OAuthException: OAuth2 token could not be refreshed. at com.google.api.ads.common.lib.auth.AuthorizationHeaderProvider.getOAuth2Header(AuthorizationHeaderProvider.java:104) at com.google.api.ads.common.lib.auth.AuthorizationHeaderProvider.getAuthorizationHeader(AuthorizationHeaderProvider.java:77) at com.google.api.ads.common.lib.soap.AuthorizationHeaderHandler.setAuthorization(AuthorizationHeaderHandler.java:63) at com.google.api.ads.adwords.axis.AdWordsAxisHeaderHandler.setAuthenticationHeaders(AdWordsAxisHeaderHandler.java:125) at com.google.api.ads.adwords.axis.AdWordsAxisHeaderHandler.setHeaders(AdWordsAxisHeaderHandler.java:90) at com.google.api.ads.adwords.axis.AdWordsAxisHeaderHandler.setHeaders(AdWordsAxisHeaderHandler.java:1) at com.google.api.ads.common.lib.client.AdsServiceClient.setHeaders(AdsServiceClient.java:111) at com.google.api.ads.common.lib.soap.SoapServiceClient.invoke(SoapServiceClient.java:92) ... 33 more Caused by: com.google.api.client.auth.oauth2.TokenResponseException: 403 Forbidden !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd;htmlheadtitleGoogle-konton/titlemeta http-equiv=content-type content=text/html; charset=utf-8meta http-equiv=X-UA-Compatible content=IE=edge /meta name=viewport content=width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1, user-scalable=0 /link rel='stylesheet' type='text/css' href='https://ssl.gstatic.com/accounts/o/1893590695-error_page_css_ltr.css' script type=text/javascript src=https://ssl.gstatic.com/accounts/o/4240385162-common_lib.js;/script style@media screen and (max-width:500px) {#robot {background: none; min-height: 0; min-width: 0; padding: 0;}#stack_trace {display: none;}} #oauth2_request_info_header {background-image: url(https://ssl.gstatic.com/accounts/o/blank.gif;);}/style/headbody div id=robot/diva href=//www.google.com/ id=googlelogoimg src=//www.google.com/images/logo_sm.gif alt=Google/ap class=largeb403./b insDet har uppstått ett fel./ins/pp class=largeDu har inte behörighet att göra den här begäran. insDet är allt vi vet./ins/p/body/html at com.google.api.client.auth.oauth2.TokenResponseException.from(TokenResponseException.java:105) at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:287) at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307) at com.google.api.client.auth.oauth2.Credential.executeRefreshToken(Credential.java:570) at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489) at com.google.api.ads.common.lib.auth.OAuth2Helper.callRefreshToken(OAuth2Helper.java:70) at com.google.api.ads.common.lib.auth.OAuth2Helper.refreshCredential(OAuth2Helper.java:56) at com.google.api.ads.common.lib.auth.AuthorizationHeaderProvider.getOAuth2Header(AuthorizationHeaderProvider.java:102) ... 40 more If the user does a manual re-authentication, i.e requests a new access-token, it works until it is time to refresh it. We've had similar problems before, but in those cases it was a Rate Limit Exceeded that caused the TokenResponseException. This cause looks a bit strange as it returns 403 Forbidden. Any idea what's going on? Regards Magnus Ljung -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.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