DG and Privacy UX
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Consent Solutions Knowledge Base

Identifying ad Notice creator (1c of 2c)

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.

 Screen Shot 2019-01-29 at 5.23.46 PM.png

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

 

 Screen Shot 2019-01-29 at 5.28.11 PM.png

Labels (1)
Comments

From where I can get Client Id and Notice Id?

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

Version history
Revision #:
1 of 1
Last update:
‎04-17-2019 06:20 AM
Updated by:
 
Contributors
Looking for more?
Ask in Discussions
Developers

Peer-to-peer support  and answers on developing CMS templates, modifying privacy scripts or building integrations.

Digital Experience Management

Find answers and ask questions on content management, personalization and targeting.

Digital Quality Management

Find answers and ask questions on WCAG and SEO quality management.

Digital Governance

Find answers and ask questions on consent and monitoring solutions.