• DE&I Commitment
  • Careers
  • Locations
  • Book a Meeting
    Book a Meeting
  • Company
    Learn a little more about us, our values, and our team
    Our Values
    We don't just talk the talk; we live by our core values
    About Us
    Empowering brands to realize their potential with data, insights, and technology
    Leadership
    Meet our leadership team
    Secure Data Architecture
    Our promise of data security and privacy. We keep your data safe from publishers, competitors and bad actors
    Corporate Social Responsibility
    We are committed to making a positive impact on our communities and our planet
  • Platform
    Plan, manage, optimize, and measure your campaigns with our omnichannel platform
    Our Platform
    A platform that connects all walled garden media
    Connected Media
    Create and manage campaigns across search, social, retail media and apps, in one platform
    Connected Data
    Make data-driven decisions as you plan and strategize
    See the industries we serve
    Learn how our customizable solutions can help with your unique needs
    Explore our partner integrations
    See the media, retailer, and data partners we work with
  • Clients
  • News and Events
    Check out recent announcements and see what we’re up to
    News
    Check out our recent media coverage
    Events
    Join us for our next conference or webinar
    Roundtable discussion: Beyond Onsite
    Tackle the next phase of retail media over breakfast with Nectar360 and peers
    Retail Media for Grocery Webinar
    Join us to dig into trends and challenges shaping the industry in 2023
  • Resources
    From new releases, to industry trends and best practices, Skai has you covered
    Blog
    Read the latest insights and thought leadership from our industry experts
    Capabilities
    Take your campaigns to the next level by enhancing your platform capabilities
    Research
    Explore our reports and whitepapers so you can keep up on the latest industry trends
    Subscribe
    Sign up to get the latest updates straight to your inbox
    Quarterly Trends Report
    Learn digital advertising campaign performance trends from Q4 2022
Back to Blog

The Skai 5: Five Questions on COVID-19 Insights with Skai’s Senior Director of Marketing Research Chris Costello

Joshua Dreller, Sr. Director, Content Marketing @ Skai™

May  20, 2020

Whether its analyzing digital advertising trends for Skai’s Quarterly Trends Reports, finding data points for the Client Services team to share with interested customers, or fueling our content with compelling stats, Chris Costello—or “Coz” as he’s known to his friends and colleagues—has been deriving insights from Skai’s massive advertising dataset since arriving here in 2014. 

COVID-19 InsightsWhat’s been keeping him glued to his computer monitor for the last few months has been a constant analysis of Search, Social, and Ecommerce advertising data to help make sense of how advertisers and consumers are reacting to the global COVID-19 pandemic. Drawn from an annualized data set spanning nearly $7B in marketer spend, over 750 billion ad impressions, and 15 billion clicks, Coz has been fielding questions from marketers, financial analysts, industry publications, and Skai customers that want into what he’s seeing and—more importantly—what he might be able to predict in the near future. 

With an analyst career spanning nearly 30 years, Coz has seen it all—almost. In these unprecedented times during the pandemic, he’s been tasked with answering almost unanswerable questions. How bad is it getting? Are consumers clicking ads again? Are there signs of recovery? When will things get back to normal? 

To check out Coz’s work in this area, visit Skai’s COVID-19 Marketing Resource Center for his most up-to-date research and analysis. He’s also appeared in numerous publications and webinars recently as the entire industry copes with this global issue.

Given the unique nature of his work over the last few months, we decided to sit down with him and get more insight into what it’s like to be an analyst during this time.

Five questions with Chris “Coz” Costello on COVID-19 advertising research

What is different for you, or for the field of research and analytics in general, in terms of how you’re analyzing data during this crisis?

Coz. Personally, I can say unambiguously that I’m asking a lot more of Skai data. That means I have to adopt a higher standard when it comes to things like data quality and data hygiene. Imperfections or sources of error that you might otherwise overlook can be a bigger headache when there’s more at stake, so I find myself looking at assumptions I have about the data, making sure they’re correct, and thinking about how, with some tweaking, they might inform a better analysis. 

The same goes for KPIs. Maybe you’ve known they could be better and have been putting off fixing them, and this would be a really good time to actually do that. I’ve said over and over that digital advertising needs to get back to fundamental principles—right time, right place, right message—and this is pretty much the same thing for analytics. Is your data as accurate as it could be? Are you looking at the right metrics? “Close enough” isn’t going to be good enough during a pandemic.

