How to aggregate data from the Audience Performance report ?

[Juliette]

I would like to use a script to report on the performances of my audiences, I however can not think of a way to get the performances aggregated at the audience level, instead of having one row per audience/per ad group.
Would anyone have a lead on this ?

[Anash Oommen]

Hi Juliette,

How exactly are you requesting the report? Could you share your AWQL query?

Cheers,

Anash P. Oommen,
AdWords Scripts Team,

[Juliette]

Hi Anash, my query looks like:


var report = AdWordsApp.report(
"SELECT AccountDescriptiveName,Criteria,BidModifier,Impressions,Clicks,Cost,Conversions,Ctr,ConversionRate,CostPerConversion,AverageCpc" +
" FROM AUDIENCE_PERFORMANCE_REPORT " +
" WHERE" +
  " Impressions > 0" +
" DURING LAST_14_DAYS");

[Anash Oommen]

Hi Juliette,

Apologies for the delay. If you leave out the AdGroupId column, the report should aggregate at the Criteria level. AdGroupId and Criteria are segments, so including those columns will split the data by those dimensions.

Cheers,
Anash P. Oommen,
AdWords Scripts Team.

[Tyler]

Is there any way to have this report display the list name instead of the List ID?

On Thursday, September 18, 2014 8:55:48 AM UTC-4, Anash Oommen wrote:

Hi Juliette,

Apologies for the delay. If you leave out the AdGroupId column, the report should aggregate at the Criteria level. AdGroupId and Criteria are segments, so including those columns will split the data by those dimensions.

Cheers,
Anash P. Oommen,
AdWords Scripts Team.

On Monday, September 8, 2014 10:52:25 AM UTC-4, Juliette wrote:

Hi Anash, my query looks like:


var report = AdWordsApp.report(
"SELECT AccountDescriptiveName,Criteria,BidModifier,Impressions,Clicks,Cost,Conversions,Ctr,ConversionRate,CostPerConversion,AverageCpc" +
" FROM AUDIENCE_PERFORMANCE_REPORT " +
" WHERE" +
  " Impressions > 0" +
" DURING LAST_14_DAYS");



On Friday, 5 September 2014 16:00:39 UTC+2, Anash Oommen wrote:

Hi Juliette,

How exactly are you requesting the report? Could you share your AWQL query?

Cheers,

Anash P. Oommen,
AdWords Scripts Team,

On Thursday, September 4, 2014 3:58:58 AM UTC-4, Juliette wrote:

I would like to use a script to report on the performances of my audiences, I however can not think of a way to get the performances aggregated at the audience level, instead of having one row per audience/per ad group.
Would anyone have a lead on this ?

[Juliette]

Hi Anash,

No worries for the delay!
I am not sure to understand correctly as my query does not include the AdGroupId column you are mentioning.

var report = AdWordsApp.report(
"SELECT AccountDescriptiveName,Criteria,BidModifier,Impressions,Clicks,Cost,Conversions,Ctr,ConversionRate,CostPerConversion,AverageCpc" +

" FROM AUDIENCE_PERFORMANCE_REPORT " +
" WHERE" +
  " Impressions > 0" +
" DURING LAST_14_DAYS");

In the report I get when executing this query, the adgroup name (or ID) doesn't show, I still however get one row per audience/per ad group: I get multiple rows for the same audience list and the number of rows matches the number of ad groups multiplied by the number of audiences.
Is there anything I am missing?

Thanks

[Anash Oommen]

Hi Tyler,

The Criteria column should give you the name instead of the ID.

Cheers,
Anash

[Anash Oommen]

Hi Juliette,

May be there is an implicit segmentation happening by AdGroupId. Could you use the "Reply to Author" option to share your account id?

Cheers,
Anash P. Oommen,
AdWords Scripts Team.

[Tyler]

Hey Anash,
Thanks for getting back to me. So when I run my reports, in the Criteria Column I get "boomuserlist::XXXXX" where XXXXX is the List ID #. Any idea why this could be or how I could get the name?
Thanks!

[edu...@raccoon.ag]

I am having the same problem, any ideas?

[Alexander Wang]

Sorry,

There are a couple of issues in this thread. To clarify, are you having trouble getting the list name displayed (rather than the list id) or are you having trouble aggregating the data by audience (rather than ad group)?

Alex

[edu...@raccoon.ag]

Hey Alex, my problem is getting the list name displayed, using the row iterator. I get the same as the person said in this post, using Criteria, I get

boomuserlist::5776946
Code example:


 var relatorio = AdWordsApp.report(
     'SELECT CampaignName, AdGroupName,Criteria,Cost ' +
     'FROM   AUDIENCE_PERFORMANCE_REPORT ' +
     'DURING YESTERDAY');
 //    'WHERE CampaignName CONTAINS_IGNORE_CASE [n]');
 var iterador_linha = relatorio.rows();

 while (iterador_linha.hasNext()) {
   var line_iterator = iterador_linha.next();
   var campanha = line_iterator['CampaignName'];
   var grupoan = line_iterator['AdGroupName'];
   var alvo = line_iterator['Criteria'];
   var custo = line_iterator['Cost'];
   Logger.log(campanha+" "+grupoan+" "+alvo+" "+custo);

when showed by logger, the "alvo" becomes boomuserlist::5776946, when I wanted like: "RLSA_list_01", or "RLSA_list_02".


Thanks!

[Alexander Wang]

Hi,

I assume I'm talking to you in this other thread as well. I answered there with a bit more detail, but basically this isn't something you can easily do right now.

Alex