Import CPC Cost Data do not work

[JohnnyBrix]

Hi, I am trying to start tracking Google Adwords in urchin 6.6. Test
CPC Source is successful. The download from my Google Adword Account
seems to run without problems. But there are either cost data nor
counts for impressions in the Advertisement Optimization. Am I right
in thinking Urchin can not read this data from the Google adword
report? Is it a problem in Urchin or in Google Adwords?

Regards, Johnny

[Jeremy Aube]

Hi Johnny,

Are you manually tagging your AdWords destination URLs? Urchin can't
read the gclid parameter used in autotagging, so you need to either
manually tag or use master codes. These parameters need to be present
in both the destination URL and the landing page and read correctly by
your UTM code. If Urchin is unable to attribute visitor activities on
the site to a specific AdWords campaign, then it won't be able to
match up cost data to those visits either.

Jeremy Aube
http://www.roirevolution.com/urchin

[JohnnyBrix]

Hi Jeremy, thanks for helping. Now we are using Master Codes with the
lookup table filter (utm_id). Yes, Urchin indicates the campaigns like
before. Do you understand the destination URL as a page defined as a
goal? However, at next we have to fix this failure message in the CPC
Download History: I've read this failure here many times, But no one
could give a clear answer.
So, I hope know it,s the time ...

------------------------------------------------------
Urchin 6.601 (linux2.6_kernel) starting: 20100119 17:23:10
------------------------------------------------------

[Tue Jan 19 17:23:10] Processing CPC account structure 'Google
Adwords' (adwords) on slavexx

[Tue Jan 19 17:23:10] Data directory seems corrupt. Trying to restore
from the backup...
[Tue Jan 19 17:23:10] Failed restoring data from the backup. Full cost
source synchronization will be performed

Worker 19645: Requesting data for 2010-01-19 - 2010-01-19
ERROR (6002-867-316) SOAP Fault in getAllAds (faultcode 44): This
parameter or field must not be null.

[Tue Jan 19 17:23:12] CPC data download FAILED. Units consumed: 3

Can you help me in this issue too?
Greets, Dirk

On 18 Jan., 13:43, Jeremy Aube <ja...@roirevolution.com> wrote:
> Hi Johnny,
>
> Are you manually tagging your AdWords destination URLs? Urchin can't
> read the gclid parameter used in autotagging, so you need to either
> manually tag or use master codes. These parameters need to be present
> in both the destination URL and the landing page and read correctly by
> your UTM code. If Urchin is unable to attribute visitor activities on
> the site to a specific AdWords campaign, then it won't be able to
> match up cost data to those visits either.
>

> Jeremy Aubehttp://www.roirevolution.com/urchin

[JohnnyBrix]

OK, now Urchin_help advise me to download manually a .tsv file from
Google Adwords Reports. But where I have to put them in order that
Urchin can read the cpc cost data?

#Please enlighten me. Many Greets,
Johnny

[Marcus]

Hi Johnny,

> OK, now Urchin_help advise me to download manually a .tsv file from
> Google Adwords Reports. But where I have to put them in order that
> Urchin can read the cpc cost data?

I've got a similar problem like yours, I see successfull accesses to
the cpc
source in the scheduler logs, but all data being downloaded into the
data/cpc
directory is like this one:

/usr/local/urchin/data/cpc/1/1# unzip -l 5a3d9f1a.zip
Archive: 5a3d9f1a.zip
Length Date Time Name
-------- ---- ---- ----
0 02-08-10 15:13 5a3d9f1a.cpc
12 02-08-10 15:13 .5a3d9f1a.lasthit
-------- -------
12 2 files

I trigger the cpc request via scheduler at 2:00 o'clock in the morning
and
much later the day, according to the timestams, the data file (the zip
archive)
is being downloaded from the google server.

In my case, the data file is quite useless, as you can see the cpc
file has a
size of zero bytes.

Recently I found the log in the adwords webinterface that keeps
telling
me that the cpc request my scheduler issued was about data for the
last 10 years? Oh, just had a look in the cpc scheduler logs and
there:

Urchin 6.602 (linux2.6_kernel) starting: 20100208 15:08:50
[Mon Feb 8 15:08:50] Processing CPC logs 'cpc one' (adwords)
Worker 32005: Requesting data for 2000-01-02 - 2010-02-07

This is from the run which resulted in the zero byte file, I posted
at the beginning.

As you can see, we are running urchin 6.602, but we had the same
issues with 6.601. I was in hope the update would solve my problems.

kind regards,
Marcus

[Johnny Brix]

Hi there, now I become more clever. Urchin downloads the CPC Log Data
and the CPC Account Data. But still it is not perfect. Not all of the
Campaigns in Adwords are shown in CPC Structure though I am using
keyword insertion. Perhaps keyword insertion is not completely
embedded. Is it neccessary to do keyword insertion in each ad group?
Have I go like this:

www.example.com?utm_id=1&kw={keyword:null}

Thanks for helping, Johnny