Identifying ad Notice creator (1c of 2c)

[JennyKats]

User Info, Company Info, Ad Notice info based on Ad Notice ID

Given ad notice id 70473 , this guide will highlight the BA database tables responsible for this ad notice’s configuration and how to retrieve this data.

 

The ad notice query string contains the ad size, company id, and notice id. This call can be found in the web inspector of common browsers. Using this method, you can identify the origin of the ad notice on a live site.

nid=70473 will be a column in the table ad_notice. This table is found in BA.

The relationship between user and company is consistent with all BA referenced tables.

The following query is an example of how these tables fit together.

SELECT c.company_name, u.user_name, a.an_internal_name

FROM ad_notice as a

left outer join company as c on c.company_id = a.an_company_id

left outer join user as u on u.user_id = a.an_created_by_user_id

WHERE a.an_id = 70473

 

[xpertnauman]

From where I can get Client Id and Notice Id?

[CP_Product]

Hi -

Please see my response in the developer's discussion board -

https://community.crownpeak.com/t5/Developer-Questions/Evidon-adchoice-icon-in-appnexus/m-p/5412#M13...

All the best,

Denise