UI and API disagree (Destination URL report)

[adver...@lulusoftware.com]

Hi,

I can't get AdWords' UI and API to agree on the stats for some of my campaigns / ad groups.

I am using following report definition to extract the stats from the API for the month of June:

Enter code here...__rdquery=SELECT AccountDescriptiveName, Month, CampaignName, AdGroupName, Impressions, Clicks, Cost FROM DESTINATION_URL_REPORT WHERE CampaignName IN ['PDF_G_AUS_Search', 'PDF_G_DE_Search_Text_FreeCreator', 'PDF_G_DE_Search_Text_SODA', 'PDF_G_IT_Sse_Creator', 'PDF_G_ROW_SearchEn'] AND AdGroupName IN ['pdfSoftware', 'pdf creator', 'PDF Creator', 'Soda PDF', 'aaWriter', 'pdfConverter_xct'] DURING 20150601,20150630&__fmt=CSV

The API response looks like this:
Account,Month,Campaign,Ad group,Impressions,Clicks,Cost
Soda English Markets,2015-06-01,PDF_G_ROW_SearchEn,aaWriter,183,7,3730000
Soda English Markets,2015-06-01,PDF_G_ROW_SearchEn,pdfConverter_xct,3130,164,43880000
Soda English Markets,2015-06-01,PDF_G_ROW_SearchEn,aaWriter,364,22,9130000
Soda English Markets,2015-06-01,PDF_G_DE_Search_Text_FreeCreator,PDF Creator,12074,765,361770000
Soda English Markets,2015-06-01,PDF_G_DE_Search_Text_SODA,Soda PDF,5049,921,128080000
Soda English Markets,2015-06-01,PDF_G_ROW_SearchEn,pdfSoftware,649,49,12850000
Soda English Markets,2015-06-01,PDF_G_ROW_SearchEn,pdfSoftware,649,55,13850000
Soda English Markets,2015-06-01,PDF_G_ROW_SearchEn,pdfSoftware,660,69,18850000
Soda English Markets,2015-06-01,PDF_G_DE_Search_Text_FreeCreator,PDF Creator,2244,119,59340000
Soda English Markets,2015-06-01,PDF_G_ROW_SearchEn,aaWriter,146,6,2960000
Soda English Markets,2015-06-01,PDF_G_ROW_SearchEn,pdfSoftware,661,57,15580000
Soda English Markets,2015-06-01,PDF_G_IT_Sse_Creator,aaWriter,895,121,49600000
Soda English Markets,2015-06-01,PDF_G_IT_Sse_Creator,aaWriter,848,106,44050000
Soda English Markets,2015-06-01,PDF_G_AUS_Search,pdfSoftware,273,6,2680000
Soda English Markets,2015-06-01,PDF_G_DE_Search_Text_FreeCreator,PDF Creator,12648,853,396780000
Soda English Markets,2015-06-01,PDF_G_ROW_SearchEn,pdfConverter_xct,3218,160,41980000


I have attached a screenshot of the above campaigns and ad groups as seen in the UI. The stats from the UI exceed significantly the API. I don't understand why the UI and API disagree for these campaigns / ad groups. For the rest of my AdWords - everything is a perfect match...

Your ideas are very appreciated!

[Anthony Madrigal]

Hi,

You could try creating the Destination URL Report through your UI by going to Dimensions and changing your view from Month to Destination URL. 

If your stats still do not match with your API report, then feel free to let me know.

Cheers,

Anthony

AdWords API Team

[adver...@lulusoftware.com]

Hi Anthony,

Thanks for your reply. I apologize for the delay in my post - I was away last week but now I am finally back. After taking a closer look to my issue I can confirm that the discrepancy is related only to the Upgraded URL ads.
The Upgraded URL ads are not showing at all in the API. What should we do?

Looking forward hearing back from you,
Veselin.

[Anthony Madrigal]

Hi Veselin,

It appears that most of your ads are still using destination URLs instead of final URLs. You will need to upgrade your URLs. You can refer to this guide to help you migrate to the new URLs.

[adver...@lulusoftware.com]

Thanks Anthony,

We are in process of migrating our ads. It may take some time before everything it is all done.
How can we use the API to download reports for the ads that are already migrated?

Let me know.
Veselin

[Anthony Madrigal]

Hi Veselin,

While you wait for your migration to be completed, you can run an Ad Performance Report using a predicate where the CreativeFinalUrls != " ". Using that predicate will find all Final URLs that exist.

Regards,

Anthony

AdWords API Team

[adver...@lulusoftware.com]

Hey Anthony,

Thanks for suggesting a workaround - it does the job done for the moment. When can we expect Google to bring DESTINATION_URL_REPORT up to speed?

Cheers,
Veselin

[Anthony Madrigal]

Hey Veselin,

Unfortunately, there is no set timeframe as to when it will be up to speed.

Please check out our blog regarding this and any other updates.