Connect AdRoll to Power BI

Authorize AdRoll in Catchr and select the accessible advertiser. In Catchr’s Power BI query builder, select Date, Cost, Impressions and Clicks and preview a short extraction. Import the generated URL through Get data > Web in Power BI Desktop. Check the returned rows before building measures, keeping advertiser, campaign level and attributed outcomes clear in the model.

Catchr exposes daily advertiser metrics including Cost, Impressions, Clicks, Conversions and Revenue, together with Click Throughs, View Throughs, Click Revenue and View Revenue. These let you track delivery and separate the results credited to clicks from those credited to ad views. Calculate overall ROAS as total Revenue divided by total Cost, using the same date range and currency.

The current connector retrieves performance metrics at advertiser level. It also exposes campaign, ad group and ad information, but these fields do not turn advertiser totals into campaign-level or ad-level performance. Use advertiser and date for spend and conversion charts. Avoid repeating advertiser totals beside every creative: that can overstate results when the rows are added together.

A click-through conversion follows an ad click within the applicable attribution window. A view-through conversion follows an ad impression without a click. Show Click Throughs and View Throughs separately to make that distinction visible, and use their corresponding revenue fields for the same comparison. Do not add these components to the total Conversions field again.

AdRoll credits conversions according to its attribution rules, including eligible ad views. GA4 and your store measure results differently, so their totals need not match. Compare the same advertiser, dates, currency and conversion definition, and check the click and view attribution windows. Catchr reports the values returned by AdRoll; it does not recalculate a new attribution model for your dashboard.

Use ratios of totals for the selected period: Clicks divided by Impressions for CTR, Cost divided by Clicks for CPC, and Cost divided by Conversions for CPA. Format CTR as a percentage and handle zero denominators as blank values. Adding daily rates, or averaging them without weighting, can give misleading totals when daily volumes differ.

Yes. Add Google Ads and Facebook Ads alongside AdRoll to compare spend, impressions and clicks. Align currencies and reporting dates, and label each platform's conversion definition. The same sale may receive credit from more than one platform, so summed platform conversions are not a count of unique orders.