Adverity: Free Google Ads, Facebook Ads and Snapchat Ads dataset

Access Ads data from Google, Facebook and Snapchat to see how you can streamline your marketing reporting


Marketers and their agencies run marketing campaigns across a vast number of advertising platforms; making sense of all the data they generate is crucial but not simple. From basic reporting and reconciliation, to optimizing campaigns and their return on investment, marketers and agencies need a reliable and automated pipeline for all paid marketing, SEO, web analytics, CRM, commerce data and more.

It can be a daunting prospect, but it doesn’t need to be. For sure, these processes can no longer be run manually, because they are too time consuming and error prone. A modern data pipeline needs to ensure data quality, governance and lineage, which are key attributes for a successful data-driven approach to marketing.

About this dataset:

This free dataset provides a sample of real paid marketing data from Google, Facebook and Snapchat, so you can start seeing how this data can be seamlessly provided by Adverity into your Snowflake. We chose to deliver this data into a single table, but this is one of many aspects that can be customized to fit exactly your data needs and architecture.

The data model / schema applied to this sample dataset is a default provided by Adverity. However, when dealing with your own marketing data, you have full flexibility around the data model / schema to use. On top of that, Adverity provides a visual interface to create several other logic rules to enrich and transform data as necessary, to provide business-ready data into your Snowflake account.

In this sample dataset, you will find approx 50 fields (metrics and dimensions) standardized across the 3 platforms. These fields include:
– campaign_id, campaign_name, campaign_start_date
– ad_id, ad_name, adset_id, adset_name, creative_id, creative_name
– clicks, impressions, costs, conversions
– video_views, video_completions, device_type

This is only the tip of the iceberg. If you like what you see, please contact us to discuss how to connect all your marketing data and bring the joy of automated, curated data seamlessly into your Snowflake.

About the Provider:

Adverity is an intelligent marketing analytics platform enabling data-driven marketers to make better decisions and improve performance, faster and easier. By transforming siloed data into actionable insight, Adverity reduces the complexity involved in demonstrating ROI of marketing spend.

Adverity powers the marketing intelligence of some of the world’s leading brands and agencies, including IKEA, Red Bull, GroupM, Unilever, Omnicom, SAP, JD Sports and Forbes.

Visit the provider’s website for more information


Get access to the Adverity: Free Google Ads, Facebook Ads and Snapchat Ads dataset in Snowflake

Sign up for a free trial

Already a Snowflake customer?
Access this dataset directly from your Snowflake account