8 Marketing Data Issues That Might Be Holding You Back (and How to Fix Them)

Growth Intelligence
0 min read
March 26, 2021
Kenneth Shen
Chief Executive Officer

Let’s dive into some data pitfalls that we see even large successful marketing operations struggling with.

We can split your data sources into two main types:

First-Party Data - The data tracking that you are responsible for setting up and managing within your business. It is what’s captured within your website analytics tool(s), CRM database and email marketing platform. It can also include other data you should ideally be keeping track of, such as media and social mentions, client surveys and reviews.

Third-Party Data - The data that is provided to you by advertising platforms via their own analytics tools. This typically includes channels like Facebook, Google Ads, LinkedIn, or industry news platforms.

First-Party Marketing Data Integrity

in house marketing data salesforce

For your first-party marketing data integrity, the common pitfalls and remedial actions include:

Issue #1: Lack of a Structured Data Model

What marketing and sales tech stack do you need to track and report data at each step of your customers journey? How do those systems need to interact and share data? What processes and people do you need to fulfill that across which teams?

Without a clear and cohesive model, siloed software systems or behavior across teams will cause data integrity issues. A well-designed data system should function like a supercar, with each component fully optimized and working in harmonious synchronization.

Action: Build and Document a Model for How Data Flows Between Platforms 

Build a holistic data model with your KPI reporting requirements in mind. Create a data flow diagram of each granular step from start to finish. Include technology requirements, processes, roles, and clear definitions of what data qualifies as leads or conversions, etc. 

Use this as a live document and update it with any changes to your marketing operation.

Issue #2: Poor Data Governance Processes

Symptoms of weak data governance often include a lack of format standardization. Inconsistent data entry without mandatory fields. Inconsistent tracking code usage. Naming errors, or an absence of naming rules. Too many custom data fields being created. Data being spread across multiple similar fields.

These issues regularly affect form fills, email marketing, and organic content on social media or search engines. For example:

  • Website form-fills aren’t using mandatory fields, and fields are inconsistently linked to corresponding CRM fields.
  • UTM code naming errors result in confusion around the specific source of sales leads and conversions. 
  • Marketing emails are created by duplicating previous campaigns that are missing fields for UTM codes, or have copied over old codes.
  • Social media posts missing UTM codes on their links.

Action: Set Uniform Naming Conventions and a Process for Data Governance  

For each system, determine which data input fields are truly necessary and/or mandatory. Bear in mind that collecting more data requires more data governance, can result in information overload, and increases the potential for dirty data.

Create clear data entry processes and defined naming rules. That includes naming rules for tracking codes and data entry fields, as well as controls for creating new data entry fields. 

Make the effort to ensure that data governance processes are clearly documented and communicated for specific staff roles, process documents can be easily accessed for reference, and that the rules are continually adhered to.

Data validation tools are available within databases such as Salesforce. Consistently set which data fields are mandatory, what standardized format data should be in, and set range constraints if applicable.

Use UTM tag managers such as Google Tag Manager (free) and Tag Inspector. They’ll help you to keep naming conventions consistent and avoid tag duplication. To learn more about using UTM codes, check out our article on how to set up your digital marketing analytics.

Issue #3: Customer Error, or Unwillingness to Share Data

Your customers can easily make mistakes when entering their data in form-fills. However, if you ask customers for too much personal information early in the customer journey, they’ll be more likely to provide fake information to protect their anonymity. 

They’re also more likely to abandon a conversion process if data entry is too laborious. And they could also lack trust around how their data is protected and used.

Action: Build Trust and Standardize Fields 

Collect data from your customer in stages with progressive profiling as the relationship builds, using demonstrated value as justification. 

Pre-population of forms and being able to save details in a user account reduces the laboriousness of your customer data capture processes.

Verifying data increases the chance of converting subscribers to paying customers. Use automated data verification tools to ensure that data is correct at point of entry. For example, use captcha validation on form fills to check its a real person, and send real-time verification emails at the point of capturing an email address.

