Campaign Charges by Month

[Jessica Owen]

https://groups.google.com/g/adwords-api/c/FiU9iW0hNFw/m/rpM-vRXRAQAJ

Per the above conversation, it's determined we cannot retrieve invoice cost 
breakdowns...only totals. A recommendation was made "*to query 
the metrics.cost_micros 

 field 
from the campaign 
 resource 
and set the date range to be a monthly range"  *to try and replicate. 

I'm using the Google Ads Query Builder and can't figure out what date range 
I'm suppose to set.  *Can you confirm what date range field I use to 
filter? Also am I able to retrieve other cost details that would be in a 
monthly invoice such as adjustments?*

So far I figured it's this:
SELECT metrics.cost_micros FROM campaign WHERE campaign.id = [CAMPAIGN ID]

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/23c3e54f-691c-4e33-b4cb-ff135abe0fccn%40googlegroups.com.

Re: get customer id - php v13 google ads

[Jessica Villa]

If I put the manager id as param of searchStream I got an empty result but 
no errors...

$googleAdsServiceClient = $googleAdsClient->getGoogleAdsServiceClient();
$query = "SELECT customer.id, customer.descriptive_name, ad_group.id, 
ad_group.name FROM ad_group WHERE ad_group.id = AD_GROUP_ID LIMIT 1";
$response = $googleAdsServiceClient->searchStream('MANAGER_ACCOUNT_ID' 
$query); // is this line right?

foreach ($response->iterateAllElements() as $googleAdsRow) {
$customers[] = [
'customer_client.id' => $googleAdsRow->getCustomerClient()->getId(),
];
}

is there any function where customer id don't need to be required in order 
to get the customer id?

Thank you again!
On Friday, May 5, 2023 at 11:41:28 AM UTC-6 Jessica Villa wrote:

> Thank you for your answer, I have other question:
> using the function *search() * or *searchStream()* is the right way to 
> retrieve info?
>
> $googleAdsServiceClient = $googleAdsClient->getGoogleAdsServiceClient();
> $query = "SELECT customer.id, customer.descriptive_name, ad_group.id, 
> ad_group.name FROM ad_group WHERE ad_group.id = AD_GROUP_ID LIMIT 1";
> $response = $googleAdsServiceClient->searchStream('' $query); // is 
> this line right?
>
> foreach ($response->iterateAllElements() as $googleAdsRow) {
> $customers[] = [
> 'customer_client.id' => $googleAdsRow->getCustomerClient()->getId(),
> ];
> }
>  because I got empty response... and maybe is another way to get the info.
>
> I don't have the customer_id value (so that's why I put '???' I don't know 
> exactly if I am using the right function), only I got ad_group_id value
>
> Thank you!
>
> On Friday, May 5, 2023 at 3:57:37 AM UTC-6 Google Ads API Forum Advisor 
> wrote:
>
>> Hi Jessica,
>>
>> Thank you for responding back with the additional context of your concern.
>>
>> As per your use case, customer is an attributed resources of ad_group 
>> report so you should be able to retrieve the customer fields from ad_group 
>> report. Here's an example query for your reference.
>>   
>>
>>
>> SELECT customer.id, customer.descriptive_name, ad_group.id, ad_group.name 
>> FROM ad_group WHERE ad_group.id = 'AD_YOUR_ADGROUP_ID_HERE'
>>
>>
>> Regards,
>>
>> [image: Google Logo] Google Ads API Team 
>>
>> ref:_00D1U1174p._5004Q2lA73z:ref
>>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/bb252ba0-12ea-4371-a59f-2a61c49177a8n%40googlegroups.com.

Re: get customer id - php v13 google ads

[Jessica Villa]

Thank you for your answer, I have other question:
using the function *search() * or *searchStream()* is the right way to 
retrieve info?

