CampaignAnalyzerPro

Have you ever ran a Marketing team? If so, you know how tedious and painstaking it is to look through multiple platforms for campaign insights for your team. CampaignAnalyzerPro is there to fix that!

Comment

Campaign Analyser Pro: The Mission Control for Modern Marketing

Inspiration

Campaigns are the engine of business growth, but for those of us in the driver’s seat, the view is often obstructed.

This project was born from real-world business frustration. Running a small business meant diving headfirst into digital marketing—Facebook, Instagram, YouTube, and Mailchimp. I used Jira to manage my team’s tasks and Confluence to document our strategies. But "The Reality Gap" hit hard. Every morning, I was trapped in a "tab-crawl," opening 6+ browser windows just to answer a single question: "Is our marketing working, and can my team keep up?"

We realized that marketing data is fundamentally siloed. Meta Ads knows about clicks; Jira knows about tickets; Confluence knows about strategy. But none of them talk to each other. We built Campaign Analyser Pro to be the missing link—a native Atlassian "Mission Control" where ROI meets Team Wellbeing, powered by the intelligence of Atlassian Rovo.

What it does

Campaign Analyser Pro transforms Jira from a task manager into a unified marketing intelligence hub. It provides:

  • The Unified Marketing HQ: A single dashboard that streams real-time data from Meta Ads, YouTube Analytics, and Mailchimp directly into your Jira project view.
  • Atlassian Rovo Intelligence: We have integrated Atlassian Rovo as the primary "brain" of the app. Users can engage in a Rovo-style chat to ask complex, cross-platform questions like: "Rovo, compare our YouTube ROAS against the actual hours logged by the design team in Jira this week."
  • BudgetJira Module: A dedicated financial management system. It doesn't just track spend; it categorizes costs into CapEx and OpEx, provides monthly burn-down charts, and alerts managers before budget overruns occur.
  • Team Empathy & Vitality Metrics: We believe sustainable performance comes from healthy teams. The app calculates Stress Levels and Cohesion Scores by analyzing task velocity, deadline proximity, and overtime patterns.
  • One-Click Executive Reporting: With the "AI Update Page" button, Rovo synthesizes all campaign data and team metrics into a polished, stakeholder-ready report written directly to a linked Confluence page.

How we built it

Technology Stack

  • Platform: Atlassian Forge (Custom UI) for enterprise-grade security and seamless Jira/Confluence integration.
  • AI Ecosystem: Atlassian Rovo (Core Intelligence Layer) supported by Google Gemini 1.5 Flash (Specialized analytical processing and LaTeX/Mermaid generation).
  • Backend: Node.js 22 with Forge Resolvers to handle heavy API orchestration.
  • Frontend: React 16, utilizing Atlaskit for a native look and feel, and Mermaid.js for dynamic AI-generated flowcharts.
  • Storage: Forge Key-Value Storage and encrypted Secret Storage for API credentials.

Development Approach

Building a "Native" experience was our priority. We utilized Forge Providers to manage complex OAuth 2.0 flows for Meta and Google. To make Atlassian Rovo effective, we focused on Connectors and Rovo Actions, ensuring the AI could index the specific campaign entities stored within our Forge database. This allows Rovo to "understand" the relationship between an ad's CTR on Facebook and a developer's ticket in Jira.

Challenges we ran into

  • The Data Normalization Puzzle: Every marketing platform has its own dialect. Normalizing a "Mailchimp Open" and a "YouTube View" into a single Campaign Vitality Score required complex mathematical modeling.
  • Fine-tuning Rovo’s Context: Training Rovo to interpret "Team Stress" was a challenge. We had to iterate on our prompt engineering to ensure the AI looked at both the quantity of Jira tasks and the proximity of the campaign launch date to get an accurate empathy reading.
  • Forge API Limits: Managing concurrent data fetches from multiple external APIs while staying within Forge’s execution limits required us to implement a sophisticated caching and resolver strategy.

Accomplishments that we're proud of

  • Native Rovo Integration: We successfully made Rovo the centerpiece of the app. It doesn't just give answers; it provides contextual insights that help marketing leads make faster decisions.
  • Privacy-First AI: Because we built this on Forge, we achieved Zero-Egress security. Sensitive marketing credentials and spend data stay locked within the Atlassian environment.
  • The Empathy Algorithm: Successfully creating a visual representation of "The Human Cost" of a campaign. Seeing a manager realize their team is "Red-lined" before they burn out is the most rewarding part of this tool.

What we learned

This project taught us that intelligence is nothing without integration. We learned how to:

  • Balance the creative freedom of Custom UI with the structured security of the Forge platform.
  • Leverage Atlassian Rovo to act as a bridge between fragmented external data and internal strategy.
  • Design for the "Business User"—making complex LaTeX formulas () and Mermaid charts accessible and easy to read.

What's next for Campaign Analyser Pro

  • Predictive Portfolio Management: We are working on a Rovo-powered "Predictor" that forecasts which upcoming campaigns will likely exceed budget based on historical team velocity.
  • The Growth Suite: Expanding integrations to include LinkedIn Ads, TikTok Shop, and HubSpot to provide a 360-degree marketing view.
  • Automated Actioning: Moving from analysis to action—allowing Rovo to automatically move Jira tickets to "High Priority" if an ad campaign's performance dips below a specific threshold.

Built With: Atlassian Forge, Atlassian Rovo, Gemini AI, Jira Cloud, Confluence Cloud, React, TypeScript, Meta Marketing API, YouTube Analytics API, Mailchimp API.

Built With

Share this project:

Updates