No real issue that prompted this, but it was born out of wanting to glean more understanding across the success of a specific service.
One of the things I have been trying to make and effort to do on a weekly or bi-weekly basis is to try and find a wow client, or a particularly high spend/opportunity client, and play with their data. You might be wondering what playing with their data means. I wonder the same thing the minute I start to do this every other week. Usually my goal is to first try and find something interesting, a specific service that is seeing great results, a campaign that is under or over-performing, or anything that I identify as something I want to learn more about. In this example I was kind of already prompted because I knew as a team, we were seeing good social results, and our POC was curious to know more about why we might belive we were seeing higher-than-expected returns.
I took the social channel, and really I tried to mix and match different metrics to compare to, location, number of touchpoints, and campaigns. Really anything that could be correlated to the social campaign, that I could then uncover and realize/find trends for. This led me to explore the business unit tied to each deal. One of the nice things from Helitech’s data exports is they include the region in which a deal was closed/created etc. I map this column to the business_unit field in our MCFX database. One of the things I found really interesting is the social campaigns were heavily weighted to the Nashville and Ozarks region for the client. Over 70% of the revenue is driven by social media, which is attributed to these business units.
I was able to connect with the AM, and chat about this finding, and it prompted the AM to get curious about their PPC campaigns, and we found that about 25% of their campaigns were bringing in $0, these campaigns are managed by another marketing vendor of theirs. This is now giving the AM and me a leg to stand on for recommending we shift some spend from PPC to social, and probably doing some more location-specific targeting for these social campaigns!
Here is a SS of the data I am referring to!
Social Data: https://webpagefx.mangoapps.com/msc/MjAzNzM3NV8xNDIzMTEyMA
All Channel Data: https://webpagefx.mangoapps.com/msc/MjAzNzM4Ml8xNDIzMTEyNw
Uncovering a trend that otherwise would have probably been never found, or would have been found much later than it was. Social has been a really standout service for the client, and one of the things I saw the team was trying to uncover was why, or what seems to be working really well with the social campaigns. And I took 30 minutes with the data in our deals dashboard we get as Architects, and played around with different metrics, when looking at the business unit, or the location of the deal field I noticed specific geographic markets that were seeing really great success with the social campaigns specifically.