Published on

Data Analysis Project: Boosting TikTok Followers by 6K in 2months (Part 1) | Excel Project | Macros

Introduction

In this project, I will take you through my journey of analyzing data that helped me grow my TikTok following from zero to over 6,000 followers in just two months. Within the first week of posting about this analysis, I had two companies reach out to me! I will be detailing the entire data analysis process that I undertook, showcasing how I created an interactive dashboard, business questions I sought to answer, and the data handling involved.

Project Overview

The aim of this data analysis project is to understand the type of content that garners the most engagement on TikTok. To achieve this, I built an interactive dashboard that enables users to visualize different metrics by leveraging features like slicers and pivot tables. Using this dashboard, one can easily navigate to different tabs for data tabs, charts, and even access TikTok directly.

Setting Up Business Questions

The first step in a data analysis project is outlining the relevant business questions. For my project, I focused on the following questions:

  • What type of content receives the most engagement?
  • How do my followers grow over time?
  • What content type (photo or video) performs better?
  • Which topics lead to higher interactions?

To tackle these questions, I collected various metrics needed for analysis, including:

  • Posting date
  • Day of the week
  • Likes, comments, and views received in the first 24 hours
  • Favorite counts
  • Content type (photo or video)
  • Topic of the post
  • Topic details for tracking purposes
  • Music used in the video

Data Collection Methodology

Throughout these two months, I meticulously recorded my TikTok data daily. After each post, I set an alarm for 24 hours to review the performance metrics, such as likes, comments, and views.

To analyze follower count, I utilized TikTok's "Download Your Data" feature, specifically requesting the profile data. This process includes a series of steps to request and download the follower details.

The primary dataset was constructed with important columns that would support the analysis, along with secondary sheets for visual representation.

Data Cleaning and Organization

As I gathered my data, I also ensured that it was clean and structured. After importing the follower data into Excel, I extracted only the necessary columns to help maintain focus on the analysis. For any repetitive tasks, I utilized Macros and Visual Basic for Applications (VBA) to streamline the workflow.

Using Macros for Automation

Macros are invaluable for automating repetitive tasks in Excel. By recording a Macro, I was able to perform actions like transposing rows to columns automatically, thereby saving me a considerable amount of time.

To create the Macro:

  1. Start recording a Macro and give it an appropriate name and shortcut.
  2. Perform actions in Excel, which the Macro will remember as code.
  3. Stop recording once the task is complete.
  4. Edit the Macro code in the Visual Basic editor to enhance functionality.

Creating Pivot Tables for Analysis

With the dataset cleaned and structured, I created pivot tables to answer the business questions formulated earlier. These included:

  • Average views per content topic
  • Average likes based on content type
  • Average comments based on audio types
  • Average views and likes per day of the week

This structured approach allows for actionable insights, making my content strategy data-driven.

Conclusion and Next Steps

This article serves as a comprehensive insight into how I used data analysis to boost my TikTok following. In the subsequent part of this series, I'll take a deeper look into how to visualize the findings statistically.

Keywords

Data analysis, TikTok growth, follower count, Excel project, Macros, VBA, pivot tables, engagement, content strategy, interactive dashboard.

FAQ

Q: What is the main goal of the project?

A: The main goal is to analyze which types of content on TikTok lead to higher engagement, ultimately using this data to increase followers and interaction rates.

Q: How did you collect data for analysis?

A: Data was collected manually for likes, comments, views in the first 24 hours after posting and by downloading profile data from TikTok.

Q: What tools did you use for this analysis?

A: The primary tool used was Microsoft Excel, along with Macros and VBA for automating repetitive tasks and creating Pivot Tables for data analysis.

Q: Why are macros important in this analysis?

A: Macros automate repetitive tasks in Excel, saving time and effort, especially when dealing with large datasets.

Q: How can I follow along with your next steps?

A: Stay tuned for the next part of the series, where I'll explore visualizing the data findings further and how to implement the insights gained from this analysis.

Read More