Brand Campaign Locations

Paid Search and Banner Ad Campaign Locations

This category contains the location data for where localized paid search and banner ad campaigns are running.
Locations may be around a city, or may cover an entire state (in which case, city will be blank).

Grain: Each row in this table represents a single paid search/banner ad campaign location. There may be many locations tied to a single paid search/banner ad campaign.

Key Name Description
Address 1 Address line 1 of where the campaign is running.
Address 2 Address line 2 of where the campaign is running.
P  Campaign Order ID The unique identifier for a campaign order.
City  The city where the campaign is running.
 Country The country where the campaign is running.
 Latitude The latitude location where the campaign is running.
 Longitude The longitude location where the campaign is running.
Postal Code The postal code location where the campaign is running.
Radius The radius around the location where the campaign is running.
State The state where the campaign is running.

Joins

Category Type
Paid Search and Banner Ad Campaign Locations: Paid Search and Banner Ad Campaigns Inner join. Each record in Paid Search and Banner Ad Campaigns may have 0 to Many Paid Search and Banner Ad Campaign Locations records.