Trust can be built with transparency about why you are capturing data and how you will manage the data. Don’t forget to provide this information, which can be done via linking to a dedicated webpage with your data privacy disclaimer. Reinforce justification for sharing data by immediately providing something of value, and make it easy for customers to unsubscribe if they want to. 

Respecting your customers data and communication preferences is an important part of building your brand.

Issue #4: Human Error by Staff

Avoiding all human error is just not possible. At the end of the day, we are all human! Errors can happen at any point. 

It could be a spelling mistake in a manual data entry. The accidental creation of a duplicate entry. Forgetting to set up data validation rules for a form-fill entry field, not asking for complete information, or not linking the form-fill entry fields to your CRM system. Getting the naming rule slightly wrong on a UTM code.

Staff turnover can also exacerbate the volume of errors, as it naturally takes people a little time to get up to speed and learn your processes. Perhaps database processes haven’t been well communicated to new staff, or made easily accessible in documented format.

Action: Standardize Data and Reduce Friction

The important thing is to catch as many errors as possible while asking people to stick to your data entry rules every single time. 

Use automation options where possible to make it easier by reducing manual entry requirements. You could invest in a data integrity tool like gatedcontent.com for easy form-fill templates with standardized entry and tagging.

Prioritize regularly checking accuracy for the data that’s most crucial to your business. Allocate a champion. Make it part of the process that secondary approval is required before launching content like a campaign email or Google advert, for example.

Issue #5: Data is Difficult to Extract for Analysis

The analysis part of the equation is what having good data integrity is all about. Being able to analyze data and use it to make informed decisions is the whole point. Clearly named fields, standardized values and complete data sets really pay dividends at this stage! 

However, your data is of little use if you can’t filter, extract, analyze or understand what it’s saying. And not being able to pull quick and easy to understand reports is a common problem our clients tend to have. 

People are trying to export large quantities data from separate systems into spreadsheets, data crunch, and manually build reports. It’s tedious and time-consuming to do. And with humans building it, it’s vulnerable to error.

Action: Invest in Tools that Integrate with Data Platforms  

Before defining any governance processes, remember to consider how data will be technically be reported. Make data capture and storage fit to your reporting or extraction technology right from the get go. 

Invest in the right tech stack and data visualization tools to help you. And importantly, also invest in your staff’s skill-set so they can use the technology, then subsequently understand what data is saying.

Third-Party Advertising Data Integrity

google ads platform big data

For third-party advertising data integrity, the common pitfalls and remedial actions include:

Issue #6: Not Setting Up Conversion Tracking Properly

When a new campaign is launched in paid traffic channels like Facebook Ads or Google Ads, account managers go through a data entry process that will determine what categories of information and reporting will be available for analysis after launch.

It’s your businesses responsibility to set up the pixel tracking for your adverts, and also how you define conversions so that the advertising platform can report conversions back to you. And as with in-house data, human error can come into play here also.

Without the correct set up, the in-platform reporting provided by the major digital ad providers isn’t going to provide meaningful information for you. That means you can’t use their specialized engagement reporting to asses your advert performance as a campaign progresses, or see the final Return on Ad Spend (ROAS) metrics.

Action: Check Conversion Tags 

To learn more about setting up pixels and conversion tracking, check out our article on how to set up your digital marketing analytics.

Also, use tools such as Facebook’s Pixel Helper, Google Tag Assistant, and the preview function in Google Tag Manager to debug conversion tags. 

Invest in leaning about the advertising platforms you are using, and make sure staff are following their best-practice guidelines. You can also require a second member of staff to provide proofing and authorization before an ad campaign is launched, ensuring processes are adhered to and human error is reduced.

Issue #7: Enhanced User Privacy Controls 

Apple’s iOS 14 privacy update and the California Consumer Privacy Act (CCPA) are part of a growing trend that’s contributing to a reduction in data quality. It means that consumers can no longer be tracked from clicking an advert onto your website in order to see if they ‘convert’.

