Impressions information from the CampaignService

[Amit Pawar]

Hi Team,

My requirement is to get the impressions, interactions for the campaigns. I don't want to use the reporting service but Campaign service is not having these fields.

I am thinking to use below AWQL but not sure if this is allowed using Compaign service. (I THINK IT WILL NOT WORK)

"SELECT Id, Name, Impressions, Clicks, Cost, Ctr" 

   + "FROM CAMPAIGN_PERFORMANCE_REPORT "

   + "WHERE Impressions > 0 DURING LAST_7_DAYS";

Do you have any suggestions ?

[Anash P. Oommen (AdWords API Team)]

Hi Amit,

Stats are available only through Reports.

Cheers,
Anash P. Oommen,
AdWords API Advisor.

[Amit Pawar]

Can we use AWQL on one of report type? My concern is I don't want to download the report. Requirement is to get impressions and campaign ID and insert into local DB. How to achieve it ?

[Anash P. Oommen (AdWords API Team)]

Hi Amit,

As I mentioned in my previous post, the only way is to download, parse the report, and load the values into local DB. There's simply no workaround for that requirement.

May I ask, why is it that you don't want to download the report?

Cheers,
Anash P. Oommen,
AdWords API Advisor.

[adwor...@emphasizebpo.com]

HI Team, 

For regular basis I want to update clicks and impressions for campaign means same procedure need to follow?

Just take frequency of update as an hour.

So i want to download report every hour , and added to DB then will show in website right?

Regards,

Senthil

[Anash P. Oommen (AdWords API Team)]

Hi Senthil,

This is correct. The only other thing to keep in mind is that AdWords reporting data generally stabilizes after 3 hours, so you'd want to rewrite your database records for the last few hours every time you run a report. Older records can remain as such.

Cheers,

Anash