Blog

How To Define [Geographic] Facebook Budget Allocation

Have you ever found yourself pitching a media plan to clients and are not sure how to explain your Facebook Budget Allocation?

In fact, what is the minimum budget for Facebook ads?

Yes, Facebook has a minimum budget in terms of daily spend that you can set on the Ad Set level to as little as $5 per day.

But how can you determine if your allocated Facebook campaign budget will make the desired impact nationwide?

 

Digital Brand Index

 

This article explores measuring existing ‘digital brand index’ to determine the Facebook Ads minimum budget required to make an effective impact.

Note: For this use case we are working with brands that have national coverage.

 

 

How Does One Determine the Best Geographic Facebook Budget Allocation?

 

So what is a good way to identify your Facebook budget optimization for maximum impact?

If we segment every campaign by state or city our execution would become counterproductive.

However, targeting specific cities only would be too restrictive and leave opportunity on the table.

If you are working with a national brand, certain geographies must have a stronger brand saturation than others, so how can they be identified?

In addition, some areas have much stronger performing sales volume than others. How can you identify and leverage this?

Good questions, right?

Next, how does all this tie in to effectively distributing Facebook Budget Allocation across geographies?

Read on to find Facebook geographic ad budgets explained using BDI, CDI and BOI.

 

What is BDI, CDI and BOI?

 

The exact definitions are:

 

BDI – Brand Development Index
CDI – Category Development Index
BOI – Brand Opportunity Index

 

To run a BDI/CDI analysis in traditional media planning  a brand manager would look at:

 

Nationwide Target Population
City/State Wide Target Population
Nationwide Total Brand Sales
City/State Total Brand Sales
Nationwide Total Category Sales
City/State Total Category Sales

 

Given this information the brand manager would be able to define brand and category index to determine brand and category areas of opportunities using the following formulas:

 

BDI = (Total Brand Sales Locations / Total Brand Sales Nationwide) / ( Total Target Population Local / Total Target Population Nationwide )*100
CDI = (Total Category Sales Locations / Total Category Sales Nationwide) / ( Total Target Population Local / Total Target Population Nationwide )*100

 

To define the opportunity index we take:

 

BDI / CDI * 100 = Opportunity Index

 

We can read the results like this:

 

If the value is lower than 100, we are under-indexing and there is room to grow.
But, if the value is at ~100, we have a relatively even index.
However, if the value is over 100 we are over indexing.

 

What the heck does this have to do with Facebook?

Read on – this is where it gets pretty neat.

 

Identifying Facebook Audience Opportunities

 

I am going to take the same approach as above using data I have sliced up building audiences on Facebook to help me determine best geographic Facebook Budget Allocations.

First, we need to collect our data so that we can run an analysis.

Let’s pick the brand Fitbit and a target audience of active millennial moms across these seven cities:

 

New York
Los Angeles
Chicago
Houston
Dallas
Seattle
Boulder

 

Referencing the traditional model above, let’s swap some values:

 

Nationwide Target Population = Active Millennial Moms Nationwide
City/State Wide Target Population = Active Millennial Moms by City
Nationwide Total Brand Sales = Fitbit Facebook Fans Nationwide
City/State Total Brand Sales = Fitbit Facebook Fans by City
Nationwide Total Category Sales = Healthy & Fit Purchase Behavior Nationwide
City/State Total Category Sales = Healthy & Fit Purchase Behavior By City

 

Our target audience sizes break down like this:

 

Active Millennial Moms

 

Facebook Budget Allocation - Audience

 

Fitbit Fans

 

Facebook Budget Allocation - Audience

 

Healthy and Fit Purchase Behavior

 

Facebook Budget Allocation - Audience

 

Running BDI/CDI Analysis

 

Now that we have all of this data compiled, we take the data above and run the analysis.

BDI = (A/B)*100
CDI = (C/B)*100
BOI = BDI/CDI

This gives us the results below:

 

Facebook Budget Allocation - BDI CDI BOI

 

Results

 

With this in mind, looking at the BOI column, we can identify that most cities have a fairly even distribution; whereas Boulder and Seattle both are showing high CDI, but a low BDI identifying these as two opportunity cities.

As a result, we can break out the cities with a BOI less than 100 and distribute the Facebook Budget Allocation against these areas of opportunities.

 

Visual Mapping

 

In this case, I only grabbed a sample size of cities, but when doing this analysis across many cities it is great to have a visual representation of this data for easier digestion and comprehension.

For this reason, I have found the below map graph to work best.

 

Facebook Budget Allocation - Mapped

 

Your Thoughts

 

In conclusion, using a conventional approach to measuring the ‘digital brand index’ can provide a data-driven calculation to determining the most effective Facebook Budget Allocation.

Now it is your turn. Did you find this approach useful?

What methods have you used to identify the best distribution for your Facebook ad spend?

 


 

Leave a comment

Your email address will not be published. Required fields are marked *