Re: Adwords API calls using VBA possible? if Yes could you please send me a sample http request format to pull a report.

2015-12-16 Thread shreedhar . bakale
Hi Mike,


Thank you mike.  Yup its seems like report headers are not correct.

Please tell me *what is User-Agent?*

I got rest of the parameters. 


Regards,
Shreedhar


On Wednesday, December 16, 2015 at 7:46:19 PM UTC+5:30, Michael Cloonan 
(AdWords API Team) wrote:
>
> Hello,
>
> Based on the error message, it seems like you may not be setting your HTTP 
> headers correctly, even if the XML is valid. Here's an example of what a 
> set of valid HTTP headers looks like, in addition to a valid report request 
> XML:
>
> Report request to: '
>> https://adwords.google.com/api/adwords/reportdownload/v201509'
>> HTTP headers: [Content-Type: application/x-www-form-urlencoded, 
>> Authorization: [REDACTED], User-Agent: [REDACTED], clientCustomerId: 
>> [REDACTED], developerToken: [REDACTED], skipReportHeader: false, 
>> skipReportSummary: false, skipColumnHeader: false, includeZeroImpressions: 
>> false]
>> 
>>   
>> CampaignId
>> AdGroupId
>> Id
>> Criteria
>> CriteriaType
>> FinalUrls
>> Impressions
>> Clicks
>> Cost
>> 
>>   Status
>>   IN
>>   ENABLED
>>   PAUSED
>> 
>>   
>>   Last+7+days+CRITERIA_PERFORMANCE_REPORT
>>   CRITERIA_PERFORMANCE_REPORT
>>   LAST_7_DAYS
>>   CSV
>> 
>
>
> You need to specify the Authorization, User-Agent, clientCustomerId, and 
> developerToken headers in order for the request to work. If you do not have 
> these, you can use the Get Started guide 
>  to learn 
> more. This guide will help you set up all of those pieces of data except 
> the access token. Instead, it will set you up with a refresh token, which 
> can be used to generate access tokens. Our OAuth 2.0 guide also has 
> instructions for how to generate an access token from a refresh token 
> 
> .
>
> Once you get this all set up, please give it another try. If it fails 
> again, please include both the HTTP request headers and body in the log so 
> that I can make sure that everything is present.
>
> Regards,
> Mike, AdWords API Team
>
> On Wednesday, December 16, 2015 at 2:05:13 AM UTC-5, 
> shreedha...@accenture.com  wrote:
>>
>> Hello Mike,
>>
>> *Please find attached xml attached.*
>>
>> I need one help can you* please share sample HTTP request of Dot Net 
>> code for pulling a report from API with sample XML file*. I will try 
>> following that format to VBA Excel and try again.
>>
>>
>> *The error message is as below:*
>> *> standalone="yes"?>ReportDownloadError.MISSING_PARAMETERMissing
>>  
>> report 
>> definitionReportDownloadError.INVALID_PARAMETERMissing
>>  
>> client 
>> information*
>>
>>
>>
>> Regards,
>> Shreedhar
>>
>> On Tuesday, December 15, 2015 at 9:59:35 PM UTC+5:30, Michael Cloonan 
>> (AdWords API Team) wrote:
>>>
>>> Hello,
>>>
>>> Our .NET client library 
>>>  does support VB, 
>>> although I'm not sure if that's quite the same as using VBA from excel.
>>>
>>> However, a client library is not required if you formulate your request 
>>> correctly. Can you please log the full XML, rather than showing the code 
>>> that generates the XML, because then it would be easy to take a look and 
>>> see where the formatting you're using may differ from the correct 
>>> formatting that would result in a successful request.
>>>
>>> Regards,
>>> Mike, AdWords API Team
>>>
>>> On Tuesday, December 15, 2015 at 9:16:45 AM UTC-5, 
>>> shreedha...@accenture.com wrote:

 Hi Team,

 I am trying to pull a report from Adwords by API calls using *Excel 
 VBA with Windows HTTP request.*
 But I am arriving at below error:

 *>>> standalone="yes"?>ReportDownloadError.MISSING_PARAMETERMissing
  
 report 
 definitionReportDownloadError.INVALID_PARAMETERMissing
  
 client 
 information*


 and the code i tried as below


 Sub TestAPI()


 Dim objHTTP As Object
 Dim result As String
 Dim Xml As Variant
 Dim Fs As FileSystemObject
 Dim FileData() As Byte
 Dim Arr() As String
 Dim St As String

Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
URL = "https://adwords.google.com/api/adwords/reportdownload/v201509
 "

