Marketing Data Collector

Get the results of your online marketing efforts in one place

PROBLEM

STATEMENT

BABR, a company offering business insolvency and cashflow solutions, needed an automated system to track the results of their organic marketing efforts on Facebook, LinkedIn, Google Analytics 4, and Capsule CRM. They were previously doing it manually and it was taking 1 full working day for 3 employees to generate the reports across various marketing channels. They asked Data Prism for a cost-effective solution to get this information updated regularly and analyze the results for improving their marketing efforts.

SOLUTION

We used the connectors (in Make) for all of their marketing platforms to gather the required stats and metrics. The collected information was then stored in Google Sheets for analysis. The data in these sheets is updated daily as the Make Scenario extracts the information and updates it into the appropriate sheet. The data that we collect is divided into the following categories (based on the platform):

For Facebook:

For LinkedIn:

Page Stats (Desktop Views, Mobile View, Total Views)
Posts Stats (Post ID, Post URL, Text, Time of Post, Total Impressions, Unique Impressions, Clicks, Percentage Engagement, Like Count, Comment Count, and Share Count)
Time bound Share Stats (Start Time, End Time, Total Impressions, Unique Impressions, Clicks, Percentage Engagement, Like Count, Comment Count, and Share Count)
Time bound Followers (Start Time, End Time, Organic Followers Gained, Sponsored Followers Gained)

For Google Analytics 4:

For Capsule CRM:

Input

Access to Make account

Output

Google sheets containing stats and metrics of marketing efforts and status of every lead with daily updates.