aggregationTypes thru adwords API v201101
In v13, we were generating an ad performance report w/
aggregationTypes = Daily and crossClient = true.
How do i do this in v201101 (latest) (thru the Ruby adwords API gem)?
i've tried adding it to the operand, but cant get it to work:
operation = {
:operator = 'ADD',
:operand = {
:report_type = 'AD_PERFORMANCE_REPORT',
:report_name = 'Daily Adwords performance report #%d' %
(Time.new.to_f * 1000).to_i,
:selector = {
:fields = ['Impressions', 'Clicks', 'Cost',
'Conversions', 'AveragePosition', 'CampaignId', 'CampaignName',
'CampaignStatus', 'CustomerDescriptiveName'],
:date_range = { :min = day.strftime(%Y%m%d), :max
= day.strftime(%Y%m%d)}
},
:date_range_type = 'CUSTOM_DATE',
:download_format = 'XML',
:aggregationTypes = 'Daily',
:cross_client = true
}
}
I need this data (clicks, costs, conversions) summed/averaged for the
day. Each day, i need to download the full day's aggregate
information.
Thanks! Steve.
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups AdWords API Forum group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
Re: aggregationTypes thru adwords API v201101
Thanks Jason! On Jul 29, 11:12 am, jstedman jason.sted...@thesearchagency.com wrote: Steve, v201101 uses implicit aggregation specification through the smallest aggregation field specified in the report. So if you include the field Month in your report definition, you will get data aggregated by month, same goes for day, year, and hour. There are also sub- aggregation fields such as clickType. Hope this helps! Jason -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: aggregationTypes thru adwords API v201101
Jason,
I added Date to the fields (I tried Day, but this didnt go thru).
It's still not aggregating (see below...i'm getting 5 rows, same date
for campaignID. I included the operation below and sniplet of the
output. How would i get all the impressions/clicks/costs for a
compaignID for a day?
row day=2011-07-28 impressions=9 clicks=0 cost=0.00
conv1PerClick=0 avgPosition=4.3 campaignID=97947955 campaign=V
Nationwide campaignState=active clientName=California Classic/
row day=2011-07-28 impressions=13 clicks=0 cost=0.00
conv1PerClick=0 avgPosition=4.0 campaignID=97947955 campaign=V
Nationwide campaignState=active clientName=California Classic/
row day=2011-07-28 impressions=3 clicks=0 cost=0.00
conv1PerClick=0 avgPosition=6.7 campaignID=97947955 campaign=V
Nationwide campaignState=active clientName=California Classic/
row day=2011-07-28 impressions=1 clicks=0 cost=0.00
conv1PerClick=0 avgPosition=9.0 campaignID=97947955 campaign=V
Nationwide campaignState=active clientName=California Classic/
row day=2011-07-28 impressions=12 clicks=0 cost=0.00
conv1PerClick=0 avgPosition=5.3 campaignID=97947955 campaign=V
Nationwide campaignState=active clientName=California Classic/
operation = {
:operator = 'ADD',
:operand = {
:report_type = 'AD_PERFORMANCE_REPORT',
:report_name = 'Daily Adwords performance report #%d' %
(Time.new.to_f * 1000).to_i,
:selector = {
:fields = ['Date', 'Impressions', 'Clicks', 'Cost',
'Conversions', 'AveragePosition', 'CampaignId', 'CampaignName',
'CampaignStatus', 'CustomerDescriptiveName']
},
:date_range_type = 'YESTERDAY',
:download_format = 'XML',
:cross_client = true
}
}
On Jul 29, 11:12 am, jstedman jason.sted...@thesearchagency.com
wrote:
Steve,
v201101 uses implicit aggregation specification through the smallest
aggregation field specified in the report. So if you include the field
Month in your report definition, you will get data aggregated by
month, same goes for day, year, and hour. There are also sub-
aggregation fields such as clickType.
Hope this helps!
Jason
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
how to i get all the desired columns in a report?
For the columns shown at bottom, i'd like to get all these in my report. I
cant figure out how to get these in fields (if i add these columns to
fields, the API says invalid field).
operation = {
:operator = 'ADD',
:operand = {
:report_type = 'AD_PERFORMANCE_REPORT',
:report_name = 'Daily G5 Adwords performance report #%d' %
(Time.new.to_f * 1000).to_i,
:selector = {
:fields = ['Impressions', 'Clicks', 'Cost', 'Conversions'],
#these are the only ones that are valid
:date_range = { :min = day.strftime(%Y%m%d), :max =
day.strftime(%Y%m%d)}
},
:date_range_type = 'CUSTOM_DATE',
:download_format = 'XML',
:cross_client = true
}
#but i want all of these in a row
columns
column name=account display=Account/
column name=day display=Day/
column name=campaign display=Campaign/
column name=adGroup display=Ad group/
column name=adID display=Ad ID/
column name=customerID display=Customer ID/
column name=destinationURL display=Destination URL/
column name=clicks display=Clicks/
column name=impressions display=Impressions/
column name=ctr display=CTR/
column name=avgCPC display=Avg. CPC/
column name=avgCPM display=Avg. CPM/
column name=cost display=Cost/
column name=avgPosition display=Avg. position/
/columns
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups AdWords API Forum group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
Re: why no campaigns?
thanks Anash. I think #3 or #4 is our issue. I'm at a loss to understand what these mean tho. I've asked our biz contact, and they dont know either. Can you walk us thru finding what our client_email should be? On Jul 26, 10:18 pm, AdWords API Advisor adwordsapiadvi...@google.com wrote: Hi Steve, You could check in the following order for troubleshooting: 1. Is your config file being picked up properly? (Set a wrong password in the config file, your call should fail). 2. Is the call going to sandbox or production environment? Your config says it goes to production, but you might want to double check. 3. Have you provided a valid Advertiser login email for client_email? If you give an MCC account here, then your call will still succeed, but you won't get any campaigns back. 4. Does the Advertiser account pointed to by client_email actually have campaigns? I've seen in some cases that developers make call to the wrong account by mistake. Cheers, Anash P. Oommen, AdWords API Advisor. -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: why no campaigns?
We figured it out finally...by using the mmc services. thanks. On Jul 27, 10:06 am, Steve Burkett st...@burkettnet.com wrote: thanks Anash. I think #3 or #4 is our issue. I'm at a loss to understand what these mean tho. I've asked our biz contact, and they dont know either. Can you walk us thru finding what our client_email should be? On Jul 26, 10:18 pm, AdWords API Advisor adwordsapiadvi...@google.com wrote: Hi Steve, You could check in the following order for troubleshooting: 1. Is your config file being picked up properly? (Set a wrong password in the config file, your call should fail). 2. Is the call going to sandbox or production environment? Your config says it goes to production, but you might want to double check. 3. Have you provided a valid Advertiser login email for client_email? If you give an MCC account here, then your call will still succeed, but you won't get any campaigns back. 4. Does the Advertiser account pointed to by client_email actually have campaigns? I've seen in some cases that developers make call to the wrong account by mistake. Cheers, Anash P. Oommen, AdWords API Advisor. -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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
how to set segments = Day on a report download
Hi,
I'm creating a report w/ the following selector
operation = {
:operator = 'ADD',
:operand = {
:report_type = 'AD_PERFORMANCE_REPORT',
:report_name = 'Daily G5 Adwords performance report #%d'
% (Time.new.to_f * 1000).to_i,
:selector = {
:fields = ['Impressions', 'Clicks', 'Cost'],
:date_range = { :min = @start_date.strftime(%Y%m
%d), :max = @end_date.strftime(%Y%m%d)}
},
:date_range_type = 'CUSTOM_DATE',
:download_format = 'XML',
:cross_client = true
}
For each day in the date_range, i want a separate row for the fields,
and i want that date in the fields. I did this in the adwords UI by
adding a Segments = Day in the Download and Schedule Report. How
do i set this via the API?
Thanks!
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups AdWords API Forum group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
novice question: getting adwords data using new version (migrating from v13)
Hi, I took over (Ruby) code that uses v13. it calls https://adwords.google.com/api/adwords/v13/ReportService w/ some home grown SOAP::RPC::Driver code. it uses the getReportDownloadUrl, to get a report Url to grab the account's cost, clicks, imps, conv, pos statistics for campaign. Using the new Ruby gem (google-adwords-api), can someone point me to the basics of how to use the current version of adwords to get the same data? thanks for the tips to get started! -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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
novice question: getting adwords data using new version (migrating from v13)
Hi, I took over (Ruby) code that uses v13. it calls https://adwords.google.com/api/adwords/v13/ReportService w/ some home grown SOAP::RPC::Driver code. it uses the getReportDownloadUrl, to get a report Url to grab the account's cost, clicks, imps, conv, pos statistics for campaign. Using the new Ruby gem (google-adwords-api), can someone point me to the basics of how to use the current version of adwords to get the same data? thanks for the tips to get started! -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: novice question: getting adwords data using new version (migrating from v13)
I found the
aw=AdwordsApi::Api.new(File.expand_path(#{ROOT_DIR}/config/
adwords_api.yml))
s=aw.service(:CampaignService, :v201101)
s.get({})
but i get no campaigns back (in v13, i get campaigns). It's using the
same developer_token, and it appears to be authenticating ok.
any guess of why no campaigns?
On Jul 26, 9:30 am, Steve Burkett st...@burkettnet.com wrote:
Hi,
I took over (Ruby) code that uses v13. it
callshttps://adwords.google.com/api/adwords/v13/ReportServicew/ some home
grown SOAP::RPC::Driver code. it uses the getReportDownloadUrl, to
get a report Url to grab the account's cost, clicks, imps, conv, pos
statistics for campaign.
Using the new Ruby gem (google-adwords-api), can someone point me to
the basics of how to use the current version of adwords to get the
same data?
thanks for the tips to get started!
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
no campaigns
Hi,
We were previously using the v13 service to get campaign/customerid
cost, clicks, imp, conv, pos. I found the google Adwords Api gem,
and set it up this way:
aw = AdwordsApi::Api.new(File.expand_path(#{ROOT_DIR}/config/
adwords_api.yml))
c = aw.service(:CampaignService, :v201101)
c.get({})
but i get no campaigns back (I should be getting ~2000 campaigns
back).
I do know it's configured via the following yml (fields x'ed out for
this post). The service reponse on the get is 0 entries (it does
authenticate successfully)
:authentication:
:method: ClientLogin
:password:
:email:
:developer_token: x
:client_email:
:user_agent: x
:service:
:environment: production
:connection:
:strict_ssl_verification: false
:library:
:log_level: INFO
Any idea why i'm not getting campaigns back?
And...once i get past this issue, how do i get cost, clicks, imp,
conv, pos back?
Thanks!! :)
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups AdWords API Forum group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
why no campaigns?
Hi,
We were previously using the v13 service to get campaign/customerid
cost, clicks, imp, conv, pos. I found the google Adwords Api gem,
and set it up this way:
aw = AdwordsApi::Api.new(File.expand_path(#{ROOT_DIR}/config/
adwords_api.yml))
c = aw.service(:CampaignService, :v201101)
s = {
:fields = ['Id', 'Name', 'Status'],
:ordering = [{:field = 'Name', :sort_order = 'ASCENDING'}]
}
c.get(s)
but i get no campaigns back (I should be getting ~2000 campaigns
back).
I do know it's configured via the following yml (fields x'ed out for
this post). The service reponse on the get is 0 entries (it does
authenticate successfully)
:authentication:
:method: ClientLogin
:password:
:email:
:developer_token: x
:client_email:
:user_agent: x
:service:
:environment: production
:connection:
:strict_ssl_verification: false
:library:
:log_level: INFO
Any idea why i'm not getting campaigns back?
And...once i get past this issue, how do i get cost, clicks, imp,
conv, pos back?
Thanks!! :)
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups AdWords API Forum group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
Re: why no campaigns?
i also tried to get the :ReportDefinitionService, but got no
:entries back.
On Jul 26, 3:58 pm, Steve Burkett st...@burkettnet.com wrote:
Hi,
We were previously using the v13 service to get campaign/customerid
cost, clicks, imp, conv, pos. I found the google Adwords Api gem,
and set it up this way:
aw = AdwordsApi::Api.new(File.expand_path(#{ROOT_DIR}/config/
adwords_api.yml))
c = aw.service(:CampaignService, :v201101)
s = {
:fields = ['Id', 'Name', 'Status'],
:ordering = [{:field = 'Name', :sort_order = 'ASCENDING'}]
}
c.get(s)
but i get no campaigns back (I should be getting ~2000 campaigns
back).
I do know it's configured via the following yml (fields x'ed out for
this post). The service reponse on the get is 0 entries (it does
authenticate successfully)
:authentication:
:method: ClientLogin
:password:
:email:
:developer_token: x
:client_email:
:user_agent: x
:service:
:environment: production
:connection:
:strict_ssl_verification: false
:library:
:log_level: INFO
Any idea why i'm not getting campaigns back?
And...once i get past this issue, how do i get cost, clicks, imp,
conv, pos back?
Thanks!! :)
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups AdWords API Forum group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