$googleAdsServiceClient = $googleAdsClient->getGoogleAdsServiceClient();
$query = "SELECT customer.id, customer.descriptive_name, ad_group.id, 
ad_group.name FROM ad_group WHERE ad_group.id = AD_GROUP_ID LIMIT 1";
$response = $googleAdsServiceClient->searchStream('' $query); // is 
this line right?

foreach ($response->iterateAllElements() as $googleAdsRow) {
$customers[] = [
'customer_client.id' => $googleAdsRow->getCustomerClient()->getId(),
];
}
 because I got empty response... and maybe is another way to get the info.

I don't have the customer_id value (so that's why I put '???' I don't know 
exactly if I am using the right function), only I got ad_group_id value

Thank you!

On Friday, May 5, 2023 at 3:57:37 AM UTC-6 Google Ads API Forum Advisor 
wrote:

> Hi Jessica,
>
> Thank you for responding back with the additional context of your concern.
>
> As per your use case, customer is an attributed resources of ad_group 
> report so you should be able to retrieve the customer fields from ad_group 
> report. Here's an example query for your reference.
>   
>
>
> SELECT customer.id, customer.descriptive_name, ad_group.id, ad_group.name 
> FROM ad_group WHERE ad_group.id = 'AD_YOUR_ADGROUP_ID_HERE'
>
>
> Regards,
>
> [image: Google Logo] Google Ads API Team 
>
> ref:_00D1U1174p._5004Q2lA73z:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/e79ae6b0-4a95-4585-b3ab-bdbd3ae69cccn%40googlegroups.com.

Re: get customer id - php v13 google ads

[Jessica Villa]

Thank you for your answer, I have other question:
using the function *search() * or *searchStream()* is the right way to 
retrieve info?

$googleAdsServiceClient = $googleAdsClient->getGoogleAdsServiceClient();
$query = "SELECT customer.id, customer.descriptive_name, ad_group.id, 
ad_group.name FROM ad_group WHERE ad_group.id = x LIMIT 1";
$response = $googleAdsServiceClient->searchStream('', $query); // 
is this line right?

foreach ($response->iterateAllElements() as $googleAdsRow) {
$customers[] = [
'customer_client.id' => $googleAdsRow->getCustomerClient()->getId(),
];
}
 because I got empty response... and maybe is another way to get the info.

Thank you!
On Friday, May 5, 2023 at 3:57:37 AM UTC-6 Google Ads API Forum Advisor 
wrote:

> Hi Jessica,
>
> Thank you for responding back with the additional context of your concern.
>
> As per your use case, customer is an attributed resources of ad_group 
> report so you should be able to retrieve the customer fields from ad_group 
> report. Here's an example query for your reference.
>   
>
>
> SELECT customer.id, customer.descriptive_name, ad_group.id, ad_group.name 
> FROM ad_group WHERE ad_group.id = 'AD_YOUR_ADGROUP_ID_HERE'
>
>
> Regards,
>
> [image: Google Logo] Google Ads API Team 
>
> ref:_00D1U1174p._5004Q2lA73z:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/31a040f2-2ef0-4dd4-a6ec-cd36caf80fd9n%40googlegroups.com.

Re: get customer id - php v13 google ads

[Jessica Villa]

The issue is not the log, is to know if there is possible to retrieve the 
*customer.id* having only the *ad_group_id*
doing the* $query* and using *search()* like this:
*$googleAdsServiceClient->search(**$query);*

or something, in the examples couldn't find something about it

Thank you!
On Thursday, May 4, 2023 at 4:36:19 AM UTC-6 Google Ads API Forum Advisor 
wrote:

