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 |