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.