Hi,
I have redacted your previous post as it contains sensitive information.
Moving forward, I was able to generate the PAID_ORGANIC_QUERY_REPORT from
your account on my end.
See below for the sample query I used:
ReportQuery query = new ReportQuery.Builder()
.fields("KeywordId", "AccountCurrencyCode", "AccountDescriptiveName", "
AccountTimeZone", "AdGroupId", "AdGroupName", "AdGroupStatus", "AverageCpc",
"AveragePosition", "CampaignId", "CampaignName", "CampaignStatus",
"Clicks", "CombinedAdsOrganicClicks", "CombinedAdsOrganicClicksPerQuery", "
CombinedAdsOrganicQueries", "Ctr", "CustomerDescriptiveName", "Date",
"DayOfWeek", "ExternalCustomerId", "Impressions", "KeywordTextMatchingQuery",
"Month", "MonthOfYear", "OrganicAveragePosition", "OrganicClicks", "
OrganicClicksPerQuery", "OrganicImpressions", "OrganicImpressionsPerQuery",
"OrganicQueries", "Quarter", "QueryMatchType", "SearchQuery", "SerpType",
"Week ","Year")
.from(ReportDefinitionReportType.PAID_ORGANIC_QUERY_REPORT)
.during(ReportDefinitionDateRangeType.LAST_7_DAYS).build();
This said, could you provide the complete report definition
<https://developers.google.com/adwords/api/docs/guides/reporting#create_a_report_definition>
so
we could further check. Please reply via *Reply privately to author*.
Regards,
Dave Paurillo
Google Ads API Team
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
https://ads-developers.googleblog.com/search/label/google_ads_api
https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
On 04/10/19 20:31:50 [email protected] wrote:
Hi!
What I want to get from report - for example:
campaign | source | medium | term | clicks | pay (cost)
test 1 | test_sour | test_med | test_term | 50 | 160
test 1 | test_sour2| test_med2 | test_term2| 42 | 260
test 1 | test_sour3| test_med3 | test_term | 150 | 546
In this page
<https://developers.google.com/adwords/api/docs/appendix/reports#paid-organic>
I
read: "*The Paid and Organic Query report provides a holistic view of your
search stats across ads and organic listings at the query level*".
But instead report I have only headers
[2019-04-08 14:39:31] AW_SOAP.INFO: clientCustomerId=353-528-0885 operations
=1 service=ReportDefinitionService method=getReportFields responseTime=170
requestId=000586034a2991be0a374b877a05b23d server=adwords.google.com isFault
=0 faultMessage=
The report type 'PAID_ORGANIC_QUERY_REPORT' contains the following fields:
KeywordId (long)
AccountCurrencyCode (String)
AccountDescriptiveName (String)
AccountTimeZone (String)
AdGroupId (Long)
AdGroupName (String)
AdGroupStatus (AdGroupStatus) := [UNKNOWN, ENABLED, PAUSED, REMOVED]
AverageCpc (Money)
AveragePosition (Double)
CampaignId (Long)
CampaignName (String)
CampaignStatus (CampaignStatus) := [UNKNOWN, ENABLED, PAUSED, REMOVED]
Clicks (Long)
CombinedAdsOrganicClicks (Long)
CombinedAdsOrganicClicksPerQuery (Double)
CombinedAdsOrganicQueries (Long)
Ctr (Double)
CustomerDescriptiveName (String)
Date (Date)
DayOfWeek (DayOfWeek) := [MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY,
SATURDAY, SUNDAY]
ExternalCustomerId (Long)
Impressions (Long)
KeywordTextMatchingQuery (String)
Month (String)
MonthOfYear (MonthOfYear) := [JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE,
JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER]
OrganicAveragePosition (Double)
OrganicClicks (Long)
OrganicClicksPerQuery (Double)
OrganicImpressions (Long)
OrganicImpressionsPerQuery (Double)
OrganicQueries (Long)
Quarter (String)
QueryMatchType (QueryMatchType) := [AUTO, BROAD, EXACT, EXPANDED, PHRASE]
SearchQuery (String)
SerpType (SerpType) := [UNKNOWN, ADS_ONLY, ORGANIC_ONLY, ADS_AND_ORGANIC]
Week (String)
Year (Integer)
Maybe paid_organic_query_report it isn't better solution for get *campaign,
source, medium, term, clicks, pay (cost),* and you will recommend me
something other?
середа, 10 квітня 2019 р. 09:26:00 UTC+3 користувач
googleadsapi-forumadvisor написав:
Hi,
To better assist you, could you further elaborate the issue that you are
facing regarding the PAID_ORGANIC_QUERY_REPORT? Also, could you clarify
what is the result you are expecting from the report?
Regards,
Dave Paurillo
Google Ads API Team
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
https://ads-developers.googleblog.com/search/label/google_ads_api
https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Was your question answered? Please rate your experience with us by taking a
short survey.
If not -- reply to this email and tell us what else we can do to help.
Take Survey
<https://support.google.com/google-ads/contact/survey_transactional?caseid=7-7885000025961&hl=en&ctx=1>
Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/
On 04/08/19 20:20:09 [email protected] wrote:
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
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/12f0g8mkj00000010pmh7c001i9ur4w6smjee1o6ko30c1g68qjidhh%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
