Campaign Performance Report don't return one campaign

[Spain Api]

Hi all!

I'm trying download a specific campaign (id:  598878691)  with date range "01/01/2017 - 04/12/2017", but the report return zero rows.

However, i can see the data in campaign management from google adwords and I can too download your data in AD_PERFORMANCE_REPORT.

I'm using v201710 api version, and my query is:

select CampaignId, CampaignName, CampaignStatus, StartDate, EndDate, AverageFrequency, ImpressionReach, SearchImpressionShare, SearchRankLostImpressionShare, SearchBudgetLostImpressionShare, VideoQuartile25Rate, VideoQuartile50Rate, VideoQuartile75Rate, VideoQuartile100Rate, AdNetworkType1 from CAMPAIGN_PERFORMANCE_REPORT where CampaignId = 598878691 during 20170101, 20171204

Can someone help me, please?

Thanks.

[Bharani Cherukuri (AdWords API Team)]

Hello, 

I am able to download the report using the details provided. It looks like you're running the Campaign Performance Report with includeZeroImpressions set to false and hence the the report returns zero results. You will have to set the includeZeroImpressions field to true in your report definition and the API will return results for the rows which do not have any stats. Could you check if that might be the case?

Regards,

Bharani, AdWords API Team

[Spain Api]

Hello,

When adding includeZeroImpressions I can get the report with the requested campaign, but I receive the campaign four times. Once per network field.

Although in reality, only the campaign with the network "Display Network" is correct.

Is there any way to get just that network?

Regards,
Thanks.

[Bharani Cherukuri (AdWords API Team)]

Hello, 

The Campaign Performance report includes statistics aggregated at campaign level with one row per campaign. If you're using any segment fields, in this case AdNetworkType1, the data in the report is split into various segments, one for each network type. 

If you're looking to pull metrics for a specific network type, you could use the WHERE clause as below: 

String query = "SELECT CampaignId, CampaignName, CampaignStatus, StartDate, EndDate, AverageFrequency, ImpressionReach, SearchImpressionShare, SearchRankLostImpressionShare, SearchBudgetLostImpressionShare, VideoQuartile25Rate, VideoQuartile50Rate, VideoQuartile75Rate, VideoQuartile100Rate, AdNetworkType1 FROM CAMPAIGN_PERFORMANCE_REPORT WHERE CampaignId = 598878691 AND AdNetworkType1 IN [CONTENT] DURING 20170101, 20171204"

The enum value Content is used for the Display network type. Can you try with this query and let me know if you have any other questions.

Regards,

Bharani, AdWords API Team

On Monday, December 4, 2017 at 6:31:36 AM UTC-5, Spain Api wrote:

[Spain Api]

Hello Bharani!

The problem is that I don't know the network type, so I can't set the condition AdNetworkType1 IN [CONTENT].

Is there any way to get the type of network of a campaign, but without segmenting it?

Regards.

[Bharani Cherukuri (AdWords API Team)]

Hello, 

From what I understand, you're trying to retrieve the Campaign name and its corresponding network type. If that's the case, you could use several report types to pull this information. The segmentation will be applied depending on the report query. In the scenario mentioned above, the stats will be returned for each segmented field with one row per campaign. You can also refer to this guide as a reference.

Could you please elaborate your specific use case, so I can take a look and assist you further?

Regards,

Bharani, AdWords API Team

On Monday, December 4, 2017 at 6:31:36 AM UTC-5, Spain Api wrote:

[Spain Api]

Hi Bharani!

As far as I can see, your query only returns rows if the requested campaign has data for the indicated date range.

For example, if I request a report from 01/12/2016 to 04/12/2017 in "Campaign Performance" without the includezeroimpressions = true, it does not return rows; however, if I request data for the range of dates from 05/23/2016 to 01/01/2017 (which is the campaign's life period), this should return rows to me; however, the query is not returning rows and that I do not understand.

What I need is very simple, I already have the data of the campaign because at some point, I got that data, but, now to the query that I had, I have added that also get the field "AdNetworkType1" for me know the type of network the campaign belongs to, that is, I want to update my campaign data including the new field in the query.

Is that possible?

Thanks.

El lunes, 4 de diciembre de 2017, 12:31:36 (UTC+1), Spain Api escribió:

[Bharani Cherukuri (AdWords API Team)]

Hello, 

Here is brief summary of the discussion on the private thread, so it might help other forum users who are following this post:

The Campaign Performance Report will not return metrics if there is no data available for the specified date range when the includeZeroImpressions field is set to zero. On the other hand, if the campaign has metrics for that specific date range, this will return the data based on the request query and segmented fields in your reports.

Feel free to open a new thread for any new concerns, so our team can take a look.