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.