Re: syncronizing the Google Adwords data with my local database

2011-06-24 Thread jstedman
DungCoi

If your database structure was designed to suit the old Google report
structure then you will either have to modify the structure of the
report after downloading it, or redesign your database to match the
new structure. One thing that might make this easier is the fact that
the fields in the downloaded report will be in the same order as that
of the String[] you pass into your Selector.

I solved this problem by merging three reports into one because our
structure mixes AdGroup, Keyword, and Campaign level data in one
table. The new structure is more storage efficient, but there are more
important things than storage sometimes.

Ales:

Since the v201101 cross client reporting is not supported yet, you can
still use the v13 ReportService to get cross client reports.

The v201101 reports do require us to get more than one report and
merge the contents on the client side in order to achieve what was
supported in the old API, but the reports are synchronously generated.
You request them by http get and they are ready in seconds, as opposed
to the old report service where you could be waiting for a
while(minutes, hours in some rare cases) before a report is actually
ready. This may not be the case with v201101 cross client reports when
they are released, but for single client reports, it is very fast.

Also, using the new reporting you just define the report one time,
then the ReportDefinition id can be reused to download a report on a
sliding date scale. So if you define a report with sliding date scale
of YESTERDAY, you can issue the same report definition id every day
and get the new report without making any api calls at all.

Fewer API calls means faster service for everyone and no unit cost on
downloading reports that you have already defined.

It does cost 400 units to define a report, or modify a definition, but
once it is defined, it is free to download.

The default is to return 0 impression adgroups, try not specifying any
predicates in your selector. Also, the code in your original post
tells us nothing about the way you are setting up your request through
the Google API. If we could see your Selector code it would be easier
to help you.

This link will probably help both of you if you have not seen it
already:

http://code.google.com/apis/adwords/docs/reportingtopics.html

And this one has all the report types and all fields available in
each:

http://code.google.com/apis/adwords/docs/appendix/reports.html

Hope this helps!

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en


Re: syncronizing the Google Adwords data with my local database

2011-06-23 Thread Ales Sturala
I'm joining this request. Structure report does not work on MCC level
and if I'm not mistaken you have to make 4 structure reports to get
campaigns, adgroups, ads and keywords. So for example for MCC with 80
accounts you have to do 80x4 report requests.

Performance reports, such as adgroup performance report where I can
ask for adgroups on MCC level, do not contain zero impression adgroups
so lot of elements is missing there (this is actually related to my
post in another opened thread; my desire there is to download the
accounts structure too).

On Jun 23, 3:41 am, DungCoi  wrote:
> How to syncronizing the Google Adwords data with my local database. Please
> help.

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en


syncronizing the Google Adwords data with my local database

2011-06-22 Thread DungCoi
How to syncronizing the Google Adwords data with my local database. Please 
help.

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en