CG TECH

Success story

Junior Adventures Group

Every campaign stalled while staff rebuilt customer lists by hand from scratch.

Power BI Child services
← All success stories
Client
Junior Adventures Group
Industry
Child services
Technologies
Power BI, Mailchimp integration
Junior Adventures Group

The challenge

Building each marketing list by hand was so slow the data was out of date before a campaign went out.

What we did

We linked their Power BI data to Mailchimp so the lists now update on their own.

Every campaign stalled while staff rebuilt customer lists by hand. We connected the data to Mailchimp so the lists build themselves.

Why it mattered

Generating a customer list for each campaign was so slow that the list was out of date by the time it was finished. That is worse than an inconvenience: it means campaigns go out to the wrong people, and the marketing team stops trusting its own data. What they needed was to act while the data was still fresh.

What we did

  • Integrated Mailchimp with their Power BI data models. Delivered in phases rather than as one large change.
  • Automated the member updates. Mailchimp member details refreshed from customer data automatically.
  • Built reporting they can use. Power BI reports for viewing and exporting campaign data.
  • Trained the team and documented it. So the marketing team owns the process rather than depending on us.
  • Added the advanced layer later. Custom data queries, automated triggers and campaign list clean-up in subsequent phases.

The difference it made

  • Campaign effort down by more than 95%, from days to minutes.
  • Campaigns built on current data rather than a list that aged while it was being made.
  • Marketing staff creating their own reports and running their own campaigns.
  • A solution built to be repackaged across their services worldwide.

The results

What Junior Adventures Group got

Campaign prep cut by 95%

From high-touch manual work to a low-touch process

From days down to minutes

Customer lists stay current while the data is fresh

Staff run their own reports

Training and tools to manage campaigns in-house

Let’s write yours next

Every story on this page started with one conversation about a problem worth fixing. Bring us yours and let’s see what’s possible.

Book a Discovery Session

More stories like this

Early Learning Peak Body

Power Pages

A new funding model required two-way data exchanges between every kindergarten, the governing body and Queensland Treasury, and there was no portal to handle it.

We built a portal in Power Pages as the one-stop shop for submissions, documents and live funding data.

Outcomes

  • One portal for 38 kindergartens
  • Funding visible in real time
  • Secure, accurate exchanges
Read the full story

Outside School Hours Care Provider: Voice AI Agent

Copilot Studio

Directors spent much of each day answering policy calls from centre managers, covering everything from incident reporting to child safety rules. Answers varied between people, and many frontline staff speak English as a second language.

We built a voice-enabled AI agent, grounded only in the client’s policies, that answers first so Directors do not have to.

Outcomes

  • Directors freed from routine calls
  • Consistent answers every time
  • Inclusive for bilingual staff
Read the full story

Retirement Living Operator

Microsoft Fabric

Their reporting was manual and split across separate apps, each with its own licence.

We built one Microsoft Fabric platform, modelled the data and set up Power BI, with training to extend it.

Outcomes

  • One platform, many sources
  • Clean, reliable data
  • Team trained to build on it
Read the full story
Scroll to Top