How much of your analysis is automated, via dashboards and other data processing or visualization tools?

Coz. My workflow is typically messing around with large datasets in more basic tools like Excel, and then once I’ve got a better idea of what I’m trying to do, I’ll try to build as much of that as I can in Tableau, so it’s more easily repeatable, scalable and shareable. 

But that only goes so far, mostly because I’ve been using Excel for, like, twenty-five years now and Tableau for less than five. So I may do the basic views in Tableau and then dump summary-level data as a crosstab to get things to really sit the way I want in Excel. It may take a bit more time, but one thing I like about this hybrid approach is that you’re not relying on the tools to do all of the work. When you’re a bit more hands-on with the data itself, pulling it apart and putting it back together, it ends up being the equivalent of how writing something out longhand is better for memory than, say, typing. If your goal is understanding the data, I feel like there’s no real substitute for getting your hands dirty, and I’m not just saying that out of self-preservation in an era of machine learning. At least I think I’m not. I like having the robots on hand to do stuff! Just not all of it.

In the Skai Q1 2020 Quarterly Trends Report, there is a “Signs of Recovery” section. How did you approach this analysis?

Coz. There’s a real danger right now of being overly reactive to transient spikes in the data, in either direction. So while week-over-week trends are important, they are very short-term, and you don’t want to mistake a spike for a trend. Including a medium-term and long-term view of those trends gives a bit more context. 

Last week may have been up versus the previous week, but how did it compare to the average over the last four weeks? What about month-over-month, or a four-week period over the previous four weeks? We look at all of those, first for aggregate spending in a category, and then for other metrics that might tell us something useful. Impressions in the paid search and ecommerce channels reflect product searches and product views in a category, while CPM in paid social will increase as advertisers see more value in getting in front of particular audiences. 

At the end of the day—or more specifically, at the end of every week—it’s a combination of short-, medium- and long-term views across spending and other KPIs that start to draw a picture of where the recovery might be more sustained, or where it may have turned things around more recently.

In the Quarterly Trends Report, you projected what the Q1 2020 channel growth might have been without the impact of the pandemic. What approach did you take to figure that out? 

Coz. The first approach was to simply compare spending from March of last year to both January and February of last year, and then apply those two ratios to January and February data from this year, since spending was humming along at a normal clip at that point. Then we got a bit more granular and looked at the year-over-year growth by week for the first two months of the year, which gives you more data points to consider. So, it’s a more stable trend and a more targeted calculation. 

Applying that year-over-year growth trend to the specific weeks in March that were affected gave a bit of a tighter, more conservative estimate. So that allowed us to give a range for Q1 growth because it seems kinda silly to die on the hill of a specific number when you’re making an educated guess.

From an analytical perspective, how relevant is historical data in a COVID-19 world?

Coz. Well, it still provides the context of what “normal,” or what used to be “normal” looks like. So you can look at how you are trending as an individual advertiser, or as a channel in aggregate, and at least get some sense of where you are, rather than getting too distracted by the very short term trend. 

Even in the middle of March, when digital ad spend was starting to decline, we were able to look at the same period last year and see that at least some of that decline seemed like a normal slowdown that we would see in late Q1 and early Q2. So if the impact of the virus was even just a little less than it looked like initially, that’s something that may help understand how the normal levers and normal seasonality may affect the recovery.

Check out Skai’s COVID-19 research hub

Visit Kenshoo.com/Covid-19-Resources/ to check out more of Coz’s analysis and the most up-to-date information.

Book a Meeting of Skai

Related Posts

  • Skai’s Chief product officer guy cohen on market intelligenceSkai’s Chief product officer guy cohen on market intelligence
    The Skai 5: Five Questions About Market Intelligence With Skai’s Guy Cohen, Chief Product Officer 
    Read More
  • Digital Retail Marketing As We Near the End of COVID-19
    Read More
  • The Skai Five: 5 Questions on the Brand-Agency Relationship with Straight North’s CEO, David Duerr
    Read More
  • 4 Post-COVID Beauty Trends on the Rise
    Read More
  • Woman sitting at a desk holding a sign with like written out and a thumbs-up icon.
    The Skai 5: Five of the Best Social Media Campaigns of 2021
    Read More
  • Amazon advertising homepage in Brazil.
    Skai Retail Media Now Supports Amazon Advertising in Brazil
    Read More
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn
  • Share via Email
  • Copy Link
    Copied!

Subscribe to Updates