The size of the user base that these changes are impacting is significant. Thus, the accuracy of attribution and ROAS data decreases everyday.

Reporting is increasingly modeled to compensate for missing data where users couldn’t be tracked. And where all ad reporting data on key platforms like Facebook was once live, it now takes a day or two to for modeled results to be reported back for users who have opted not to be tracked. (Facebook indicates in its ad reporting where modeled data is in use.)

Action: Stay On Top of New Regulations 

Sense check modeled data by monitor your ad campaigns with your own UTM tracking. You just need to insert clearly labelled UTM codes to the ad links. You’ll then be able to validate the click-through attribution data you’re given, and compensate for in-platform data that’s modeled (estimated) and delayed due to data privacy restrictions. 

Note that to monitor live campaigns, you’ll need to have a good set up for quickly pulling and visualizing your UTM code data.

Issue #8: Double Attribution 

Advertising attribution data is a common source of inaccurate marketing reporting. It’s also a critical one when it comes to optimizing the revenue results you get from your ad budget. 

Advertising platforms are competing to demonstrate that they deliver the highest returns. They want to influence you to spend more of your ad budget with them, so they maximize the ROAS data they present. If you advertise on more than one channel at the same time, double attribution counting can easily skew your ROAS data.

How does that happen? Let’s say a customer has visited your website and purchased an item after seeing an advert on both Facebook and Google within the space of a day. They haven’t clicked on either advert, and they were actually already a customer who intended to make a purchase, which they followed through on. However, both of the advertising platforms claim 100% responsibility for the sale using View-Through attribution.

Or, perhaps a potential customer saw a Facebook advert and decided that they want to make a purchase but didn’t complete the purchase that day. However, after seeing a Google remarketing ad a couple of days later, they are reminded, and click on the advert to complete the purchase. Allocating 100% Click-Through attribution to Google for the sales conversion would be an inaccurate reflection of the user’s conversion journey. 

You can see how this would make it difficult for you to accurately assess the effectiveness and ROAS of individual adverting channels or adverts, and also obscure the proportional contribution each advert has in creating a customer journey that leads to a sale. 

Action: Cross Reference your In-House Data and On Platform Data Frequently  

For channels such as Facebook, we advise sense checking in-platform ROAS data against revenue. Combine the ROAS results from each advertisement platform, then check if the combined revenues exceed your actual revenue in that period. You just need to multiple what you spend on an advert with the ROAS multiplier that Facebook has provided. If the combined revenue that ad platforms have reported exceeds your actual revenue, you’ll know there’s some double-attribution going on! 

On Google Analytics, traffic source data from is shown on a last-click basis by default, which means the click that brought users to your site. Again, you can accurately track advert Click-Through attribution if you use UTM codes. Your website analytics platform won’t double-count users or their activity, so it’s a useful means of sense-checking the Click-Through attribution data provided to you by advertising platforms. 

Finally, consider using a Media Efficiency Ratio (MER) as your north star advertising KPI metric.

Media Efficiency Ratio = Total Revenue / Total Paid Media Spend

It’s a more effective way to help you understand how your cross-channel advertising is working together to creating a customer journey with multiple touch-points. You’ll get a better sense of how well your wider ad strategy is working than when replying on just the stand-alone ROAS metrics from individual platforms, or Customer Acquisition Cost (CAC).

The Bottom Line

The value of good data compounds over time. Better data means better insights and decision making. Combined with know-how to interpret good data, the result is more effective marketing and customer communication. It will drive your brand impact and business growth for less financial investment.

Creating a holistic data capture process that maintains data integrity at each stage takes some knowledge, investment and continued prioritization. A well-designed data system should function like a supercar, with each component fully optimized and working in harmonious synchronization.

