Skip to main content

Introduction

Yelp is a local business listing and advertising platform. This connector pulls both organic engagement signals (page views, calls, directions, reviews, and ratings) from the Yelp business profile and paid advertising performance (impressions, clicks, ad cost, and ad-driven conversions) for any advertising programs associated with the connected businesses, using the Yelp Reporting API v3. Reports are requested asynchronously, polled until ready, and then cached per asset and served from cache to the dashboard. Both business-level (organic) and program-level (advertising) metrics are available, and the metric set is automatically narrowed by the breakdown applied to a widget. As a marketing connector, metrics, breakdowns, and currencies are standardized so widgets can aggregate across sources without additional configuration. To connect this data source, see How to connect Yelp to Adriel.

Data refresh strategy

Architecture data

Business listings and any associated advertising programs are discovered through the Yelp Fusion API at connection time and on subsequent refreshes. Newly added businesses become available after the next refresh cycle.

Reports data

This is a simple-cache connector. For each collection, report data is fetched again on every refresh and the cache is replaced atomically, so the dashboard always reads from the cache rather than the live API. The default cadence is every 6 hours, at 0 minutes past the hour (UTC). Each refresh requests a rolling 88-day report window.

Architecture levels

Yelp account → Business (location) → Advertising program

Date range limits

Date ranges that exceed the maximum query window are rejected at validation.

Metrics

Yelp is a schema-flexible source. The fields below are the standard fields Adriel exposes; the exact fields you can report on depend on your Yelp data. Data type uses Adriel’s vocabulary; API Key in code style is the literal source field; italic marks a value Adriel derives.

Yelp fields

Date Calculation

Breakdowns

Yelp fields

General

Date

Limitations

  • Metric availability follows the breakdown — business and advertiser metrics cannot be combined under a business or program breakdown; use no breakdown or a time breakdown to see both sets together.
  • Ad cost reported in centsad_cost is reported in cents at the source, with the currency provided separately by ad_currency. It is converted to major units only under the program breakdown; under a date breakdown the value remains in cents.
  • Single currency per data source — the currency from the first advertising program encountered is applied to the data source; programs reporting a different currency are not tracked separately.
  • Business must have reviews — a Yelp business with no reviews cannot be connected (a Yelp API requirement).
  • No deleted-data exclusion — deleted or historical data is not filtered out separately by this connector.

API references

See also