Media that matters.
Marketing that works.
© 2023 Kenshoo, Ltd. All Rights Reserved.
Privacy Policy. Cookie Policy. Recruitment Privacy Policy.
  • Connected Data
    • Market Intelligence
    • Our Approach
    • By Need
    • By Solution
  • Connected Strategy
    • Dynamic Marketing Mix
    • Budget Forecasting
    • Strategic Consulting
  • Connected Media
    • Overview
    • Retail Media
    • Paid Search
    • Paid Social
    • App Marketing
    • Auditing
    • Expert Services
  • Measurement
    • Incrementality
    • Experiments
    • Cross-Channel Attribution
  • Resources
    • Blog
    • Glossary
    • Case Studies
    • Training & Enablement
    • Developer Hub
Privacy Preference

We use cookies on our website. Some of them are essential, while others help us to improve this website and your experience.

Privacy Preference

Save All

Save

Accept Only Essential Cookies

Manage Cookie Preferences

Cookie Details Privacy Policy Imprint

Privacy Preference

Here you will find an overview of all cookies used. You can give your consent to whole categories or display further information and select certain cookies.

Save All Save Accept Only Essential Cookies

Back

Privacy Preference

Essential cookies enable basic functions and are necessary for the proper function of the website.

Show Cookie Information Hide Cookie Information

Name
Provider Owner of this website, Imprint
Purpose Saves the visitors preferences selected in the Cookie Box of Borlabs Cookie.
Host(s) .skai.io, skai.io
Cookie Name borlabs-cookie
Cookie Expiry 1 Year
Name
Provider Owner of this website
Purpose This cookie stores selections made by the user in the Accessibe tool in order to maintain those settings on future visits. These cookies help us make our website compliant with our obligations under US law.
Privacy Policy https://accessibe.com/privacy-policy
Cookie Name acsbState, acsbReset
Cookie Expiry n/a
Name
Provider Owner of this website
Host(s) skai.io
Cookie Name wordpress_sec_,wordpress_test_cookie,wp-postpass_*, wordpresspass_*, wordpressuser_*
Cookie Expiry Session / 1 Year

We use these cookies to enhance functionality and allow for personalisation, such as live chats, videos and the use of social media.

Show Cookie Information Hide Cookie Information

Accept
Name
Provider Owner of this website
Host(s) .chilipiper.com, skai.chilipiper.com
Cookie Name fs_uid, CHILI_PIPER_CLUSTER, guest-session, _sp_ses*, _sp_id*
Cookie Expiry Session / 2 Years
Accept
Name
Provider Owner of this website
Host(s) .comeet.co, www.comeet.co
Cookie Name visid_incap_, nlbi_#######, incap_ses_, referrer22_00a, incap_ses_1364_2167377
Cookie Expiry Session / 1 Year
Accept
Name
Provider Owner of this website
Host(s) skai.io
Cookie Name moduleFormPardotDownload
Cookie Expiry 30 days

Statistics cookies collect information anonymously. This information helps us to understand how our visitors use our website.

Show Cookie Information Hide Cookie Information

Accept
Name
Provider Google Ireland Limited, Gordon House, Barrow Street, Dublin 4, Ireland
Purpose Cookie by Google used for website analytics. Generates statistical data on how the visitor uses the website.
Privacy Policy https://policies.google.com/privacy?hl=en
Cookie Name _ga,_ga_*,_gat,_gat_*,_gid
Cookie Expiry 2 Months
Accept
Name
Provider Hotjar Ltd., Dragonara Business Centre, 5th Floor, Dragonara Road, Paceville St Julian's STJ 3141 Malta
Purpose Hotjar is an user behavior analytic tool by Hotjar Ltd.. We use Hotjar to understand how users interact with our website.
Privacy Policy https://www.hotjar.com/legal/policies/privacy/
Host(s) *.hotjar.com
Cookie Name _hjClosedSurveyInvites, _hjDonePolls, _hjMinimizedPolls, _hjDoneTestersWidgets, _hjIncludedInSample, _hjShownFeedbackMessage, _hjid, _hjRecordingLastActivity, hjTLDTest, _hjUserAttributesHash, _hjCachedUserAttributes, _hjLocalStorageTest, _hjptid, _hjSessionUser_2229986, _hjIncludedInPageviewSample, _hjIncludedInSessionSample, _hjAbsoluteSessionInProgress, _hjFirstSeen
Cookie Expiry Session / 1 Year

