Gain full control over your data
Most tools keep your data in silos. We make sure those silos are broken, your data is accurate and beneficial for the entire organization.
PS! We can send raw hit-level Google Analytics data into your data warehouse. Learn more
Here's how it works.
All steps are optional and can be bought separately
1. Audit, fix & improve
After meeting with your team and understanding your business goals we are going to conduct a full audit of your current analytics setup. This is followed by fixing all the issues and implementing required improvements.
This provides a solid foundation and ensures data integrity.
2. Set up a data warehouse
Our default data warehouse vendor is BigQuery but we can work Snowflake, AWS and others as well. If your company already has something in place, we can take a look and suggest improvements if necessary.
This will be your one source of truth.
3. Configure a data pipeline
This involves connecting your Analytics and Ads platforms, CRM, CMS, offline data and other data sources with our system that will transform and securely store all your data in your data warehouse.
We have connectors for all major tools and platforms.
4. Reporting and visualization
Now that you have access to your marketing, user behavior and other data all in one place, it’s time to start reporting on it. Our team can help you with building interactive dashboards, automated reports, alerts and more.
Data only has value if smart people turn it into real actions.
Why choose us
Reflective Data is flexible and always adapts to your needs. Feel free to order an audit, analytics implementation or let us take over your entire digital analytics workflow.
Fully managed services
Your account manager will put together a strong team of Reflective Data’s analysts, developers and data scientists to meet the ever-changing needs of your business.
Whether you choose to get an audit or go with the full managed services package, our goal is to help you discover and test insights that will make your company more profitable.
Custom software development
We have built analytics, user behavior analysis and A/B testing platforms from scratch, we’ve got you covered with any custom analytics software you might need.
Our team, your success.
Best-in-class analytics services to help you make better, data-driven decisions.
Reflective Data has been our main partner in digital analytics for over two years now. They helped kick-start our efforts in tracking, data analysis, data visualization, and reporting. Reflective Data truly acted as an extension of our team and the level of collaboration was much more akin to a partnership than a client/vendor relationship.
Parker, CMO, New York
Our experience with Reflective Data has been amazing. Our internal resources are always limited and we're now relying on Reflective Data on pretty much all of our digital analytics tasks. They audited and redid our entire enhanced ecommerce setup. These guys tend to overdeliver, we are more than happy. Oh, and the new dashboards completely changed how we work.
Stephanie, Director of Ecommerce, London
Analytics data pipeline use cases
With analytics data pipeline, you can easily gain access to raw unsampled hit-level Google Analytics data in BigQuery or any other data warehouse. All hits are ready for querying in near-real-time.
- No sampling
- You own and control the data
- Secure and flexible storage
- PII data allowed
- Data available in near-real-time
A similar setup is available for most digital analytics platforms (Heap, Mixpanel, Adobe Analytics etc.).
Analytics data pipeline makes it easy to load the raw data from Google Ads into BigQuery. This data can then be joined with data from other sources, i.e. Google Analytics, enabling you to get an overview of cost details as well as build custom attribution models.
- Click-level (gclid) data
- Data loaded daily
- Detailed cost data
A similar setup is available for most ads platforms (Facebook Ads, Bing Ads, LinkedIn Ads, Twitter Ads etc.).
Analytics data pipeline can be configured to listen to Mailchimp webhooks – this makes it easy to send all events from Mailchimp to BigQuery or any other data warehouse.
Types of events:
- Profile update
- Email address changes
- Cleaned emails
- Campaign sending status
A similar setup is available for most marketing platforms (Hubspot, Klaviyo, Sendgrid etc.).
Analytics data pipeline can load data from most e-commerce platforms and send it to BigQuery for reporting and mixing with other data sources.
- and many others
Analytics data pipeline lets you collect all of your marketing data in one central data warehouse, BigQuery, for example. All data is stored in a way to make it easy to query in visualize using all of the popular BI and data visualization tools, i.e. Google Data Studio.
- Custom visualizations
- Ad-hoc queries
- Filtering, Sorting, date-ranges
- Near-real-time access
A similar setup is available for most BI and data visualization platforms (Looker, Tableau, Power BI etc.).
While Google Analytics doesn’t allow the collection of any PII (personally identifiable information) data, with the analytics data pipeline, you could collect it with your Google Analytics hits but only send it to BigQuery.
This provides a perfect solution for joining Google Analytics data with other sources (CRM, CMS, marketing data, offline data etc.).
Google Analytics has two types of data collection and reporting limits. With analytics data pipeline, you can avoid both of them.
The limits in the Free version of Google Analytics are:
- 500 hits per session
- 200,000 hits per user per day
- 10 million hits per month per account
- 500k sessions at the property level for the date range you are using
Both of these limitations can become an issue for sites collecting millions of hits a month. With analytics data pipeline, you don’t have to worry about any data collection limits or data sampling in your reports.
Analytics data pipeline sends all your marketing data into one central data warehouse, i.e. BigQuery. Our robust API makes it easy to access all this data in real-time and without limitations.
- Send data to any destination
- Feed machine learning algorithms
- Build automated reports and dashboards
With tools like BigQuery ML, Auto ML and others, machine learning has become available to the masses. The only part that’s missing, though, is access to high-quality raw hit-level data that is required for training your models.
With all your marketing data in your data warehouse, you can create models from product recommendations to smarter remarketing campaigns.
Analytics data pipeline integrates with all major A/B testing tools and can mix your experimentation data with other sources like your CRM, analytics platforms, ads data and more.
Wonder what’s the long term impact of your experiments or how does it affect the LTV? With analytics data pipeline, you can easily answer these and many other questions that would otherwise require a lot of custom work.
Analytics data pipeline has an integration for most marketing tools, analytics platforms, ads platforms, CRMs, CMSs, social media platforms, databases and data warehouses.
This ensures your data doesn’t stay in silos and is accessible and provides value to all teams.
If your tool doesn’t have an integration available, our data engineers and developers can create one for you.
Latest on our blog
Making BigQuery a Single Source of Truth for Marketing Data Analysis
Is your marketing data currently under the control of multiple vendors and platforms? Do you have to mix together siloed data and reporting tools to answer questions about marketing ROI and your customer’s journey? It’s time to take control of your data!
Cloud databases (i.e. BigQuery) and various data management tools have made it possible for marketers to build data pipelines without a big investment in hardware, software, and custom development.
In this article, we will walk through the steps of gathering data from Google Analytics, Google Ads, Google Search Console, Facebook, CRM and several other sources into Google BigQuery data warehouse and making it the single source of truth for all marketing data.
Why Every Business Needs a Marketing Data Warehouse and How to Set One Up?
The number of marketing tools an average business uses has grown rapidly. Besides one or two analytics platforms there’re a few ads platforms, CRM, CMS, several social media platforms, an email system and probably a few more tools and platforms.
All of those tools are supposed to make our work as marketers, business owners or data analysts easier and more effective. In reality, though, you will end up with a bunch of silos – systems that don’t really communicate well with each other and almost never agree on any of the important metrics.
Data silos create confusion and disagreement between teams, leading to a situation where, at the end of the day, no-one knows which tool or numbers to trust.
How to Query and Analyze Google Analytics Data with BigQuery
BigQuery is an extremely powerful tool for analyzing massive sets of data. It’s serverless, highly scalable and integrates seamlessly with most popular BI and data visualization tools like Data Studio, Tableau and Looker.
Working with Google Analytics data in BigQuery has mostly been a privilege of those having a 360 version of Google Analytics. Its hefty price tag, though, has made that list quite short.