Linking Double Click URL with desination URL

[Rik Hepburn]

Hi Everyone,

 

I have a question which i'm hopeful is a simple one to answer:-

 

In our tracking database (Kiss metrics) we record each outbound link, which in our instance looks like

http://pubads.g.doubleclick.net/gampad/clk?id=79863578&iu=/5527/P5527.home

but what we actually need to record in our system is the end destination URL http://www.Clientsite.co.uk

Does anyone know whether it's possibel to marry up the 2 through the double click database?

 

What exactly does the clk?id=79863578 refer to?

 

If anyone can help it would greatly appreciated.

 

Many thanks,

 

Rik.

[Adam Rogal (DFP API Team)]

Hi Rik,

You can see what each GET parameter does here:

http://support.google.com/dfp_premium/bin/answer.py?hl=en&answer=1638620

In this case,where you have ?id=79863578, that represents line Item 79863578 within order 132530738.

Typically, what publishers do is generate a report that includes the dimensions Dimension.LINE_ITEM_ID and Dimension.CREATIVE_ID, and the dimension attribute DimensionAttribute.CREATIVE_CLICK_THROUGH_URL.

Which in this case would be:

http://www****ntybabynames?channel=4979 (****s are there for privacy)

The reason you need to run a report is that multiple creatives can be associated to the same line item and, at the time of ad serving, which creative was served is not known. If you only have 1 creative per line item, you could in theory download the LineItemCreativeAssocation from the LineItemCreativeAssociation service using getLineItemCreativeAssociationsByStatement with a filter of "WHERE lineItemId=79863578".

I highly suggest using a report though since it should have all the information you need. If you need any code examples showing you how to generate a report, please let me know.

Thanks,

Adam Rogal, DFP API Team

[Rik Hepburn]

Hi Adam,

 

Many thanks for the comprehensive reply. It's great to know i can link the 2 up.

 

I think i'll attempt to extract the data through a report rather than using the API as you suggest. Am i able to extract the information through the reporting area of the website?

 

Thanks,

Rik.

[Rik Hepburn]

Hi Adam,

 

Just want to make sure i am completely clear on this.

 

We have on our site various Ad units, in which we can serve various line items throughout the day. In 99% of cases we will have 1 creative per line item.

 

Using the technique you have stipulated we are able to link up a) The Doublclick URL the consumer clicked on with b) The correct Creative Click Through URL?

 

I've had a look through the reporting section of DFP, however cannot see  Dimension.LINE_ITEM_ID, Dimension.CREATIVE_ID or DimensionAttribute.CREATIVE_CLICK_THROUGH_URL anywhere. I presume these are not accesible through this way?

 

What is the easiest way to generate a report like this? If you are able to send through code example as per your previous note that would be greatly appreciated.

 

Kind Regards,

[Rik Hepburn]

Hi Adam,

Just want to make sure i am completely clear on this.

We have on our site various Ad units, in which we can serve various line items throughout the day. In 99% of cases we will have 1 creative per line item.

Using the technique you have stipulated we are able to link up a) The Doublclick URL the consumer clicked on with b) The correct Creative Click Through URL?

I've had a look through the reporting section of DFP, however cannot see Dimension.LINE_ITEM_ID, Dimension.CREATIVE_ID or DimensionAttribute.CREATIVE_CLICK_THROUGH_URL anywhere. I presume these are not accesible through this way?

What is the easiest way to generate a report like this? If you are able to send through code example as per your previous note that would be greatly appreciated.

Kind Regards,

Rik.

On Friday, 4 January 2013 00:49:56 UTC, Adam Rogal (DFP API Team) wrote:

[Adam Rogal (DFP API Team)]

On Friday, January 4, 2013 8:07:49 AM UTC-5, Rik Hepburn wrote:

Hi Adam,

 

Just want to make sure i am completely clear on this.

 

We have on our site various Ad units, in which we can serve various line items throughout the day. In 99% of cases we will have 1 creative per line item.

 

Using the technique you have stipulated we are able to link up a) The Doublclick URL the consumer clicked on with b) The correct Creative Click Through URL?

Yes. If and only if there is one ad id per creative. 

 

 

I've had a look through the reporting section of DFP, however cannot see  Dimension.LINE_ITEM_ID, Dimension.CREATIVE_ID or DimensionAttribute.CREATIVE_CLICK_THROUGH_URL anywhere. I presume these are not accesible through this way?

I believe if you include the Line Item breakdown, when exporting the report, it will include the ID. I am not sure about the clickthough URL.

 

 

What is the easiest way to generate a report like this? If you are able to send through code example as per your previous note that would be greatly appreciated.

What coding language would you be most comfortable in?

[Rik Hepburn]

Hi Adam,

I believe we are most accomplished in PHP. If you could advise some coding examples for that it would be greatly appreciated.

Kind Regards,

Rik.

[Adam Rogal (DFP API Team)]

Hi Rik,

Please take a look at the PHP client library: http://code.google.com/p/google-api-dfp-php/

The examples in this folder should help you out: http://code.google.com/p/google-api-dfp-php/source/browse/#git%2Fexamples%2Fv201211%2FReportService

Thanks,

Adam Rogal, DFP API Team