We’ve covered a lot here, and I know it can be overwhelming. If you need any support, please just get in touch with us at Half Past Nine to discuss what support you need. Data is our truly our passion, and we’d be delighted to help!

What To Read Next:

Nate Lorenzen
Jenner Kearns
Chief Delivery Officer
Jenner Kearns
Chief Delivery Officer
Jenner Kearns
Chief Delivery Officer
Kenneth Shen
Chief Executive Officer
Kenneth Shen
Chief Executive Officer
Kenneth Shen
Chief Executive Officer
Kenneth Shen
Chief Executive Officer
Jenner Kearns
Chief Delivery Officer
Kenneth Shen
Chief Executive Officer
Jenner Kearns
Chief Delivery Officer
Jenner Kearns
Chief Delivery Officer
Jenner Kearns
Chief Delivery Officer
Jenner Kearns
Chief Delivery Officer
Kenneth Shen
Chief Executive Officer
Jenner Kearns
Chief Delivery Officer
Kenneth Shen
Chief Executive Officer
Kenneth Shen
Chief Executive Officer
Isla Bruce
Head of Content
Isla Bruce
Head of Content
Isla Bruce
Head of Content
Jenner Kearns
Chief Delivery Officer
Isla Bruce
Head of Content
Kenneth Shen
Chief Executive Officer
Isla Bruce
Head of Content
Isla Bruce
Head of Content
Isla Bruce
Head of Content
Kenneth Shen
Chief Executive Officer
Isla Bruce
Head of Content

Read next

Google Ads has significantly evolved with the integration of AI, making advertising more efficient and effective. One of the most notable features is AI-driven search campaigns, which leverage machine learning to optimize bidding strategies and broad match types. This helps advertisers reach their audience more precisely and efficiently.

Another standout feature is the AI-powered chat function that simplifies ad creation. This tool allows users to generate ad texts and assets easily, making it especially useful for those setting up campaigns. By streamlining the creative process, the AI chat feature saves time and reduces the complexity of creating effective ads.

Understanding these AI features can provide substantial benefits for advertisers looking to stay competitive. From smart bidding to real-time adjustments, AI transforms how campaigns are managed and optimized. Readers interested in these capabilities can explore more about the capabilities of artificial intelligence in Google Ads to enhance their ad performance.

Automated Bidding Strategies

Automated bidding strategies in Google Ads use AI to help optimize bids during ad auctions. These strategies aim to maximize conversions and improve cost-efficiency.

Defining Bidding Strategies

Bidding strategies are methods used to manage how much you're willing to pay for each ad click or conversion. In Google Ads, smart bidding is a popular method that uses machine learning to optimize your bids.

There are several types of automated bidding:

  • Target CPA (Cost Per Acquisition): Focuses on getting as many conversions as possible at the target cost per acquisition.
  • Target ROAS (Return on Ad Spend): Aims to achieve the highest possible return on ad spend.
  • Maximize Clicks: Seeks to get as many clicks as possible within your budget.
  • Maximize Conversions: Prioritizes increasing conversion numbers.
  • Enhanced CPC (Cost Per Click): Adjusts your manual bids to maximize conversions.

Each strategy suits different campaign goals, from driving traffic to improving conversion rates.

How AI Enhances Bidding

AI in Google Ads makes bidding smarter by analyzing vast amounts of data quickly and accurately. It adjusts bids based on various factors like time of day, user device, and location. This leads to better performance and cost-efficiency.

Predictive analytics helps AI forecast the likelihood of a click converting into a sale. By examining historical data, AI can make informed decisions on how much to bid.

Real-time adjustments are another benefit. AI in Google Ads can modify bids on the fly, ensuring you're not overpaying for clicks that are unlikely to convert.

Ad Personalization with AI

Ad personalization using AI in Google Ads allows marketers to create dynamic ads, analyze performance, and customize ad content to target specific audiences effectively.

Dynamic Ads Creation