> Hi Jessica*,*
>
> Thank you for reaching out to us.
>
> For our team to further check this and provide you with an appropriate 
> recommendation, could you please provide us with the complete API logs (
> *request* and *response* with *request-id*) generated on your end?
>
>- *request* : 
>
> *https://developers.google.com/google-ads/api/docs/concepts/field-service#request*
>  
>
> <https://developers.google.com/google-ads/api/docs/concepts/field-service#request>
>  
>- *response*: 
>
> *https://developers.google.com/google-ads/api/docs/concepts/field-service#response*
>  
>
> <https://developers.google.com/google-ads/api/docs/concepts/field-service#response>
>  
>- *request-id* : 
>
> *https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id*
>  
>
> <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id>
>  
>
> Note that logs can be requested or provided to the developer handling the 
> Google Ads API transactions when logging of the API requests has been 
> enabled.
>
> This is the specific guideline to enable PHP: 
> *https://developers.google.com/google-ads/api/docs/client-libs/php/logging* 
> <https://developers.google.com/google-ads/api/docs/client-libs/php/logging>
> You may then send the requested information via the Reply privately to 
> author option. If this option is not available, you may send the details 
> directly to our googleadsa...@google.com alias instead.
>
> Best regards,
> [image: Google Logo] Google Ads API Team 
>
> ref:_00D1U1174p._5004Q2lA73z:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/90de7689-f9f6-4d0c-9957-faafbd795655n%40googlegroups.com.

Get customer ID - PHP V13 Google Ads

[Jessica Villa]

Hello!

I have a question and hope someone can help me: how can I get the customer 
ID if I only have the ad_group_id?

I tried using this query: 
*$query = "SELECT customer.id FROM ad_group WHERE ad_group.id = 
".$ad_group_id." LIMIT 1";*

and accessing like this: *$googleAdsClient->getCustomerId()*

but my query is not successful, so is this the right way?

Note:
*$ad_group_id* is retrieved from an array so the query is dynamic, and the 
*customer 
id* too, so that's why I want to get the *customer id*.

I'm using php v13 of google ads.

Thanks!!

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/12ac270c-4c56-4d19-a2f9-4a0c10a3c848n%40googlegroups.com.

Understand the values retrieved by the php api of google ads

[Jessica Villa]

Hello!
I hope someone can help me to understand this.

I have this query:

*SELECT** campaign.primary_status, *
* campaign.campaign_group, *
* metrics.cost_per_conversion, *
* campaign.name,*
* segments.date,*
* metrics.clicks,*
* metrics.cost_micros*
* FROM campaign WHERE segments.date DURING LAST_7_DAYS and campaign.id = 
xx*

and I get the data successfully but I notice this:

In the field *metrics.cost_per_conversion* I got in my *json response* (for 
example) a number like this:
*31334088.24578694*

and checking my *dashboard*, I have: *31.33*

*Comparison:*
*31334088.24578694 - **31.33*

Why happen this? Do I have to cast my data or something?
I'm using PHP Library.

Thanks!

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/e8c20cdb-f5ae-4e83-acec-7a840ce13173n%40googlegroups.com.

Get merchant ids related to adwords account giving different merchant id

[Jessica Montar]

Hi, I'm trying to build a Dynamic Remarketing Campaing via API and I need 
the merchant_id to get the product listing.
I already have access to the customer adwords account, so I'm trying to get 
the data without asking again for permissions.
I'm currently using CustomerService and ServiceLinks according to this post 
https://groups.google.com/forum/#!searchin/adwords-api/merchant$20id$20adwords%7Csort:date/adwords-api/WqprrJ_d5po/-SEHPtp_AAAJ
but the serviceLinkId is not the one that appears in my merchant center.
This is the code that I'm using:

customer_service = client.GetService('CustomerService', version='v201809')
selector = {
  'fields': ['ServiceType'],
  'predicates': [
  {
  'field': 'ServiceType',
  'operator': 'EQUALS',
  'values': ['MERCHANT_CENTER']
  }
  ]
}
mcc = customer_service.getServiceLinks(selector)

Have there been any changes to the api?

Thanks!

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/e17d9d7d-187e-4ccf-8976-f28bee482a0e%40googlegroups.com.

Google Ads >> Service Client Config >> Timeout Milles Method Search

[jessica . capuozzo]

Hi,

I've an error using the calls for the *Reporting*, using the default 
parameters of the service client for the *method Search*.

