Skip to main content

Peliqan

Try for free
Request a demo

Mailerlite

Campaign Performance

SQL query for Mailerlite

Get the open rate, click rate, and conversion rate for a specific campaign.

SELECT campaigns.name, campaigns.open_rate, campaigns.click_rate, campaigns.conversion_rate FROM campaigns WHERE campaigns.id = campaign_id;

Try this query now in Mailerlite

Mailerlite data model

Mailerlite
Subscribers

View 24 columns
IdString
SentInteger
EmailString
SourceString
StatusString
Optin_ipString
Open_rateInteger
Click_rateInteger
Created_atDate-time
Ip_addressString
Updated_atDate-time
Fields_cityString
Fields_nameString
Opens_countInteger
Opted_in_atString
Clicks_countInteger
Fields_phoneString
Fields_stateString
Fields_z_i_pString
Subscribed_atDate-time
Fields_companyString
Fields_countryString
Unsubscribed_atString
Fields_last_nameString
Mailerlite
Fields

View 6 columns
IdString
KeyString
NameString
TypeString
Is_defaultBoolean
Used_in_automationsBoolean
Mailerlite
Timezones

View 5 columns
IdString
NameString
OffsetInteger
Offset_nameString
Name_for_humansString
Mailerlite
Campaign Languages

View 5 columns
IdString
NameString
Iso639String
DirectionString
ShortcodeString
Mailerlite
Campaigns

Mailerlite
Segments

Mailerlite
Groups

Mailerlite
Automations

Mailerlite
Popup Forms

Mailerlite
Embedded Forms

Mailerlite
Promotion Forms

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.

  • 14-day free trial
  • No credit card needed