Active Campaign and Thrive Cart Analysis

The client is a company that sells online courses . They needed a report that would analyse the performance of one of their training programs and email marketing activity.

Data Source

Thrive Cart, Active Campaign

Analysis Tool

Google Data Studio Google Data Studio

Data Engineering

We wrote a Google App Script that automatically takes data from Active Campaign and Thrive Cart into Google Sheet every day. We then connected our Google Data Studio report to this Google Sheet and built reports from it.

ITIL 4 Foundation

This report analyses all the funnel stages for the leads before they sign up for a paid course. The client ran 5-day email-marketing campaign and wanted to analyse the conversions on every stage.

467 is the number of people to whom the promotion email was sent. Out of them 325 people opened the promotional email and 142 did not.

All the metrics show a comparison to the previous 14 day period.

The graph at the bottom shown the proportion of opened emails on every day of the campaign.

ITIL Campaign – Continued

The report goes on by analysing how many users clicked on an email by day.

Click-through rate is analysed by date and the progression of click-through rate is shown by day of campaign.

Finally, the report analyses how many leads completed purchase. This is broken down to the users who clicked on all emails and those who only clicked on some.

Prince 2 Agile Practitioner

This report analyses an activity on Prince 2 Agile Practitioner programme. It shows the progression of coupons, enrols, failures, profits, retakes and revenue by day.

ITIL 4 Foundation

This report analyses the key metrics of ITIL 4 Foundation course: Enrols, Coupon Costs, Failures, Profits, Retakes and Revenue.

There is also an option to filter the graphs by date range.

Ways we can help

Support

All the support you need – when you need it. From 1-hour quick fix support to longer-term partnership that drives your business forward.

Consultancy

Advanced data thinking, creative  ideas and the best Power Platform practices to unlock the true potential of your business data.

Training

Succeess shouldn’t be a one-off. When we train you teams user adoption surges and your Power Platform results radically improve.