Dec 18, 2024

How to use Custom Data Import to make the most of your offline out-of-home data

3-MINUTE READ | By Larry Hill

Data IntegrationData Management

[ Updated Dec 19, 2024 ]

Out-of-home (OOH) advertising is a great way to reach your audience offline—think highway billboards or bus wraps. But unlike digital channels, which offer precise tracking and real-time data, it’s much harder to report and measure the impact of offline OOH.

That’s until now. In this article, I’ll discuss how Custom Data Import—a brand new feature in the Marketing Intelligence Platform—can help you integrate offline OOH data for better tracking and measurement. 

Navigate this post:

Overcome the challenges of measuring and reporting out-of-home advertising

One of the primary challenges in OOH marketing has been accurately measuring its impact because it takes time to attribute sales and conversions to specific OOH ads as they often work in conjunction with other marketing channels. But, with marketing data integration,  you can now gain insights into campaign performance. 

We recently launched Custom Data Import, a feature that lets you collect and analyze data from various sources—including OOH, digital, and social media, for a holistic overview of the campaign’s performance.

Once you’ve got all your data in one place, you can measure metrics like impressions, dwell time, click-through rates, and conversions. Additionally, you can use this data to improve your marketing mix modeling, measure incremental sales and brand equity, and quantify the impact of marketing investments.

You can establish a data benchmark for offline data and compare the effectiveness of different marketing channels to increase ROI. 

example of an ooh ad

How to use Supermetrics Custom Data Import to get your OOH data

How to prepare your data

Extract relevant OOH data from your ad platforms or agencies. This might include impressions, clicks, cost per thousand impressions (CPM), and other key metrics. Ensure the data is clean and structured, such as a CSV file or an Excel format.

The image is a table summarizing data for four advertising campaigns: Summer Sizzle, Cityscape Serenity, Nighttime Nostalgia, and Urban Pulse. The table details the location of each campaign, ranging from Times Square billboards to digital screens in malls, along with their respective impressions, dwell time in seconds, click-through rates, and cost per thousand impressions

Then, make sure the metrics used in your OOH data align with other marketing channels.

Configure Custom Data Import

In the Supermetrics Hub, create a new Custom Data Import. Then, upload your OOH data CSV file to the platform.

The image shows the interface of Supermetrics Custom Data Import interface with settings to adjust data sources

Once your data is uploaded, you can review it to make sure everything is correctly interpreted.

The image displays an interfaceof Supermetrics Custom Data Import, where users can review and configure data types for columns in a file.

Blend OOH data with other channels

Then, to get the full picture of your marketing, combine your OOH data with other data sources like Google Ads, Facebook Ads, and Google Analytics by using the data blending transformation features.

You can also merge the OOH data with data from other channels using Supermetrics’ powerful query capabilities.

Analyze and visualize

Once you’re happy with your data, you can build custom reports in your BI tool so it’s easy to keep track of your performance. You can monitor metrics like impressions, clicks, cost per acquisition (CPA), and return on ad spend (ROAS). Use data visualization techniques to identify trends, patterns, and opportunities for improvement.

For more information on configuring Custom Data Import, check out this support article.

Why you should try Custom Data Import

  • Unified view: Consolidate OOH data with other marketing channels for a holistic view of performance.
  • Better measurement: Gain a deeper understanding of the impact of OOH campaigns on overall marketing goals.
  • Automated reporting: You can save hours of manual work and spend time on meaningful work.

Custom Data Import makes it easier to understand and improve your OOH ads by combining offline data with online data. It helps you see everything in one place to make better decisions and get more value from your ads. Want to see how it works? Book a demo.

Integrate your out-of-home data
Talk to our expert and see how you can use Custom Data Import to your ooh data or any data to see how your overall marketing is doing
Book demo

About the author

author profile image

Larry Hill

Larry is a seasoned Solutions Engineer at Supermetrics with over a decade of experience in tech, notably at Salesforce and Tableau Software. He's specialized in data integration and business intelligence. His skills span across platforms like Google BigQuery, Snowflake, and Microsoft Azure, optimizing data pipelines for strategic decision-making.

Stay in the loop with our newsletter

Be the first to hear about product updates and marketing data tips