One of the key features of artificial intelligence in Google Ads is dynamic ads creation. AI-driven search campaigns use machine learning to create ad variations that match user searches more accurately. By leveraging AI, Google Ads can automatically mix and match assets like images, text, and videos to produce ads that are highly relevant to users' search queries.

Dynamic ad creation can significantly improve engagement rates by displaying ads that closely match user intent. This results in higher click-through rates (CTR) and increases the overall effectiveness of ad campaigns. It saves time for marketers, as they don’t have to manually create multiple ad versions.

Performance Analysis

AI in Google Ads also enhances performance analysis. By utilizing the vast amount of data collected from ad campaigns, AI provides insights that help optimize ad performance. For example, Google Ads AI can identify which keywords and ad formats are generating the most conversions, and adjust bidding strategies accordingly.

The ability to analyze performance in real-time allows marketers to make data-driven decisions. AI can continuously monitor and tweak campaigns to maximize Return on Investment (ROI). Additionally, AI's capability to predict trends ensures that campaigns remain effective even as market conditions change.

Ad Customization Techniques

Ad customization techniques are another critical element of AI in Google Ads. With features like Performance Max campaigns, marketers can upload various high-quality assets. The AI then mixes and matches these assets to create customized ads that resonate with different segments of the audience.

Using custom formats and specific targeting options, AI can tailor ads to fit the preferences and behaviors of individual users. This personalized approach not only enhances user experience but also increases the likelihood of conversions. Techniques include using dynamic keyword insertion and adapting ad copy to different user demographics, which ensures ads are contextually relevant.

Predictive Analytics in Audience Targeting

Predictive analytics uses AI in Google Ads to enhance audience targeting by making data-driven forecasts about user behavior. This helps marketers reach the right audience more effectively and tailor campaigns to meet their needs.

Understanding Audience Segments

AI in Google Ads classifies users into distinct audience segments based on their online behavior. These segments include demographics, interests, and past interactions. This process helps marketers identify and target specific groups that are more likely to engage with their ads.

For example, artificial intelligence can segment users who frequently visit sports websites into a sports enthusiast category. Advertisers can then create tailored ads for this group, increasing the likelihood of successful engagement. By understanding these segments, campaigns become more focused and effective.

Predicting Consumer Behavior

Predictive analytics in Google Ads leverages historical data to anticipate future actions. For instance, it can predict which users are likely to make a purchase soon or which ones might drop off. This allows marketers to craft strategies that target these behaviors.

For example, AI can analyze past purchasing trends and identify users with a high probability of buying specific products. Marketers can then serve ads that highlight promotions or related products to these users, increasing conversion rates. Predicting consumer behavior makes ads more relevant and timely, ultimately optimizing ad spend.

Smart Campaigns and Performance Insights

Smart campaigns in Google Ads use AI to automatically manage various aspects of your ad campaigns, ensuring optimal performance. These features offer detailed insights, enabling businesses to make data-driven decisions.

Leveraging Smart Campaigns

Smart campaigns use artificial intelligence to handle tasks like bidding and targeting. By using Google AI to update search terms over time, smart campaigns ensure ads reach the right audience. This automation reduces the time and effort needed to manage campaigns, making it easier for businesses to succeed online.

Key benefits include:

  • Automated Bidding Adjusts bids based on the likelihood of conversion.
  • Targeted Advertising — Shows ads to users searching for relevant products or services.
  • Performance Enhancements Continuously optimizes ad performance through machine learning.

Interpreting AI-Driven Analytics

AI-driven analytics in Google Ads offer valuable insights that can improve campaign efficiency. These analytics highlight customer behaviors and preferences, providing data that can refine targeting strategies. Performance insights like detailed demographics and budget pacing help businesses understand where to allocate their resources effectively.

Important features include:

  • Customer Value Mode — Focuses on high-value customers.
  • Retention Goals Helps maintain existing customer relationships.
  • Budget Pacing Ensures ad spend is distributed evenly across the campaign timeline.

