Connect Pinterest Organic to Power BI

Authorize the Pinterest account in Catchr with access to its analytics. In Catchr’s Power BI query builder, select Impressions, Saves and Outbound Clicks for a recent period 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 account totals versus individual Pin reporting clear in the model.

Pin clicks measure interactions with a Pin, while outbound clicks specifically measure actions leading to a destination outside Pinterest. Use Outbound Clicks when evaluating traffic sent to your website, and Saves to understand content people want to revisit. Neither measure is a purchase or a unique visitor count. Compare website outcomes with GA4 using consistent campaign tagging, while allowing for differences between clicks and recorded sessions.

Yes. Add the separate Pinterest Ads source for spend and campaign reporting. Before combining totals, use the Source breakdown in account analytics to inspect the traffic categories returned and select the relevant organic data. A Pin's Has Been Promoted attribute is not a date-specific paid-traffic filter. Do not add account analytics to ad metrics without checking overlap, or the same delivery may be counted twice.

Catchr exposes account breakdowns for Pin Format, App Type, Owned Content, and Source, with one of those breakdowns per request. Use separate charts when comparing format and app type. The catalog also contains Pin metadata such as title, link, and board ID, but do not assume every metadata field can be joined to performance metrics. Validate a Pin-level chart against the same Pin in Pinterest before using it for rankings; use account-level charts when that match cannot be confirmed.

Pinterest documents a 90-day lookback for dated organic reporting on accounts and Pins. Lifetime statistics are a separate capability and are not interchangeable with a daily history. Start with dates inside the supported window; a wider Power BI date range cannot recover data the endpoint no longer returns. If you need longer trends, retain dated exports or snapshots before older periods leave the available reporting window.

The follower count in Catchr's user metadata is a current account value, not a dated series of followers gained and lost. Record snapshots separately to measure growth. For engagement and outbound click rates across several days, divide the summed matching actions by summed impressions instead of adding percentages or averaging daily rates without weights. Impressions count appearances, not unique people, and engagement rate should not be presented as audience reach.

Pinterest distinguishes video starts, video views, ten-second views, and plays to 95%; those measure different viewing thresholds. Catchr also labels video play-time fields in milliseconds, so check units before comparing them with a display in minutes. Pinterest says real-time Pin statistics are estimates that can change and may differ from Pinterest Analytics. Compare the same dates, traffic scope, metric, and unit, and allow recent figures to settle before diagnosing a discrepancy.