AdWords Report with group by

[Darkcookie]

Hi! I need to create an adWords report to get:

clicks

shows

sum

bounce 

using next field as a group key:

day

phrase_id(with -words)

ad_id

ad_placement (site, where google shows my ad). 

Can you help me?

[Shwetha Vastrad (AdWords API Team)]

Hi,

Depending on the report type you need, you can query for various fields in the report definition. You can use predicates to narrow your report results. The Reporting basics guide provides more details on using AdWords API to get reports. The DownloadCriteriaReport Java example demonstrates how to download Criteria Performance Report. You can modify this example as needed to query different report types. Example code in other languages is available here.

Regards,

Shwetha, AdWords API Team.

[Darkcookie]

I dont know what type of report can give me values, that i need. That's why i started this topic. :)

 In fact, i can't even find bounce field(Not BounceRate field). It it possible to get not an average values?

понедельник, 7 ноября 2016 г., 21:43:12 UTC+3 пользователь Shwetha Vastrad (AdWords API Team) написал:

[Shwetha Vastrad (AdWords API Team)]

Hi,

This page lists all the fields available in all report types. If you are looking for Google Analytics metrics such as AveragePageviews, BounceRate, AverageTimeOnSite, and PercentNewVisitors, you'll need to use one of the report types listed below:

• Ad Performance
• Ad Group Performance
• Campaign Performance
• Keywords Performance
  

This guide provides more information on getting Analytics data combined with AdWords data. I hope this helps. I'm afraid bounce metric is not available in AdWords API reports. 

[Darkcookie]

ok, i'v created analytics report to get analytics data, but i still need to get report groupped by ad_id, ad_placement, keyword_id, date(YYYY-MM-DD)

Can you tell me is it possible for me to create it?

I my report to let me know how many clicks i got 

(for example) on 2012-03-25 with keyword 'hehehe' from ad placed on youtube.com with ad id 12345

What report i need to create? What settings i should use?

Hope you can tell me. Thank you!

вторник, 8 ноября 2016 г., 21:46:08 UTC+3 пользователь Shwetha Vastrad (AdWords API Team) написал:

[Shwetha Vastrad (AdWords API Team)]

Hi,

I'm afraid you cannot use full SQL vocabulary in AWQL query. Although AWQL is inspired by SQL, JOIN and GROUP BY clauses are omitted. You can use AwReporting framework using which reports can be stored in your relational database. 

You can use Placement Performance Report and Automatic Placements Performance Report to get statistics at the placement level, for managed and automatic placements respectively. To get statistics for how an Ad performed for different keywords, you can use Ad Performance Report and add CriterionId field in the query. This field contains IDs for keywords and other criterion types. If you include the Date field in the report query, the data will be segmented by date. You can store these reports in your database and use SQL to group results as needed. 

I hope this helps. 

[Darkcookie]

As i see there is no way to get placement and keyword together.

пятница, 11 ноября 2016 г., 19:18:00 UTC+3 пользователь Shwetha Vastrad (AdWords API Team) написал:

[Shwetha Vastrad (AdWords API Team)]

Hi,

The reports that I think could be helpful here are Ad Performance Report and Criteria Performance Report. Both these reports contain performance statistics at the ad and ad group criteria level respectively. You need to request for CriterionId from Ad Performance Report to get the criterion that triggered the ad. But I'm afraid you'll not be able to get performance statistics for keyword and placement together in the same row.

[chirag dakshikar]

Is there any way to insert the reporting data in mySQL database while using adwords in python?

[Peter Oliquino]

Hi,

Since this is already an old thread, I would recommend that you create a new one for any future concerns. As for your question, inserting data retrieved from the AdWords API's services or reports to external databases would need to be implemented on your end.

Best regards,

Peter

AdWords API Team