Get Message ID and content in Campaigns search

  • 44Views
  • Last Post 02 September 2022
0
votes
Kronda Adair posted this 26 August 2022

I really want to be able to get the following from an Active Campaign account search: 

  • from name,
  • from email,
  • pre-header, and
  • email content (text) 

I can't get this information when I run a search in Campaigns, but I'm told that this information used to be available. Can you bring it back? 

If I run a search in Messages I can get the above information but I get it for every person who received the email and I can't link it to a campaign.

 

Attached Files

Order By: Standard | Newest | Votes
0
votes
Serhii Muzyka posted this 31 August 2022

 Hello Adair,

 

Thank you for contacting Skyvia Support.

 

We will investigate your situation and will get back to you with the result as fast as possible.

 

Best regards,

Serhii

Technical Support Engineer

0
votes
Serhii Muzyka posted this 02 September 2022

Hello Adair,

Thanks for your time and patience on this request. 

 

We have added MessageId column to Campaigns table. This column will link to Messages table and you will be able to see your data.

Please use Query builder

or SQL request  

SELECT Campaigns.Id, Campaigns.Name, Messages_Campaigns_MessageId.FromName, Messages_Campaigns_MessageId.FromEmail, Messages_Campaigns_MessageId.PreheaderText, Messages_Campaigns_MessageId."Text", Messages_Campaigns_MessageId.Html
FROM Campaigns
LEFT OUTER JOIN Messages AS Messages_Campaigns_MessageId ON Campaigns.MessageId = Messages_Campaigns_MessageId.Id

Should you have other questions, don't hesitate to reach out.

 

Best regards,

Serhii

 

Technical Support Engineer

Close