5 Technical Queries You Can Run in Snowflake Using Relo Metrics Data

Oct 06, 2023 Innovation

5 Technical Snowflake Queries Using Relo Metrics NFL Data

Unlock the full potential of Relo Metrics’ complete Census dataset of 2022 NFL Brand Exposures in Snowflake. Below you’ll find five technical queries that you can run in Snowflake using Relo Metrics data. Whether you're a beginner or an experienced user, these queries, accompanied by video tutorials, will guide you through the process step-by-step. So, buckle up and get ready to take your Snowflake skills to the next level!


Already on Snowflake? Check out Relo Metrics in the Snowflake Marketplace 



Here are 5 technical queries you can run in Snowflake using Relo Metrics' 2022-2023 NFL Sponsorship Exposure Data: 

1. Which brands are sponsoring the NFL?

This lets you take a look at all of the brands that are sponsoring in the NFL and see data points like the total number of exposures, how much time they are appearing for, the media value for each, and more.

Example Query Code:

<SELECT SPONSOR_NAME,

SUM(SUM_EXPOSURES),

SUM(SUM_DURATION),

SUM(SUM_FMV),

SUM(SUM_SMV)

FROM SPORTS.VW_SPONSOR_EXPOSURES_BY_DAY

WHERE LEAGUE_YEAR = '2022' AND LEAGUE_NAME = 'NFL'

GROUP BY SPONSOR_NAME

ORDER BY SUM(SUM_SMV) DESC; >

 

2. Which brands appear on the NFL Scoreboard?

You can also see how well brands performed across specific placement types. Here we are looking at one of the most visible assets in the NFL, the Scoreboard.

 

Example Query Code:

<SELECT RIGHTSHOLDER_NAME,PLACEMENT_TYPE_NAME,SPONSOR_NAME,

SUM(SUM_EXPOSURES),

SUM(SUM_DURATION)

SUM(SUM_FMV)

SUM(SUM_SMV)

FROM SPORTS.VW_SPONSOR_EXPOSURES_BY_DAY

WHERE LEAGUE_YEAR = '2022' AND LEAGUE_NAME = 'NFL'

AND PLACEMENT_TYPE_NAME = 'Scoreboard'

GROUP BY RIGHTSHOLDER_NAME, PLACEMENT_TYPE_NAME, SPONSOR_NAME

ORDER BY SUM(SUM_SMV) DESC; >

 

3. Which teams are driving the most value across social channels?

We provide data for broadcast and social media, but if you are more concerned about social and want to see which teams are driving the most exposure and value across social channels you can use this query.

 


Example Query Code:


< SELECT RIGHTSHOLDER_NAME,PLACEMENT_TYPE_NAME,

SUM(SUM_EXPOSURES),

SUM(SUM_DURATION),

SUM(SUM_FMV),

SUM(SUM_SMV)

FROM SPORTS.VW_SPONSOR_EXPOSURES_BY_DAY

WHERE LEAGUE_YEAR = '2022' AND LEAGUE_NAME = 'NFL'

AND PLACEMENT_TYPE_NAME IN ('Social Branded Content')

GROUP BY RIGHTSHOLDER_NAME, PLACEMENT_TYPE_NAME

ORDER BY SUM(SUM_EXPOSURES) DESC;>

 

4. How can a brand like GEICO measure where they’re getting the most value in their NFL sponsorship?

If you are a brand and you can see how your different partnerships across the NFL are performing as well. This will allow you to do some benchmarking and make decisions on which rights holder/asset combos are bringing you the most value.


Example Query Code:

<SELECT SPONSOR_NAME, RIGHTSHOLDER_NAME,PLACEMENT_TYPE_NAME,

SUM(SUM_EXPOSURES),

SUM(SUM_DURATION),

SUM(SUM_FMV),

SUM(SUM_SMV)

FROM SPORTS.VW_SPONSOR_EXPOSURES_BY_DAY

WHERE LEAGUE_YEAR = '2022' AND LEAGUE_NAME = 'NFL'

AND SPONSOR_NAME like 'GEICO%'

GROUP BY SPONSOR_NAME, RIGHTSHOLDER_NAME, PLACEMENT_TYPE_NAME

ORDER BY SUM(SUM_SMV) DESC;>

 

5. As you’re doing competitive research, you can find out which of your top competitors are getting the most value from NFL sponsorship.

Finally, it's easy to do some competitive research with this data and see how much value your competitors are getting from each of their different partnerships across the NFL and where that compares to your own.

 

Example Query Code:

<SELECT SPONSOR_NAME, RIGHTSHOLDER_NAME,PLACEMENT_TYPE_NAME,

SUM(SUM_EXPOSURES),

SUM(SUM_DURATION),

SUM(SUM_FMV),

SUM(SUM_SMV)

FROM SPORTS.VW_SPONSOR_EXPOSURES_BY_DAY

WHERE LEAGUE_YEAR = '2022' AND LEAGUE_NAME = 'NFL'

AND SPONSOR_NAME IN ('Allstate', 'Nationwide','Progressive','MetLife','American Family Insurance')

GROUP BY SPONSOR_NAME, RIGHTSHOLDER_NAME, PLACEMENT_TYPE_NAME

ORDER BY SUM(SUM_SMV) DESC; >

 

 

See Your Sponsorship Data in Action

Subscribe to Our Blog