By Kian Xie, Digital Marketing & Analytics Consultant
Process and documentation are copyright Heal Your Marketing, 2018, all rights reserved. Specific keywords and user information are withheld for the purpose of client confidentiality.
We started with aggregate data sourced from FB Audience Insights, which included audience proportions related to gender, education level, audience behavior (clicks, likes, comments, shares on posts), income level, and purchases of subscription services (numbers on the last two metrics were sourced from third-party Cambridge Analytica data, and thus are no longer available through Facebook). Each row represents one audience segment, categorized by interest keyword. Each column represents a particular metric on which we would like our targeting audience to score high.
These numbers don't tell us too much on their own. We can try to order the list by one metric, such as desired income proportion, but that does not create any clarity regarding other important metrics, such as audience behavior. Instead, we want to view this data in a way that makes it easy to optimize for ALL desired qualifications.
Just knowing that one audience segment scored higher than another segment on a certain metric isn't enough to give us significant insight. We need to measure the differences in scores in a way that reflects the context of the whole combined audience. Thus, for each metric, we calculate the mean and "pseudo-deviation" - not quite a standard deviation, but a similar measure of variation that adequately serves the purposes of this test. The columns shaded in gray show part of the process of calculating these measures.
Finally, we create an overall "Favorability Score" based on the value of each metric and its expected effect on lead quality, and order the rows by this overall score. Some patterns become apparent, such as more blue/green on top, and more yellow/orange/red in the bottom rows. The levels of visual consistency in the upper rows guide us intuitively as far as where to draw the "cutoff" line between favorable and unfavorable segments. We decided, based on visual observation of rows, to set the cutoff at a favorability score of 73.
In conclusion, we have a ridiculously high level of confidence that this process is repeatable and scalable in its effectiveness to reduce advertising costs, provided the advertiser has access to data regarding audience income level proportions and buying habits.