When I'm using the default Service Client Config with the *timeout_millis *to 
360 it's returning an exception.

The resource that I'm ref. to it's in the json file: 
google-ads-php\src\Google\Ads\GoogleAds\V1\Services\resources\
*google_ads_service_client_config.json*

Setting the timeout_millis param to 60 it's working.

Please, Could you look into this?

Thank you in advance,
Best,
Jessica Capuozzo

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads 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/91dc87c8-59f7-42a8-acce-424134075fa2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [PHP] Google Ads Api Beta. Problems with ExpandedTextAd Update

[jessica . capuozzo]

Hi,

Any news on Update Ad?

Thank you,
Best.

Jessica Capuozzo

On Wednesday, 20 February 2019 20:11:33 UTC+1, Miguel Graciá wrote:
>
>
> Hi,
>
> I am trying the new api of google ads. I was able to create an ad in my 
> test account with the help of the examples, but when I try to update the 
> title, the api returns an error. The request, extracted from the log, is as 
> follows:
>
>
> {
> "customerId": "[CUSTOMER_ID]",
> "operations": [
> {
> "updateMask": "resourceName,ad.id
> ,ad.finalUrls,ad.finalMobileUrls,ad.trackingUrlTemplate,ad.urlCustomParameters,ad.displayUrl,ad.type,ad.addedByGoogleAds,ad.devicePreference,
> ad.name
> ,ad.textAd,ad.expandedTextAd.headlinePart1,ad.expandedTextAd.headlinePart2,ad.expandedTextAd.headlinePart3,ad.expandedTextAd.description,ad.expandedTextAd.description2,ad.expandedTextAd.path1,ad.expandedTextAd.path2,ad.dynamicSearchAd,ad.responsiveDisplayAd,ad.callOnlyAd,ad.expandedDynamicSearchAd,ad.hotelAd,ad.shoppingSmartAd,ad.shoppingProductAd,ad.gmailAd,ad.imageAd,ad.videoAd"
> ,
> "update": {
> "resourceName": 
> "customers\/[CUSTOMER_ID]\/adGroupAds\/[AD_GROUP_AD_ID]_[AD_GROUP_ID]",
> "status": "ENABLED",
> "ad": {
> "id": "[AD_GROUP_AD_ID]",
> "expandedTextAd": {
> "headlinePart1": "Title Test"
> }
> }
> }
> }
> ]
> }
>
>
>
>
>
> Response:
>
>
>...
>
>{
>"errorCode": {
>"requestError": "IMMUTABLE_FIELD"
>},
>"message": "Field 'ad.expanded_text_ad.headline_part1' cannot be 
> modified by 'UPDATE' operation.",
>"location": {
>"fieldPathElements": [
>{"fieldName": "operations","index": "0"},
>{"fieldName": "update" }, 
>{"fieldName": "ad" }, 
>{"fieldName": "expanded_text_ad" }, 
>{"fieldName": "headline_part1" } 
>]
>}
>}
>
> ...
>
>
>
>
> Does this mean that in order to modify the title it is necessary to delete 
> the ad and create a new one?
>
> The old api of google adwords has examples where you can modify this field.
>
>
> https://developers.google.com/adwords/api/docs/samples/php/basic-operations#update-an-expanded-text-ad
>
> Thanks for the help.
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads 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/3a184c73-9bd5-4128-8de0-109d5d5ed028%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Getting data from CAMPAIGN_PERFORMANCE_REPORT

[Jessica]

Hi, hopefully someone can help me with this.

I am completely new to Adwords however I have a lot of SSIS experience and 
have been tasked with using SSIS to get data from the 
CAMPAIGN_PERFORMANCE_REPORT into a Microsoft SQL Server DB.

Can anyone help me with this, or at least point me in the direction of how 
I could achieve this easily? I just want to get an extract of the above 
report for the current day placed in a table on the server.

I have looked up Zappysys and KingswaySoft however I need to be able to do 
this for free 


