Unlock Salesforce Marketing Cloud Data Views with Generative AI

Introduction to SFMC Data Views

Salesforce Marketing Cloud System Data Views are a goldmine of insights—from subscriber behaviors to email engagement metrics. Traditionally, accessing these Data Views requires SQL expertise, but QAiry simplifies everything by letting you query in plain language.

Data Views & Applications

Below are some of the key SFMC Data Views, their primary use cases, and example QAiry prompts:

_Subscribers

Contains subscriber details, such as email address, status, bounce counts, etc.

Prompt Example: "Show me all active subscribers and their email addresses."

_Sent

Logs send data like delivery status, domain, and send date.

Prompt Example: "How many emails were sent to Gmail users last month?"

_Open

Records open events and unique subscriber engagement data.

Prompt Example: "Which email had the highest open rate yesterday?"

_Click

Tracks click events and link-level performance metrics.

Prompt Example: "What are the top 5 most-clicked links this week?"

_Bounce

Captures bounce events and reasons to refine deliverability strategies.

Prompt Example: "How many emails bounced for invalid addresses last week?"

_Journey

Monitors engagement and performance in Journey Builder campaigns.

Prompt Example: "Which journeys have the highest engagement rates?"

Sample insights generated via QAiry prompts in Salesforce Marketing Cloud Engagement

How QAiry Works

QAiry uses natural language processing to translate everyday questions into Salesforce Marketing Cloud SQL queries. This eliminates the need for users to manually craft or troubleshoot SQL statements.

No Coding Required: Simply pose your question in plain text.
Instant Insights: Quickly understand campaign performance without reliance on technical teams.
Holistic Reporting: See trends, anomalies, and opportunities hidden in your SFMC data.

Advanced Query Use Cases

Here are several advanced ways QAiry can help drive impactful marketing decisions:

Behavioral Segmentation

Create custom segments based on open or click activity.

Prompt: "Find subscribers who opened at least two emails in the last week and clicked once."

Deliverability Insights

Monitor bounce reasons and spam complaints to maintain inbox placement.

Prompt: "Which domains have the highest hard bounce rate this quarter?"

Journey Optimization

Uncover bottlenecks or drop-off points across multi-step journeys.

Prompt: "Show me the drop-off rate after the first email in Journey A."

Campaign Performance

Compare engagement metrics across multiple sends or campaigns.

Prompt: "Which campaign had the highest click-to-open ratio last month?"

Join multiple data views

QAiry’s ability to join multiple data views into one report. This holistic approach lets you quickly assess overall engagement across sends, opens, clicks, and bounces.

Example Prompt: "Generate a 7-day summary of sends, opens, clicks, and bounces by JobID, and store results in 'CampaignSummaryDE'."

QAiry would automatically produce a SQL query similar to:

SELECT
    j.JobID,
    j.EmailName,
    j.EmailSubject,
    COUNT(DISTINCT s.SubscriberKey) AS TotalSent,
    COUNT(DISTINCT o.SubscriberKey) AS TotalOpens,
    COUNT(DISTINCT c.SubscriberKey) AS TotalClicks,
    COUNT(DISTINCT b.SubscriberKey) AS TotalBounces
FROM _Job j
LEFT JOIN _Sent s
    ON j.JobID = s.JobID
LEFT JOIN _Open o
    ON s.JobID = o.JobID
    AND s.SubscriberKey = o.SubscriberKey
LEFT JOIN _Click c
    ON s.JobID = c.JobID
    AND s.SubscriberKey = c.SubscriberKey
LEFT JOIN _Bounce b
    ON s.JobID = b.JobID
    AND s.SubscriberKey = b.SubscriberKey
WHERE j.EventDate >= DATEADD(day, -7, GETDATE())
GROUP BY j.JobID, j.EmailName, j.EmailSubject

Additional Use Cases

QAiry extends beyond standard email metrics. Leverage these other System Data Views to get deeper insights:

_Unsubscribe

Use Case: Identify campaigns with the highest unsubscribe rates.

Prompt: "Which campaigns had the highest unsubscribe rates last month?"

_Complaint

Use Case: Track spam complaints to maintain a strong sender reputation.

Prompt: "Show me campaigns with a complaint rate above 0.1% in Q1."

_FTAF

Use Case: Gauge how often subscribers forward emails to friends.

Prompt: "Which email was forwarded most often in August?"

_ListSubscribers

Use Case: Track growth across different lists or segments.

Prompt: "Which list gained the most subscribers over the last 7 days?"

_AutomationInstance

Use Case: Pinpoint automations that fail frequently or run too long.

Prompt: "Which automations failed more than once in the past 30 days?"

_SMSMessageTracking

Use Case: Analyze SMS send volume and performance by short code.

Prompt: "Which short code had the highest send volume this week?"

Frequently Asked Questions

1. Is QAiry secure?

Yes. QAiry operates within Salesforce Marketing Cloud’s secure architecture. Data transfers use encrypted connections, ensuring compliance with industry standards.

2. Do I need SFMC Admin rights?

You need access to System Data Views, typically granted by an Admin. QAiry doesn’t require advanced privileges beyond the ability to query relevant data.

3. Can QAiry handle large data sets?

Absolutely. QAiry relies on SFMC’s underlying data infrastructure, making it capable of handling significant query volumes.

4. What’s the learning curve?

Minimal. If you can formulate questions in plain language (85 languages in total), you can use QAiry. No coding background required.

Data Views With Generative AI