Connect MailerLite to Power BI

Create a MailerLite connection in Catchr using your API token. In Catchr’s Power BI query builder, select campaign name, sent emails, unique opens and unique 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 campaign IDs and the age of each campaign when its counters were read clear in the model.

You can report on sends, opens, unique opens, clicks, unique clicks, unsubscribes, spam complaints, and hard and soft bounces. Campaign name, type, status, and scheduling fields provide context for those results. Keep counts alongside rates so that a small campaign with a high percentage does not overshadow a larger campaign with more responses.

Yes. Catchr exposes automation names and IDs, step details, and email statistics such as sends, unique opens, unique clicks, and unsubscribes. Compare email steps within a workflow to identify where engagement falls. Keep automation step statistics separate from newsletter campaign totals so that different reporting levels are not added together.

One recipient can open an email more than once, so total opens can exceed unique opens. The same distinction applies to total and unique clicks. Use the unique metric when comparing how many recipients interacted with each send, and do not add campaign-level unique counts to estimate a distinct audience across several emails.

Use the numeric rate fields and format them as percentages in Power BI. MailerLite returns numeric fractions, so 0.25 represents 25%, not 0.25%. Do not sum rates across campaigns. For an overall rate, calculate it from the appropriate summed counts and denominator, using a consistent definition for every campaign.

First check the campaign status and whether it has actually been sent. A draft or scheduled campaign is not comparable with a completed send, and an email with open tracking disabled cannot provide the same open statistics. Also verify the account, date field, and filters used in the chart before treating a blank metric as zero performance.

Yes. Use a separate GA4 data source to compare email clicks with website sessions and key events. Tag email links consistently and align the campaign labels and dates before creating relationships data. MailerLite counts email interactions, while GA4 measures tracked activity on your site, so a one-to-one match is not expected.