By using these AI features, businesses can make more informed decisions, leading to better outcomes for their advertising efforts.

A/B testing is a powerful method to improve ad performance on Facebook and Instagram. By comparing two versions of an ad strategy, marketers can determine which one resonates better with their audience. Using A/B tests, businesses can optimize variables such as ad images, text, audience, or placement to increase engagement and conversions. For instance, testing vertical videos versus horizontal videos can lead to significant cost savings per web conversion.

Setting up an A/B test in Meta's Ads Manager is straightforward and can yield insightful results. This tool allows businesses to use an existing campaign as a template, making the process efficient and user-friendly. Ad campaigns should run for at least seven days to ensure reliable results, with a maximum duration of 30 days best practices for A/B tests.

When running an A/B test, it’s crucial to test only one variable at a time. This approach helps in accurately determining what drives better performance. For example, small businesses have found success by testing creative variables first, like different video formats or static ads A/B Testing Ads.

Executing A/B Tests on Social Platforms

Performing A/B tests on social platforms like Facebook and Instagram allows marketers to pinpoint which ads resonate most with their audience. By comparing different versions of ads, advertisers can optimize their campaigns for better performance.

Setting Up A/B Tests for Facebook Ads

To execute an A/B test on Facebook Ads, start in the Ads Manager. Use the A/B Testing tool to test different variables like ad images, text, audience, or placement. This tool ensures that each ad version is shown to different audience segments, preventing overlap.

Steps to set up A/B tests:

  1. In Ads Manager, choose your campaign and click on "A/B test."
  2. Select the variable you want to test. It could be an image, headline, or target audience.
  3. Define the duration of the test. Facebook recommends a minimum of 7 days for accurate results.
  4. Analyze the performance. Metrics such as click-through rate (CTR) and conversion rates help determine the winning version.

For detailed guidelines, refer to Meta's resources on A/B Testing Ads on Facebook.

Optimizing Instagram Ads through A/B Testing

Instagram also supports A/B testing within the Meta Ads Manager. Identifying the most engaging ad elements is crucial for maximizing reach and conversions.

Steps to optimize Instagram ads:

  1. Access Meta Ads Manager and create an A/B test for your Instagram campaign.
  2. Choose a single element to test, like the ad's visual content or call-to-action.
  3. Set up the test to run for a period that provides sufficient data, typically at least 7 days.
  4. Review specific metrics such as engagement rates, likes, and shares to evaluate performance.

For more insights, visit the Meta Business Help Center page on A/B testing.

Keep tests simple by changing only one variable at a time, ensuring cleaner and more precise results. This method not only refines your ad strategies but also provides valuable insights into audience preferences.

Analyzing A/B Testing Results

Understanding how to interpret and act on A/B testing results is crucial for improving ad performance on Facebook and Instagram. This section will cover how to read data and metrics from your tests and what steps to take based on the insights gathered.

Interpreting Data and Metrics

To start, locate your A/B test results within the Ads Manager, where you will see various metrics. Look for metrics like CTR, conversion rate, and cost per result. The CTR shows how often people who see your ad click on it. A higher CTR suggests that the ad is engaging.

Conversion rate indicates how many of those clicks lead to a desired action, such as a purchase. Cost per result helps understand the financial efficiency of the ad. High costs might indicate an issue with the ad's effectiveness or targeting. Be sure to compare these metrics between different versions of your ads to see which performs better.

Actionable Insights and Next Steps

Once you have interpreted the data, identify which ad version performed the best. For instance, if Ad A had a higher CTR but a lower conversion rate compared to Ad B, you may need to tweak the call-to-action or landing page of Ad A.

Use these insights to inform future campaigns. If a specific image or headline resonates more with your audience, incorporate similar elements in your next ads. Document these findings to create a knowledge base for future reference.

Making educated adjustments based on these results can lead to more effective ad campaigns and better return on investment (ROI). Check out the details on viewing A/B test results to refine your strategy.