Sync HubSpot & API Data to PostgreSQL & Google Sheets

## Campaign Analytics Report Documentation

Overview

This report provides a high-level summary of campaign performance, designed to help stakeholders quickly assess the outcomes of marketing or sales campaigns. It includes data on campaign activity, targeted audiences, and progression metrics, allowing for a holistic view of campaign effectiveness.

## Key Metrics

	1	**Campaign Identification and Status**

        •	Campaign ID: A unique identifier assigned to each campaign for tracking purposes.
	•	Status: Indicates the current state of the campaign:
	•	Active: Campaign is ongoing.
	•	Paused: Campaign is temporarily on hold.
	•	Archived: Campaign has concluded.

2       **Targeting and Reach**

	•	Total Companies: Number of companies targeted within the campaign scope.


3	**Pipeline Metrics**

	•	Lead Count: Total number of leads generated by the campaign.
	•	Marketing Qualified Leads (MQLs): Leads that meet predefined marketing qualification criteria.
	•	Sales Qualified Leads (SQLs): Leads that are validated as sales-ready by the team.
	•	Opportunities: Potential deals created from campaign engagement.
	•	Customers: Number of deals successfully closed, converting leads into customers.


4	**Lifecycle Stages**

	•	Lifecycle Stage Metrics: Counts of entities (e.g., leads, opportunities, or customers) at specific lifecycle stages. These stages represent the journey from lead generation to conversion.



## How to Use This Report

	•	**Evaluate Campaign Success**: Compare metrics like total companies, leads, and customers to understand campaign impact.
	•	**Understand Pipeline Health**: Analyze how many entities progress through the funnel (e.g., from MQL to SQL to Opportunity).
	•	**Monitor Campaign Status**: Use the status column to focus on active campaigns or review the outcomes of archived ones.
	•	**Assess Engagement**: Check opportunity and customer counts to gauge how effective the campaign is in driving conversions.