Yelp Ads

The table below gives information about all the data fields that you can import from Yelp Ads.

 

Field UI name

Field API name

Data Type

Description

Use in Adriel

Ad Cost

ad_cost

currency

Total number of advertising cost.

metric

Ad Cost Currency

ad_cost_currency

string

Advertising Currency

dimension

Billed Clicks

billed_clicks

long

Number of billed ad clicks.

metric

Billed Impressions

billed_impressions

long

Number of billed ad impressions.

metric

Ad Driven Bookmarks

bookmarks

long

Number of times a business has been bookmarked by users that can be attributed to an Ad impression.

metric

Business Coordinates Latitude

business_coordinates_latitude

float

The latitude of this business.

dimension

Business Coordinates Longitude

business_coordinates_longitude

float

The longitude of this business.

dimension

Business Display Address

business_display_address

string

Business address that is in the standard address format for the business's country.

dimension

Business ID

business_id

string

Unique Yelp ID of this business. Example: '4kMBvIEWPxWkWKFN__8SxQ'

dimension

Business Image URL

business_image_url

string

URL of photo for this business.

dimension

Business Name

business_name

string

Name of this business.

dimension

Business URL

business_url

string

URL for business page on Yelp.

dimension

Ad Driven Calls

calls

long

Number of phone calls initiated from the Yelp business profile that can be attributed to an Ad impression.

metric

Ad Driven Check Ins

check_ins

long

Number of mobile check-ins from the Yelp business profile that can be attributed to an Ad impression.

metric

Ad Driven CTA Clicks

cta_clicks

long

Number of Call-to-Action clicks on desktop devices that can be attributed to an Ad impression.

metric

Deals Sold

deals_sold

long

Number of deals sold.

metric

Ad Driven Deals Sold

deals_sold

long

Number of deals sold that can be attributed to an Ad impression.

metric

Ad Driven Directions And Map Views

directions_and_map_views

long

Number of direction and map views from the Yelp business profile that can be attributed to an Ad impression.

metric

Ad Driven Messages To Business

messages_to_business

long

Number of messages sent to a business, including messages sent through Request a Quote that can be attributed to an Ad impression.

metric

Num Bookmarks

num_bookmarks

long

Number of times a business has been bookmarked by users.

metric

Num Calls

num_calls

long

Number of phone calls initiated from the Yelp business profile.

metric

Num Check Ins

num_check_ins

long

Number of mobile check-ins from the Yelp business profile.

metric

Num Desktop CTA Clicks

num_desktop_cta_clicks

long

Number of Call-to-Action clicks on desktop devices.

metric

Num Desktop Page Views

num_desktop_page_views

long

Number of page views on desktop devices.

metric

Num Desktop Search Appearances

num_desktop_search_appearances

long

Number of times a business appeared in search on desktop devices.

metric

Num Directions And Map Views

num_directions_and_map_views

long

Number of direction and map views from the Yelp business profile.

metric

Num Messages To Business

num_messages_to_business

long

Number of messages sent to a business, including messages sent through Request a Quote.

metric

Num Mobile CTA Clicks

num_mobile_cta_clicks

long

Number of Call-to-Action clicks on mobile devices.

metric

Num Mobile Page Views

num_mobile_page_views

long

Number of page views on mobile devices.

metric

Num Mobile Search Appearances

num_mobile_search_appearances

long

Number of times a business appeared in search on mobile devices.

metric

Num Total Page Views

num_total_page_views

long

Number of total page views on desktop and mobile devices.

metric

Num User Photos

num_user_photos

long

Number of user generated photos added to the Yelp business profile.

metric

Online Booking

online_bookings

long

Number of online bookings.

metric

Online Orders

online_orders

long

Number of online orders.

metric

Online Reservations

online_reservations

long

Number of Yelp Reservations and Yelp Nowait bookings that can be attributed to an Ad impression.

metric

Program ID

program_id

string

Program identifier

dimension

Program Type

program_type

string

Indicates the type of program. Possible values are: `BP` – Branded Profile, `EP` – Enhanced Profile, `CPC` – Cost per click ads.

dimension

Tracking Calls

tracking_calls

long

Number of calls tracked.

metric

URL Clicks

url_clicks

long

Number of clicks to the business URL from the Yelp business profile.

metric

URL Clicks

url_clicks

long

Number of clicks to the business URL from the Yelp business profile that can be attributed to an Ad impression.

metric

Ad Driven User Photos

user_photos

long

Number of user generated photos added to the Yelp business profile that can be attributed to an Ad impression.

metric

If you require help with this topic, please contact Adriel Support using the chat box