I appreciate any help!

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads 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/5a621183-3b4f-494a-8c1d-7d9c6d27b6af%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Users suddenly getting errors for [AuthorizationError.CUSTOMER_NOT_ACTIVE @ ; trigger:‘’]

[jessica . brock]

Yeah that may be it - we stumbled on this when we kept looking:
https://ads-developers.googleblog.com/2018/03/changes-to-inactive-adwords-accounts.html

And I bet that is the issue. We updated our code so it will report the 
account with the problem so that our users can check and remove that 
account.

Thank you for your help!
Jessica

On Thursday, May 31, 2018 at 7:45:44 PM UTC+3, jessic...@supermetrics.com 
wrote:
>
> Our connector that uses the AdWords API has users suddenly seeing errors 
> like this when trying to authenticate or use the connector: 
> [AuthorizationError.CUSTOMER_NOT_ACTIVE @ ; trigger:‘’] 
>
> OAuth account fetch error: x resp: 
> [AuthorizationError.CUSTOMER_NOT_ACTIVE @ ; trigger:''] (Supermetrics 
> request ID: ). tokenreq: 
> client_id=.apps.googleusercontent.com&redirect_uri=https%3A%2F%2Fsupermetrics.com%2Flogin-complete%2F&code=4&client_secret=F&grant_type=authorization_code
>  
>
> The first report we got from users is at 12:18 EEST. Others reported later 
> (probably as they got to work and found it busted).

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads 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/14dfbd26-447e-4c32-a732-13a255b1a0a1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Users suddenly getting errors for [AuthorizationError.CUSTOMER_NOT_ACTIVE @ ; trigger:‘’]

[jessica . brock]

Our connector that uses the AdWords API has users suddenly seeing errors like 
this when trying to authenticate or use the connector:
[AuthorizationError.CUSTOMER_NOT_ACTIVE @ ; trigger:‘’]

OAuth account fetch error: x resp: [AuthorizationError.CUSTOMER_NOT_ACTIVE 
@ ; trigger:''] (Supermetrics request ID: ). tokenreq: 
client_id=.apps.googleusercontent.com&redirect_uri=https%3A%2F%2Fsupermetrics.com%2Flogin-complete%2F&code=4&client_secret=F&grant_type=authorization_code
The first report we got from users is at 12:18 EEST. Others reported later 
(probably as they got to work and found it busted).

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads 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/480e7266-d4d7-4689-9ec0-516f26bbd301%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

USER permission denied issue

[jessica . qi]

We have been running adwords reporting API for couple of months. However, 
today, we failed to get data. 

Basically, 2 errors
1.  [SoapFault][AuthorizationError.USER_PERMISSION_DENIED @ ; 
trigger:'']
2. [OAuth2Exception]  
  {  
"error" : "invalid_grant",   
"error_description" : "Token has been revoked."  
  }

What we tried:
1. upgraded PHP SDK from 201509 to 201603 - no luck
2. regenerate refresh token - no luck
3. re-generate developer client id, client secret - no luck

Can anyone shed some light?

thanks.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/c6697b44-0332-4455-88f6-8a5b185d410d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Google Creative Sandbox Brief

[Jessica Bento]

Olá pessoal.
Posso estar no fórum errado para fazer essa pergunta, mas espero que possam 
me ajudar mesmo assim.
Estou desesperada para enviar minha ideia para o concurso cultural do 
Google.
Porém quando Entro nenhum site e tento enviar Minha ideia, Dá Erro 
(http://www.creativesandbox.com.br/ideaCreate/authentication.jhtml?code=r8punwxw92cgr1q
) . Acredito Que SEJA POR Causa da internet ou talvez não.
Já tentei enviar e-mail para as agências de SP relatando o meu problema e 
pedindo para que possam enviar o formulário no meu e-mail. Porém não obtive 
sucesso.
Se alguém puder me ajudar, ao menos respondam essa postagem, por favor.

Muito Obrigada!

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