objHTTP.Open "POST", URL, False

objHTTP.setRequestHeader "Authorization", "Bearer 3756320"
objHTTP.setRequestHeader "DEVELOPER_TOKEN", "NegtkJjSr7jcrQSdeI4Nzg"
objHTTP.setRequestHeader "CLIENT_CUSTOMER_ID", "328-664-6765"

'objHTTP.RequestBody "__rdxml", Xml

'  Set Fs = New FileSystemObject
   'Set Xml = Fs.OpenTextFile("C:\Users\ajkumar\Desktop\Shreedhar\New 
 Text Document.xml")

'St = Xml.ReadAll
' "Id" & _

   ' "" & _
   "Status" & _
   "IN" & _
   "ENABLED" & _

Re: What happens if you enter a negative keyword with brackets and set it to broad match?

2015-12-16 Thread starrychloe S.
That totally did not answer my question. I don't know what the point of 
reiterating it is since the original is above, but what happens if you use 
both brackets and have broad match selected?


On Wednesday, December 16, 2015 at 12:31:08 PM UTC-5, Umesh Dengale wrote:
>
> Hello,
>
> When you add a negative keyword with brackets, it added as exact match 
> negative keyword. (e.g. -[women's hat]). You could add the exact match 
> negative keyword to prevent your ad from showing to people who searched for 
> that exact keyword. 
>
> With *broad match*, your ad may show if a search term contains your 
> keyword terms in any order, and possibly along with other terms. Your ads 
> can also show for close variations of your keywords. With *exact match*, 
> your ads can appear only when someone searches for your exact keyword, 
> without any other terms in the search.
>
> Please check out the Using keyword matching options 
>  document for 
> more details.
>
> Thanks,
> Umesh, AdWords API Team.
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/6f47c9b7-aaa9-4892-b073-377251229ae2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: ADD ExpressionRuleUserList OPERATION_NOT_SUPPORTED

2015-12-16 Thread ralph
Awesome!  Thanks for the in line edits!!  That really helps to clear things 
up for me.  I will work on this later today or tomorrow and get back to you 
with my success or next error message, ha ha.
--Ralph

On Wednesday, December 16, 2015 at 7:01:17 AM UTC-8, Michael Cloonan 
(AdWords API Team) wrote:
>
> Hello,
>
> Rather than have a tag , you should have  xsi:type="ExpressionRuleUserList">. The fields for the 
> ExpressionRuleUserList go directly within the operand. Similarly, instead 
> of , you should have , and 
> then the StringRuleItem attributes go directly within the  tag. Just 
> to make it cleaner, you should also remove the  altogether, rather than 
> specifying it as nil.
>
> I am confused about why you're getting an error pointing to the operator, 
> but hopefully cleaning up the operand to have the correct format by 
> following the instructions above will fix it anyway.
>
> Just to be clear, the SOAP body you posted most recently, with 
> corrections, should look like this:
>
>  
>   https://adwords.google.com/api/adwords/rm/v201509";>
>  
> ADD
> 
>Woopra Label: test-label-Id
>test-label-Id
>
>   
>  
> Woopra_Label-test-label-Id
> EQUALS
> true
>  
>   
>
> 
>  
>   
>
>
> Regards,
> Mike, AdWords API Team
>
>
> On Wednesday, December 16, 2015 at 2:28:48 AM UTC-5, ra...@woopra.com 
>  wrote:
>>
>> Ok I have tried probably 30 combinations now.  I still get the same 
>> error: 
>>
>> `[OperatorError.OPERATOR_NOT_SUPPORTED @ operations[0], 
>> RequiredError.REQUIRED @ operations[0].operator]`
>>
>> Unless I mess up the whole operation in which case it adds to the errors 
>> list: `RequiredError.REQUIRED @ operations[0].operand` Which happens when I 
>> try and wrap the operator/operand pair in another object like 
>> "UserListOperation"
>> So what this means to me is that the operand is not being read correctly.
>>
>> I'm not sure exactly what you meant by "You need to use the 
>> ExpressionRuleUserList 
>> 
>>  to 
>> add the RuleItem 
>> 
>>  instead 
>> of the RuleBasedUserList 
>> ."
>>  
>> Perhaps you can make your suggestions directly on the xml that I send so 
>> that i can figure out how to get that output from my soap client?  But 
>> since no matter what I do to the operand the error says the same thing 
>> about the operator, I feel like there is something wrong there.  should it 
>> be literally "" or "ADD" or what?  There isn't much room to play 
>> with the operator though...that's the flaw in my theory. :)
>>
>> Here's just the body of a cleaner attempt:
>>
>>  
>>   https://adwords.google.com/api/adwords/rm/v201509";>
>>  
>> ADD
>> 
>>
>>   
>>   Woopra Label: test-label-Id
>>   test-label-Id
>>   
>>  
>> 
>>
>>   Woopra_Label-test-label-Id
>>   EQUALS
>>   true
>>
>> 
>>  
>>   
>>
>> 
>>  
>>   
>>
>>
>>
>>
>> Thanks again
>> --Ralph
>>
>>
>> On Tuesday, December 15, 2015 at 9:33:57 AM UTC-8, Umesh Dengale wrote:
>>>
>>> Hi Ralph,
>>>
>>> Thanks for providing the SOAP XML request. The RuleItem is associated 
>>> with DateSpecificRuleUserList 
>>> 
>>>  and ExpressionRuleUserList 
>>> .
>>>  
>>> You need to use the ExpressionRuleUserList 
>>> 
>>>  to 
>>> add the RuleItem 
>>> 
>>>  instead 
>>> of the RuleBasedUserList 
>>> 
>>> .
>>> I will submit a feature request for node/js client library.
>>>
>>> Thanks,
>>> Umesh, AdWords API Team.
>>>
>>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeve

Re: PHP invalid_grant via oauth? Can someone help me figure out what I am doing wrong?

2015-12-16 Thread James Andrews
Hello Yin,

I've been using Google APIs for 2 years, with code already created to get 
google Access tokens and Refresh tokens.  Are you telling me that Adwords 
does not work with the standard Google API Oauth system and I have to 
integrate another method of getting refresh tokens in order to use the 
Adwords API? 

I had mentioned in my original message that we work with Google APIs in 
general.  Youtube, DFA etc... so we are aware that we are only allowed 25 
refresh tokens.  We use 1 with our other api calls so that's not the 
problem.  Server is NTP enabled we ran into that issue when we were dealing 
with Instagram, so that's not it.

James


On Thursday, December 17, 2015 at 2:08:14 AM UTC+9, Yin Niu wrote:
>
> Hi James, 
>
> Have you followed this instruction 
> 
>  to 
> generate refresh token using an MCC account?  
>
> Other things you can check are: 
>
> 1. Make sure your server's clock is in sync with NTP. 
> 2. There is a maximum of 25 refresh tokens that can be valid at a time. 
> If someone gets a 26th refresh token, then the 1st refresh token becomes 
> invalid.
>
> Thanks,
> Yin, AdWords API Team. 
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/036201ca-94ef-42ba-8e8d-f187c57a374f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: What happens if you enter a negative keyword with brackets and set it to broad match?

2015-12-16 Thread Umesh Dengale
Hello,

When you add a negative keyword with brackets, it added as exact match 
negative keyword. (e.g. -[women's hat]). You could add the exact match 
negative keyword to prevent your ad from showing to people who searched for 
that exact keyword. 

With *broad match*, your ad may show if a search term contains your keyword 
terms in any order, and possibly along with other terms. Your ads can also 
show for close variations of your keywords. With *exact match*, your ads 
can appear only when someone searches for your exact keyword, without any 
other terms in the search.

Please check out the Using keyword matching options 
 document for more 
details.

Thanks,
Umesh, AdWords API Team.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/ab2a95ed-55c7-47c2-b17a-23a78226637e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: PHP invalid_grant via oauth? Can someone help me figure out what I am doing wrong?

2015-12-16 Thread Yin Niu
Hi James, 

Have you followed this instruction 

 to 
generate refresh token using an MCC account?  

Other things you can check are: 

1. Make sure your server's clock is in sync with NTP. 
2. There is a maximum of 25 refresh tokens that can be valid at a time. If 
someone gets a 26th refresh token, then the 1st refresh token becomes 
invalid.

Thanks,
Yin, AdWords API Team. 

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/de4279d7-1f85-4c5b-a488-234c439802da%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


PHP invalid_grant via oauth? Can someone help me figure out what I am doing wrong?

2015-12-16 Thread James Andrews
My Company has a Google Application that we use for connecting to various 
Google APIs (Youtube, DFA... etc) via OAuth.  Today I am trying to 
integrate Adwords into this application and am only getting the error 
"invalid_grant".   I have looked through the "Enabled APIs" and see no way 
to enable Adwords to an application specifically.  I suspect that is done 
through the developer token.  The user's token is new created after we were 
granted permission to use the API in a production environment.  Our 
application type is a "Web Application" type.  and when we create tokens we 
create them for use Offline.  I also made sure to add the users's adwords 
ID to the manager account so the developer key has access to the user's 
adwords account.

This is the code snippet I am using.  It is pretty much straight out of the 
example documentation, with minor mods to get oauth creds from the 
configuration file.

Can someone please point me in the right direction.

protected function getCustomer($account, $params)
{
try {
  
// Retrieve the client_id and client_secret
$config = $this->container->getParameter('google_app');

// Get dev_token and user_agent
$adwords = $this->container->getParameter('google_adwords');

// oauth 2 config
$oauth2Info = array(
  'client_id' => $config['id'],
  'client_secret' => $config['secret'],
  'refresh_token' => $params['refresh_token']
);

$user = new \AdWordsUser(null, $adwords['dev_token'], 
$adwords['user_agent'], null, null, $oauth2Info);

// Get the adwords customer
$customerService = $user->GetService("CustomerService");
$customer = $customerService->get();
$customerInfoArray = array();
$customerService = $user->GetService("CustomerService");
$customer = $customerService->get();

print_r($customer);

exit();

// return $customer;

} catch (OAuth2Exception $e) {
  throw new \Exception("ERROR_OAUTH_AUTHORIZATION_FAILURE", 500);
} catch (ValidationException $e) {
  throw new \Exception("ERROR_OAUTH_AUTHORIZATION_FAILURE", 500);
} catch (Exception $e) {
  throw new \Exception("ERROR_UNEXPECTED_FAILURE", 500);
}
}

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/b358e9ce-d1a6-4585-9da1-a2cc5248fee5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: how can I update ad ?

2015-12-16 Thread Yin Niu
Hi Jonathan, 

Ad group ad fields are not mutable 

 
except for *status *field. 

Thanks,
Yin

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/436b1f87-e731-46c1-8fba-2703420a5979%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: GCLID lookup of Video Ad

2015-12-16 Thread Yin Niu
Hi, 

Unfortunately, you won't be able to look up the campaign information using 
GCLID. 

Thanks,
Yin, AdWords API Team. 

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/762387d9-a504-43db-9fc3-345f4810b7cc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Video Ads - How to pull metrics from Adwords API.

2015-12-16 Thread Anthony Madrigal
Hello,

Please see the Video Performance Report 
.
 
It includes the metrics VideoId, VideoViews, VideoViewRate, Clicks, Cost, 
AverageCpv and Impressions. 

Cheers,
Anthony
AdWords API Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/ef3a6322-b048-46dd-9872-49202dd8650f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: ADD ExpressionRuleUserList OPERATION_NOT_SUPPORTED

2015-12-16 Thread Michael Cloonan (AdWords API Team)
Hello,

Rather than have a tag , you should have . The fields for the 
ExpressionRuleUserList go directly within the operand. Similarly, instead 
of , you should have , and 
then the StringRuleItem attributes go directly within the  tag. Just 
to make it cleaner, you should also remove the  altogether, rather than 
specifying it as nil.

I am confused about why you're getting an error pointing to the operator, 
but hopefully cleaning up the operand to have the correct format by 
following the instructions above will fix it anyway.

Just to be clear, the SOAP body you posted most recently, with corrections, 
should look like this:

 
  https://adwords.google.com/api/adwords/rm/v201509";>
 
ADD

   Woopra Label: test-label-Id
   test-label-Id
   
  
 
Woopra_Label-test-label-Id
EQUALS
true
 
  
   

 
  
   

Regards,
Mike, AdWords API Team


On Wednesday, December 16, 2015 at 2:28:48 AM UTC-5, ra...@woopra.com wrote:
>
> Ok I have tried probably 30 combinations now.  I still get the same error: 
>
> `[OperatorError.OPERATOR_NOT_SUPPORTED @ operations[0], 
> RequiredError.REQUIRED @ operations[0].operator]`
>
> Unless I mess up the whole operation in which case it adds to the errors 
> list: `RequiredError.REQUIRED @ operations[0].operand` Which happens when I 
> try and wrap the operator/operand pair in another object like 
> "UserListOperation"
> So what this means to me is that the operand is not being read correctly.
>
> I'm not sure exactly what you meant by "You need to use the 
> ExpressionRuleUserList 
> 
>  to 
> add the RuleItem 
> 
>  instead 
> of the RuleBasedUserList 
> ."
>  
> Perhaps you can make your suggestions directly on the xml that I send so 
> that i can figure out how to get that output from my soap client?  But 
> since no matter what I do to the operand the error says the same thing 
> about the operator, I feel like there is something wrong there.  should it 
> be literally "" or "ADD" or what?  There isn't much room to play 
> with the operator though...that's the flaw in my theory. :)
>
> Here's just the body of a cleaner attempt:
>
>  
>   https://adwords.google.com/api/adwords/rm/v201509";>
>  
> ADD
> 
>
>   
>   Woopra Label: test-label-Id
>   test-label-Id
>   
>  
> 
>
>   Woopra_Label-test-label-Id
>   EQUALS
>   true
>
> 
>  
>   
>
> 
>  
>   
>
>
>
>
> Thanks again
> --Ralph
>
>
> On Tuesday, December 15, 2015 at 9:33:57 AM UTC-8, Umesh Dengale wrote:
>>
>> Hi Ralph,
>>
>> Thanks for providing the SOAP XML request. The RuleItem is associated 
>> with DateSpecificRuleUserList 
>> 
>>  and ExpressionRuleUserList 
>> .
>>  
>> You need to use the ExpressionRuleUserList 
>> 
>>  to 
>> add the RuleItem 
>> 
>>  instead 
>> of the RuleBasedUserList 
>> 
>> .
>> I will submit a feature request for node/js client library.
>>
>> Thanks,
>> Umesh, AdWords API Team.
>>
>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 subscr

Re: Adwords API calls using VBA possible? if Yes could you please send me a sample http request format to pull a report.

2015-12-16 Thread Michael Cloonan (AdWords API Team)
Hello,

Based on the error message, it seems like you may not be setting your HTTP 
headers correctly, even if the XML is valid. Here's an example of what a 
set of valid HTTP headers looks like, in addition to a valid report request 
XML:

Report request to: 
> 'https://adwords.google.com/api/adwords/reportdownload/v201509'
> HTTP headers: [Content-Type: application/x-www-form-urlencoded, 
> Authorization: [REDACTED], User-Agent: [REDACTED], clientCustomerId: 
> [REDACTED], developerToken: [REDACTED], skipReportHeader: false, 
> skipReportSummary: false, skipColumnHeader: false, includeZeroImpressions: 
> false]
> 
>   
> CampaignId
> AdGroupId
> Id
> Criteria
> CriteriaType
> FinalUrls
> Impressions
> Clicks
> Cost
> 
>   Status
>   IN
>   ENABLED
>   PAUSED
> 
>   
>   Last+7+days+CRITERIA_PERFORMANCE_REPORT
>   CRITERIA_PERFORMANCE_REPORT
>   LAST_7_DAYS
>   CSV
> 


You need to specify the Authorization, User-Agent, clientCustomerId, and 
developerToken headers in order for the request to work. If you do not have 
these, you can use the Get Started guide 
 to learn 
more. This guide will help you set up all of those pieces of data except 
the access token. Instead, it will set you up with a refresh token, which 
can be used to generate access tokens. Our OAuth 2.0 guide also has 
instructions for how to generate an access token from a refresh token 

.

Once you get this all set up, please give it another try. If it fails 
again, please include both the HTTP request headers and body in the log so 
that I can make sure that everything is present.

Regards,
Mike, AdWords API Team

On Wednesday, December 16, 2015 at 2:05:13 AM UTC-5, 
shreedhar.bak...@accenture.com wrote:
>
> Hello Mike,
>
> *Please find attached xml attached.*
>
> I need one help can you* please share sample HTTP request of Dot Net code 
> for pulling a report from API with sample XML file*. I will try following 
> that format to VBA Excel and try again.
>
>
> *The error message is as below:*
> * standalone="yes"?>ReportDownloadError.MISSING_PARAMETERMissing
>  
> report 
> definitionReportDownloadError.INVALID_PARAMETERMissing
>  
> client 
> information*
>
>
>
> Regards,
> Shreedhar
>
> On Tuesday, December 15, 2015 at 9:59:35 PM UTC+5:30, Michael Cloonan 
> (AdWords API Team) wrote:
>>
>> Hello,
>>
>> Our .NET client library 
>>  does support VB, 
>> although I'm not sure if that's quite the same as using VBA from excel.
>>
>> However, a client library is not required if you formulate your request 
>> correctly. Can you please log the full XML, rather than showing the code 
>> that generates the XML, because then it would be easy to take a look and 
>> see where the formatting you're using may differ from the correct 
>> formatting that would result in a successful request.
>>
>> Regards,
>> Mike, AdWords API Team
>>
>> On Tuesday, December 15, 2015 at 9:16:45 AM UTC-5, 
>> shreedha...@accenture.com wrote:
>>>
>>> Hi Team,
>>>
>>> I am trying to pull a report from Adwords by API calls using *Excel VBA 
>>> with Windows HTTP request.*
>>> But I am arriving at below error:
>>>
>>> *>> standalone="yes"?>ReportDownloadError.MISSING_PARAMETERMissing
>>>  
>>> report 
>>> definitionReportDownloadError.INVALID_PARAMETERMissing
>>>  
>>> client 
>>> information*
>>>
>>>
>>> and the code i tried as below
>>>
>>>
>>> Sub TestAPI()
>>>
>>>
>>> Dim objHTTP As Object
>>> Dim result As String
>>> Dim Xml As Variant
>>> Dim Fs As FileSystemObject
>>> Dim FileData() As Byte
>>> Dim Arr() As String
>>> Dim St As String
>>>
>>>Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
>>>URL = "https://adwords.google.com/api/adwords/reportdownload/v201509";
>>>
>>>objHTTP.Open "POST", URL, False
>>>
>>>objHTTP.setRequestHeader "Authorization", "Bearer 3756320"
>>>objHTTP.setRequestHeader "DEVELOPER_TOKEN", "NegtkJjSr7jcrQSdeI4Nzg"
>>>objHTTP.setRequestHeader "CLIENT_CUSTOMER_ID", "328-664-6765"
>>>
>>>'objHTTP.RequestBody "__rdxml", Xml
>>>
>>>'  Set Fs = New FileSystemObject
>>>   'Set Xml = Fs.OpenTextFile("C:\Users\ajkumar\Desktop\Shreedhar\New 
>>> Text Document.xml")
>>>
>>>'St = Xml.ReadAll
>>>' "Id" & _
>>>
>>>   ' "" & _
>>>   "Status" & _
>>>   "IN" & _
>>>   "ENABLED" & _
>>>   "PAUSED" & _
>>> "" & _
>>> ' "CampaignId" & _
>>>
>>>St = ">> https://adwords.google.com/api/adwords/cm/v201509"; &  & ">" & _
>>>   "" & _
>>>"Impressions" & _
>>> "Clicks" & _
>>> "Cost" & _
>>>   "" & _
>>>   "Account Performance" & _
>>>   "ACCOUNT_PERFORMANCE_REPORT   " & _
>>>   "LAST_7_DAYS" & _
>>>   "CSV" & _
>>> ""
>>>objHTTP.send St
>>>result = objHTTP.responseText
>>>
>>> End Sub
>>>
>>>
>>>

Интеграция с API AdWords

2015-12-16 Thread Penny Lane
Hello!

We decided to start working with the api adwords. Looked test account and 
sent a request for full access. Finally got a reply on the completion of 
the registration, but when you follow the link, the system displays a 403 
error.
Can anyone faced this problem?

[image: Google AdWords API] AdWords API 
 

Hi there!

Thank you for your interest in the AdWords API. To complete the application 
process, please fill out the form linked below.

 

Fill out form! 

 

*FYI*

You can learn more about signing up for the API 
 on our Developer 
Site. 

The AdWords API blog 
 is the 
official channel for critical announcements and updates.
The Developer Forum  is 
where you can ask for help, discuss changes, and provide feedback.

Regards,
The AdWords API Review Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/46920e1e-947e-4d26-957b-3ec7bebe5102%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Keywords Performance Report - First Position CPC addition request

2015-12-16 Thread Thanet Knack Praneenararat (AdWords API Team)
Hi Will,

I've chased the relevant team recently but not got reply back.
I apologize that at this moment I can't comment on this issue.
However, please rest assured that your request has been passed to the 
related team already.

Sorry for this inconvenience.

Best,
Thanet, AdWords API Team

On Wednesday, December 16, 2015 at 7:28:39 PM UTC+9, Will Atkins wrote:
>
> Hey Thanet,
>
> Sorry to chase again, but it's been over a month now, just wondering when 
> I can expect to get some help with this one?
>
> Thanks,
> Will
>
> On Monday, 30 November 2015 16:06:46 UTC, Thanet Knack Praneenararat 
> (AdWords API Team) wrote:
>>
>> Hi Will,
>>
>> Unfortunately, I haven't got updates yet.
>> I'll update this thread once I get more information.
>>
>> Best,
>> Thanet, AdWords API Team
>>
>> On Monday, November 30, 2015 at 11:41:36 PM UTC+9, Will Atkins wrote:
>>>
>>> Hi Thanet,
>>>
>>> Just checking in to see if there are any updates on this one?
>>>
>>> Thanks,
>>> Will
>>>
>>> On Friday, 13 November 2015 07:28:44 UTC, Thanet Knack Praneenararat 
>>> (AdWords API Team) wrote:

 Hi Will,

 Let me check with the reporting team first.
 I will let you know once I get information.

 Cheers,
 Thanet, AdWords API Team

 On Wednesday, November 11, 2015 at 9:16:42 PM UTC+9, Will Atkins wrote:
>
> Hi there,
>
> In the Keywords Performance Report (accessed via the api - 
> https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report)
>  
> there are currently attributes for First page CPC and Top of page CPC, 
> but 
> there is not one for First position CPC (Which is visible in the Web UI 
> for 
> Adwords in the Keywords report "Est. first position bid").
>
> Is this something that will be added at some point, or is there a 
> reason for it being excluded?
>
> Thanks,
> Will
>


-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/afd71aa1-71ca-4631-b804-f21a14c8bd68%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Keywords Performance Report - First Position CPC addition request

2015-12-16 Thread Will Atkins
Hey Thanet,

Sorry to chase again, but it's been over a month now, just wondering when I 
can expect to get some help with this one?

Thanks,
Will

On Monday, 30 November 2015 16:06:46 UTC, Thanet Knack Praneenararat 
(AdWords API Team) wrote:
>
> Hi Will,
>
> Unfortunately, I haven't got updates yet.
> I'll update this thread once I get more information.
>
> Best,
> Thanet, AdWords API Team
>
> On Monday, November 30, 2015 at 11:41:36 PM UTC+9, Will Atkins wrote:
>>
>> Hi Thanet,
>>
>> Just checking in to see if there are any updates on this one?
>>
>> Thanks,
>> Will
>>
>> On Friday, 13 November 2015 07:28:44 UTC, Thanet Knack Praneenararat 
>> (AdWords API Team) wrote:
>>>
>>> Hi Will,
>>>
>>> Let me check with the reporting team first.
>>> I will let you know once I get information.
>>>
>>> Cheers,
>>> Thanet, AdWords API Team
>>>
>>> On Wednesday, November 11, 2015 at 9:16:42 PM UTC+9, Will Atkins wrote:

 Hi there,

 In the Keywords Performance Report (accessed via the api - 
 https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report)
  
 there are currently attributes for First page CPC and Top of page CPC, but 
 there is not one for First position CPC (Which is visible in the Web UI 
 for 
 Adwords in the Keywords report "Est. first position bid").

 Is this something that will be added at some point, or is there a 
 reason for it being excluded?

 Thanks,
 Will

>>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/cbbb06de-21c4-4d06-aa32-337f13f35d19%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.