Connect Vistar Media to Power BI

Connect Vistar Media in Catchr with your Vistar email and password and select an advertiser available to that user. In the Power BI query builder, start with Report Date, Campaign, Impressions and Media Cost over a short period. Preview the rows, copy the generated URL and load it through Get data > Web in Power BI Desktop. Keep advertiser and currency in the model before adding venue or market breakdowns.

The Catchr catalog includes impressions, media cost, client cost, client revenue, fee components and several eCPM measures. You can organize compatible reports by campaign, insertion order, creative, deal, media owner, venue type and supported geographic areas. These fields describe delivery and buying performance; they do not automatically include every measurement study available through Vistar or its partners.

No. A screen can play one ad while reaching an estimated audience of several people. DOOH impressions and the number of plays therefore measure different things, and neither is automatically a count of unique people. Use the Impressions value returned by Vistar as reported. Do not relabel it as unique reach or calculate audience frequency without a compatible reach measure.

Choose the cost basis that matches your Vistar report and business question. Catchr exposes Media Cost and Client Cost, plus separate audience and measurement fees. Media eCPM and Client eCPM also use different cost bases. Do not sum a total and fee components that may already be included in it. Keep the chosen basis visible when comparing campaigns or other media channels.

Yes. Use Venue Type and Media Owner Display Name for inventory analysis, or supported geography fields such as US DMA, US State, Canadian Province or UK TV Area where relevant. Select fields appropriate to the country and the report. Build separate market and venue charts if a more detailed combination is unavailable, and check advertiser access when expected records are missing.

Match advertiser, date range, report time zone, filters and cost basis in both tools. Catchr uses UTC when no report time-zone option is supplied. A different time zone can move delivery across day boundaries, while a different cost measure can change spend without changing impressions. Compare a simple daily table first, then add creative or venue breakdowns one at a time.

The current Catchr Vistar fields focus on delivery and costs; they do not include a complete store-visit or sales-lift study. Those outcomes require a suitable measurement setup and results from that study. You can show Vistar delivery beside GA4 or sales data, but a rise in both during the same period does not by itself prove that DOOH caused the change.

Publish the imported model and configure its credentials and refresh schedule in the Power BI service. Each refresh reruns the saved Catchr request; it does not turn DOOH delivery into a live stream. Use a moving date range when the report should advance automatically, and compare the latest loaded date with the Vistar report before sending client results.