JennyKats
Crownpeak (Retired)

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

Labels

Can't find what you are looking for?

Find Answers

Search our DG Forum to find answers to questions asked by other DG users.

Ask a Question

No luck? Ask a question. Our Product and Support teams are monitoring the Forum and typically respond within 48 hours.

Ask a Question