Marketing cookies are used by third-party advertisers or publishers to display personalized ads. They do this by tracking visitors across websites.

Show Cookie Information Hide Cookie Information

Accept
Name
Provider Linkedin
Cookie Name lidc, li_gc, lang, AnalyticsSyncHistory, UserMatchHistory, li_sugr, bcookie, TDCPM, TDID, bscookie, ln_or
Cookie Expiry Session / 1 Year
Accept
Name
Provider Skai
Accept
Name
Provider 6sense
Cookie Name _gd_session, _an_uid, _gd_visitor, _gd_svisitor, 6suuid
Cookie Expiry Session / 400 Days
Accept
Name
Provider Pardot
Purpose Cookie name associated with services from marketing automation and lead generation platform Pardot. The visitor value is the visitor_id in your Pardot account. This cookie is set for visitors by the Pardot tracking code.
Host(s) .pardot.com, pi.pardot.com, skai.io
Cookie Name pardot, visitor_id*, lpv*
Cookie Expiry Session / 10 Years
Accept
Name
Provider Google Ireland Limited, Gordon House, Barrow Street, Dublin 4, Ireland
Purpose Cookie by Google used for conversion tracking of Google Ads.
Privacy Policy https://policies.google.com/privacy?hl=en
Cookie Name IDE, 1P_JAR, NID, SOCS, CONSENT, AEC, _gcl_au, OTZ, test_cookie
Cookie Expiry Session / 400 Days
Accept
Name
Provider Meta Platforms Ireland Limited, 4 Grand Canal Square, Dublin 2, Ireland
Purpose Cookie by Facebook used for website analytics, ad targeting, and ad measurement.
Privacy Policy https://www.facebook.com/policies/cookies
Cookie Name _fbp,act,c_user,datr,fr,tr,m_pixel_ration,pl,presence,sb,spin,wd,xs
Cookie Expiry Session / 1 Year

Content from video platforms and social media platforms is blocked by default. If External Media cookies are accepted, access to those contents no longer requires manual consent.

Show Cookie Information Hide Cookie Information

Accept
Name
Provider Wistia
Host(s) .wistia.com
Cookie Name cb_anonymous_id, _sp_ses.2b40, _li_dcdm_c, __hssrc, _gcl_au, _clsk, hubspotutk, _sp_id.2b40, __hssc, __hstc, _uetsid, _uetvid, _gid, _ga, _ga_GQR109DZ3Y, _lc2, fpi, _ex-pricing-cta, _fbp, cb_group_id, cb_user_id, _clck
Cookie Expiry Session / 400 Days
Accept
Name
Provider Meta Platforms Ireland Limited, 4 Grand Canal Square, Dublin 2, Ireland
Purpose Used to unblock Instagram content.
Privacy Policy https://www.instagram.com/legal/privacy/
Host(s) .instagram.com
Cookie Name pigeon_state
Cookie Expiry Session
Accept
Name
Provider Openstreetmap Foundation, St John’s Innovation Centre, Cowley Road, Cambridge CB4 0WS, United Kingdom
Purpose Used to unblock OpenStreetMap content.
Privacy Policy https://wiki.osmfoundation.org/wiki/Privacy_Policy
Host(s) .openstreetmap.org
Cookie Name _osm_location, _osm_session, _osm_totp_token, _osm_welcome, _pk_id., _pk_ref., _pk_ses., qos_token
Cookie Expiry 1-10 Years
Accept
Name
Provider Twitter International Company, One Cumberland Place, Fenian Street, Dublin 2, D02 AX07, Ireland
Purpose Used to unblock Twitter content.
Privacy Policy https://twitter.com/privacy
Host(s) .twimg.com, .twitter.com
Cookie Name __widgetsettings, local_storage_support_test
Cookie Expiry Unlimited
Accept
Name
Provider Vimeo Inc., 555 West 18th Street, New York, New York 10011, USA
Purpose Used to unblock Vimeo content.
Privacy Policy https://vimeo.com/privacy
Host(s) player.vimeo.com
Cookie Name vuid
Cookie Expiry 2 Years
Accept
Name
Provider Google Ireland Limited, Gordon House, Barrow Street, Dublin 4, Ireland
Purpose Used to unblock YouTube content.
Privacy Policy https://policies.google.com/privacy?hl=en&gl=en
Host(s) google.com
Cookie Name CONSENT
Cookie Expiry 6 Month

Borlabs Cookie powered by Borlabs Cookie

Privacy Policy Imprint