How to Export Google Analytics Data to BigQuery
Google has announced that Universal Analytics will be sunsetting on July 1, 2023. Per their website, “On July 1, 2023, standard Universal Analytics properties will no longer process data.” On top of the challenge of learning an entirely new analytics platform in GA4, digital marketers are also facing the daunting prospect of losing their historical Universal Analytics data. Google states:
- Until July 1, 2023, you can continue to use and collect new data in your Universal Analytics properties.
- After July 1, 2023, you’ll be able to access your previously processed data in your Universal Analytics property for at least six months. We know your data is important to you, and we strongly encourage you to export your historical reports during this time.
While the exact data deletion date is not yet announced, Google is encouraging advertisers to take action and export their historical data in anticipation of this date.
The “exporting” process is unfortunately easier said than done. Google recommends exporting data in Excel/CSV files, but when we tried to do that for our clients, we quickly realized that that process would not be feasible. Specifically, we ran into the following issues:
- To pull unsampled data for multiple years, we had to run hundreds of smaller reports and stitch them together.
- Attempting to stitch together hundreds of reports took significant time (too much time to complete), and it ultimately crashed Excel and exceeded Google Sheets’ data limits.
- Most exported data for long date ranges was sampled, making it highly inaccurate.
Ideally, we’d be able to export and download our historical Universal Analytics data directly to Google’s cloud-based data warehouse, BigQuery. Unfortunately, only paid GA360 accounts have API access to BigQuery (this will become a standard GA feature in GA4), so in standard analytics, data needs to first be extracted into some other type of file format like CSV, TSV or Excel before it can be uploaded to Google BigQuery. That leaves us right back where we started and facing the issues listed above.
Terrified at the prospect of losing all of our hard-earned data, we’ve spent the last six months working to develop a solution that can export accurate and complete data to Google BigQuery in automated fashion.
We’re excited to announce the launch of our new Analytics Data Extractor (ADE), which:
- Accurately backs-up 5 years of data with no-sampling and 100% data accuracy.
- Archives and store data in a cloud-based database (Google BigQuery).
- Links archived historical GA3 data directly to Google’s Looker Studio (formerly Google Data Studio), where both pre-formatted and custom reports (with Excel exports) will be available.
For more information on how to back-up your Google Analytics data and store it in BigQuery, visit our Analytics Data Extractor website here!
How to Avoid Sampling When Exporting Universal Analytics Data
Synopsis: Options are limited if you’re looking to avoid sampling when exporting your historical universal analytics data in preparation of the migration to GA4. Our new tool, the Analytics Data Extractor (ADE), reliably and accurately extracts, stores and visualizes your historical Universal Analytics data and prevents your data from being lost. Learn how you can back-up 5 years (or more) of accurate, completely unsampled data today!
What is Sampling in Google Analytics?
In Google Analytics, sampling is the process of selecting a subset of data from a larger set of data for analysis. This is done to speed up processing time and to reduce the amount of data that needs to be analyzed.
For example, if you have a website with millions of pageviews per month and you want to analyze user behavior on a specific page, Google Analytics may only sample a percentage of the total pageviews for that page. This allows the data to be processed more quickly, but it also means that the analysis is based on a smaller sample size and may not be as accurate as analyzing the entire dataset. In our agency’s experience, even a nominal amount of sampling can lead to significant discrepancies between the reported and actual data sets.
By default, Google Analytics will use sampling when analyzing large datasets, but you can adjust the sampling rate to get more accurate results. This is particularly important if you’re analyzing smaller subsets of data, such as specific user segments or conversion paths, where sampling can have a bigger impact on the accuracy of your analysis. To adjust the sampling rate, you can use the Sampling Level option in the report settings, but keep in mind, this option is only available in the Google Analytics interface. It’s not an option that is available when exporting data to Excel, and that brings us to a much bigger issue facing digital marketers in 2023.
Sampling and the GA4 Migration
Google’s Universal Analytics will stop collecting data on July 1, 2023, and data will be permanently removed following the close of 2023 (the exact deletion date is TBD). Google is currently urging customers to export historical reports to prevent permanently losing their data.
Unless you’re a GA360 customer, Google suggests manually downloading your GA data via Excel/CSV. This is problematic because:
- To pull unsampled data for multiple years, you would need to run hundreds of smaller reports and stitch them together.
- Attempting to stitch together hundreds of reports would take significant time, and it will ultimately crash Excel and exceed Google Sheets’ data limits.
- Most exported data for long date ranges will be sampled, making it highly inaccurate.
How to Avoid Data Sampling?
To combat this issue, we’ve spent the last six months trying to develop a solution to back-up historical Universal Analytics data while automatically avoiding sampling. We’re excited to announce the launch of our new Analytics Data Extractor (ADE), which:
- Accurately backs-up 5 years of data with no-sampling and 100% data accuracy.
- Archives and store data in a cloud-based database (Google BigQuery).
- Links archived historical GA3 data directly to Google’s Looker Studio (formerly Google Data Studio), where both pre-formatted and custom reports (with Excel exports) will be available.
Historical Universal Analytics data will be safely preserved and fully accessible through GDS for a large number of custom queries and entirely customizable date ranges. The extraction process can be initiated as soon as you’ve made the switch to use GA4 as your primary reporting platform. We estimate that most advertisers will be doing that in the April – June time period, and we are currently offering reservations to secure a date for the backup process. We have 5 critical data sets we’ve identified that will be backed up for 5 years, and additional custom data sets (up to 6 dimensions and 10 metrics per data set) can be extracted for an additional fee.
Learn more about how to avoid data sampling while exporting your historical universal analytics data at extractor.synapsesem.com.
The 2023 Guide: How to Choose the Right Performance Marketing Agency
[av_section min_height=” min_height_pc=’25’ min_height_px=’500px’ padding=’default’ custom_margin=’0px’ custom_margin_sync=’true’ svg_div_top=” svg_div_top_color=’#333333′ svg_div_top_width=’100′ svg_div_top_height=’50’ svg_div_top_max_height=’none’ svg_div_top_opacity=” svg_div_bottom=” svg_div_bottom_color=’#333333′ svg_div_bottom_width=’100′ svg_div_bottom_height=’50’ svg_div_bottom_max_height=’none’ svg_div_bottom_opacity=” color=’main_color’ background=’bg_color’ custom_bg=” background_gradient_direction=’vertical’ background_gradient_color1=’#000000′ background_gradient_color2=’#ffffff’ background_gradient_color3=” src=’https://www.synapsesem.com/wp-content/uploads/2022/12/HEXAGONS-bg-scaled.jpg’ attachment=’12893′ attachment_size=’full’ attach=’scroll’ position=’top left’ repeat=’repeat’ video=” video_ratio=’16:9′ overlay_opacity=’0.5′ overlay_color=” overlay_pattern=” overlay_custom_pattern=” shadow=’no-border-styling’ bottom_border=’no-border-styling’ bottom_border_diagonal_color=’#333333′ bottom_border_diagonal_direction=” bottom_border_style=” custom_arrow_bg=” id=” custom_class=’.landing-page-2023-hero’ template_class=” aria_label=” av_element_hidden_in_editor=’0′ av_uid=’av-lbxz0nyy’ sc_version=’1.0′] [av_two_third first min_height=” vertical_alignment=’av-align-top’ space=” row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ custom_margin=” margin=’0px’ mobile_breaking=” mobile_column_order=” min_col_height=” padding=” svg_div_top=” svg_div_top_color=’#333333′ svg_div_top_width=’100′ svg_div_top_height=’50’ svg_div_top_max_height=’none’ svg_div_top_flip=” svg_div_top_invert=” svg_div_top_front=” svg_div_top_opacity=” svg_div_top_preview=” svg_div_bottom=” svg_div_bottom_color=’#333333′ svg_div_bottom_width=’100′ svg_div_bottom_height=’50’ svg_div_bottom_max_height=’none’ svg_div_bottom_flip=” svg_div_bottom_invert=” svg_div_bottom_front=” svg_div_bottom_opacity=” svg_div_bottom_preview=” border=” border_style=’solid’ border_color=” radius=” column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_direction=’vertical’ background_gradient_color1=’#000000′ background_gradient_color2=’#ffffff’ background_gradient_color3=” src=” background_position=’top left’ background_repeat=’no-repeat’ highlight=” highlight_size=” animation=” link=” linktarget=” link_hover=” title_attr=” alt_attr=” mobile_display=” mobile_col_pos=’0′ id=” custom_class=” template_class=” aria_label=” av_uid=’av-3244lxn’ sc_version=’1.0′] [av_textblock textblock_styling_align=” textblock_styling=” textblock_styling_gap=” textblock_styling_mobile=” size=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=” color=” id=” custom_class=’landing-page-2023-heading’ template_class=” av_uid=’av-lcgjp0ze’ sc_version=’1.0′ admin_preview_bg=”]2023 Agency Guide
[/av_textblock] [av_textblock textblock_styling_align=” textblock_styling=” textblock_styling_gap=” textblock_styling_mobile=” size=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=” color=” id=” custom_class=’landing-page-2023-heading’ template_class=” av_uid=’av-lcgjv5rp’ sc_version=’1.0′ admin_preview_bg=”]HOW TO CHOOSE THE RIGHT PERFORMANCE MARKETING AGENCY
[/av_textblock] [av_hr class=’invisible’ icon_select=’yes’ icon=’ue808′ font=’entypo-fontello’ position=’center’ shadow=’no-shadow’ height=’30’ custom_border=’av-border-thin’ custom_width=’50px’ custom_margin_top=’30px’ custom_margin_bottom=’30px’ custom_border_color=” custom_icon_color=” id=” custom_class=” template_class=” av_uid=’av-lcgk8xx2′ sc_version=’1.0′ admin_preview_bg=”] [av_button label=’DOWNLOAD’ icon_select=’no’ icon=’ue800′ font=’entypo-fontello’ link=’manually,#form’ link_target=” size=’large’ position=’left’ label_display=” title_attr=” color_options=’color_options_advanced’ color=’theme-color’ custom_bg=’#444444′ custom_font=’#ffffff’ btn_color_bg=’custom’ btn_custom_grad_direction=’vertical’ btn_custom_grad_1=’#000000′ btn_custom_grad_2=’#ffffff’ btn_custom_grad_3=” btn_custom_grad_opacity=’0.7′ btn_custom_bg=’#ff4d0c’ btn_color_bg_hover=’custom’ btn_custom_bg_hover=’#ff7f51′ btn_color_font=’custom’ btn_custom_font=’#ffffff’ btn_color_font_hover=’custom’ btn_custom_font_hover=’#ffffff’ border=’solid’ border_width=’1′ border_width_sync=’true’ border_color=” border_radius=’0px’ border_radius_sync=’true’ box_shadow=” box_shadow_style=’0px,0px,0px,0px’ box_shadow_color=” hover_opacity=” sonar_effect_effect=” sonar_effect_color=” sonar_effect_duration=’1′ sonar_effect_scale=” sonar_effect_opac=’0.5′ id=” custom_class=’landing-page-2023-download-button’ template_class=” av_uid=’av-1z2kgzv’ sc_version=’1.0′ admin_preview_bg=”] [/av_two_third][av_one_third min_height=” vertical_alignment=’av-align-top’ space=” row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ custom_margin=” margin=’0px’ mobile_breaking=” mobile_column_order=” min_col_height=” padding=” svg_div_top=” svg_div_top_color=’#333333′ svg_div_top_width=’100′ svg_div_top_height=’50’ svg_div_top_max_height=’none’ svg_div_top_flip=” svg_div_top_invert=” svg_div_top_front=” svg_div_top_opacity=” svg_div_top_preview=” svg_div_bottom=” svg_div_bottom_color=’#333333′ svg_div_bottom_width=’100′ svg_div_bottom_height=’50’ svg_div_bottom_max_height=’none’ svg_div_bottom_flip=” svg_div_bottom_invert=” svg_div_bottom_front=” svg_div_bottom_opacity=” svg_div_bottom_preview=” border=” border_style=’solid’ border_color=” radius=” column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_direction=’vertical’ background_gradient_color1=’#000000′ background_gradient_color2=’#ffffff’ background_gradient_color3=” src=” background_position=’top left’ background_repeat=’no-repeat’ highlight=” highlight_size=” animation=” link=” linktarget=” link_hover=” title_attr=” alt_attr=” mobile_display=” mobile_col_pos=’0′ id=” custom_class=” template_class=” aria_label=” av_uid=’av-pefxyj’ sc_version=’1.0′] [av_image src=’https://www.synapsesem.com/wp-content/uploads/2022/12/Cover_1A.png’ attachment=’12927′ attachment_size=’full’ copyright=” caption=” image_size=” styling=” align=’center’ font_size=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’ hover=” appearance=” link=” target=” title_attr=” alt_attr=” img_scrset=” lazy_loading=’disabled’ id=” custom_class=” template_class=” av_element_hidden_in_editor=’0′ av_uid=’av-lbwjqwwl’ sc_version=’1.0′ admin_preview_bg=”][/av_image] [/av_one_third] [/av_section] [av_textblock textblock_styling_align=” textblock_styling=” textblock_styling_gap=” textblock_styling_mobile=” size=’16’ av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=” color=” id=” custom_class=” template_class=” av_uid=’av-lbwh4yqn’ sc_version=’1.0′ admin_preview_bg=”] Get the ultimate list of questions to ask potential performance marketing partners during the evaluation/RFP process. This guide covers important topics such as:- Whether you should work with a specialized agency or an integrated agency
- How to get the agency’s best resources on your account
- How to negotiate management fees
- The importance of industry experience
- The importance of the firm’s technical capabilities, particularly for B2B tech and other lead gen companies
- How to leverage references to better evaluate (and potentially eliminate) potential partners
- Whether a larger agency or smaller agency is a better fit
- How to evaluate the agency’s client services capabilities and fit
- How many hours the agency will be allocating to your account each month, and the breakdown of that time
Download our 2023 Guide: How to Choose the Right Performance Marketing Agency and get the most important questions and our POV on each!
[/av_textblock] [av_textblock textblock_styling_align=” textblock_styling=” textblock_styling_gap=” textblock_styling_mobile=” size=’16’ av-medium-font-size=” av-small-font-size=” av-mini-font-size=” font_color=” color=” id=” custom_class=’landing-page-2023-container’ template_class=” av_uid=’av-lbwkcgyt’ sc_version=’1.0′ admin_preview_bg=”][ninja_form id=2] |
Synapse Launches New Social Impact Program
Boston, MA – February 24, 2022 – Synapse SEM, a leading performance marketing firm, announced today the launch of their new social impact program, the Synapse Giveback Program. This program is designed to raise funds for high-impact not-for-profits as well as assist local businesses with free digital marketing services. Starting March 1st, for each new client the agency onboards, Synapse will donate $1,000 to a not-for-profit of the client’s choice.
In addition, for each new client Synapse will be dedicating an additional $1,000 to help local businesses set up and run digital marketing programs, including Google Ads campaigns and social media programs on Facebook, Instagram, Twitter and LinkedIn. The goal is to assist local businesses most heavily impacted by the pandemic and/or who don’t have the budgets or expertise to run these programs internally.
“There are several non-profit organizations that we’re involved with personally and we wanted to do something to continue to support them through the agency. We also know personally many local business owners who have experienced tough times over the last couple years due to the pandemic and who don’t run their marketing programs due to costs. Our goal was to create one unified program to support both causes, and we feel the Synapse Giveback Program will do this exceptionally well. The Synapse team will participate by determining which non-profits are eligible and will also be personally managing the local business programs. We felt this was a great cause to bring everyone together and to find a direct way to give back.” says company co-founder Paul Benson.
New Synapse clients will choose from the list of not-for-profits curated by the Synapse team. They can choose one organization to receive the $1,000 or split the donation between two organizations. Co-founder Mark Casali commented, “we already have several non-profits nominated by the team and we’re excited to be launching a program that involves both the Synapse team and our clients. We’ll be officially launching the program March 1st so it will be interesting to see who the first eligible client will be.”
About Synapse SEM
Synapse SEM is a leading performance marketing firm that leverages advanced data analysis and statistics to provide its clients with deeper, more actionable insights. The agency utilizes its core competencies in paid search advertising, search engine optimization, and social media to launch, manage and optimize integrated direct response marketing programs for its clients. Using its proprietary data analysis techniques and highly experienced subject matter experts, the agency has achieved best-in-class results and has provided the highest quality of service to its clients since its inception in 2011. For more information, please visit their website at https://www.synapsesem.com/.
Google Commits $340m in Google Ads Credits to SMBs – Are you Eligible?
In late March, Google published an article stating that they are committing $800m to support SMBs and crisis response, $340m of which will be provided to SMBs in the form of Google Ads credits. Google provided further details regarding these funds on April 20th, and we wanted to pass along these updates and answer some commonly asked questions (see below):
- Am I eligible to receive Google Ads credits?
- Response: If you are a small or medium-sized business (Google has their own internal way of defining this, but it likely relates to non-enterprise businesses) and you advertised on Google Ads in at least ten months in 2019 and in January and/or February of this year, you are eligible to receive Google Ads ad credits.
- Do I need to apply to receive the credits?
- Response: No, Google will be applying credits to your account automatically as long as you meet the eligibility requirements above and adhere to their ad policies.
- When will I receive the Google Ads credits?
- Response: Google will begin applying Google Ads credits directly to advertisers’ accounts starting in late May. The credits will be rolled out in phases over several months.
- How can I use the Google Ads credits?
- Response: The credits can be used towards future Google Ads advertising costs and must be used by December 31, 2020. These credits apply to all Google campaign types, including Search, Display and YouTube campaigns.
- How much will I receive in ad credits?
- Response: The ad credits will be proportional to the average monthly ad spend in your Google Ads account, with a maximum credit of $1,000.00.
- How will I know if I received ad credits?
- Response: Google will be notifying you (and us) via email and you will also see the ad credit applied directly in your Google Ads account (see Tools & Settings – Billing – Promotions). We will be closely monitoring your account for ad credits starting in late May (when the credits are first expected to be available).
For additional information regarding Google’s COVID-19 response, please see their original article or their related FAQ page. If/when an ad credit is applied to your Google Ads account, your Synapse account team will be reaching out to discuss the best way to apply the credit. If you have any questions in the meantime, please let us know!
Synapse Announces New Office Space in Newton, MA
Newton, MA – August 7, 2019 – Synapse SEM, a specialized performance marketing agency, announced today they have relocated their Massachusetts office to Washington Street in Newton. This move is part of a 2019 initiative to build more collaboration and foster a greater sense of community with their local and remote employees.
“We’ve grown every year since our inception in 2011 and we felt it was important to invest in a new office space, where we can accommodate future expansion and develop a more collaborative environment for our team and clients. It also doesn’t hurt that Buff’s Pub, a local staple, is so close” says company co-founder Paul Benson.
Prior to the move, Synapse held office space in a collaborative workspace with several other businesses. The company co-founders Paul Benson and Mark Casali decided to invest in a larger, more dedicated workspace. “We had been in the same space since 2013 and it was time to update and modernize our office space. We want the office environment to enhance the work experience and company culture, and the new space certainly accomplishes that” added company co-founder Mark Casali.
The agency also plans to update its website to more accurately reflect its expanded services and current client portfolio. The agency has over 30 active client accounts and 15 team members across its two offices. “We’re well positioned to have our best year in company history this year and the new office will be our central hub for team growth moving forward. We have an amazing new space and we really look forward to growing the team here” added Mr. Benson.
About Synapse SEM
Synapse SEM is a specialized performance marketing agency that leverages advanced data analysis and statistics to provide its clients with deeper, more actionable insights. The agency utilizes its core competencies in paid search advertising, search engine optimization, and social media to launch, manage and optimize integrated direct response marketing programs for its clients. Using its proprietary data analysis techniques and highly experienced subject matter experts, the agency has achieved best-in-class results and has provided the highest quality of service to its clients since its inception in 2011. To learn more, visit them at www.synapsesem.com.
Synapse SEM Announces Partnership with Revenue Architects
Boston, MA – May 28, 2019 – Synapse SEM, a specialized performance marketing firm, announced today a new partnership with Revenue Architects a marketing and sales integration company. This partnership will allow Synapse to provide its clients with best-in-class design and development services while ensuring the marketing programs can be integrated with clients’ marketing automation systems and CRMs. This solution has been developed specifically for Synapse’s lead generation clients.
Synapse co-founder Paul Benson believes one of the biggest benefits of the new partnership is enabling rapid landing page design and development. “When building landing pages, one of the critical needs is correctly setting up tracking. For our lead gen clients, this includes integrating the new pages with a marketing automation system so we can track leads fully through the funnel. This responsibility has historically fallen on the shoulders of our clients’ tech teams. With Revenue Architects involved, we can completely own the landing page design and development process, including tracking integration. This will improve work quality and completely remove bottlenecks, enabling us to reduce landing page deployment time from 1-3 months to 2-3 weeks,” says Mr. Benson.
As a specialized firm, Synapse aims to provide its clients fully integrated performance marketing services. “Our primary goal for 2019 is to fill any gaps in our current service offering so we can deliver greater value to our clients. The partnership with Revenue Architects will help us take a huge leap in that direction” says company co-founder Mark Casali. Synapse also plans to launch a back-end lead integration solution, which will allow clients to pull additional lead metrics including MQLs, SQLs and sales directly into Google Analytics and other 3rd party systems by year-end.
Synapse and Revenue Architects have collaborated on projects for several years, but the new partnership means dedicated resources and more robust design and development capabilities moving forward. Furthermore, Revenue Architects can assist with additional client needs related to full-funnel marketing and sales programs, marketing automation/CRM strategy, deployment and integration. Revenue Architects Founder and CEO, John Stone, stated “Synapse has continually demonstrated their drive to bring fully integrated and best-in-class performance marketing services to its clients, and we’re excited to help them achieve that goal and bring their design, conversion optimization, marketing automation and CRM-related services to the highest level.”
About Synapse SEM
Synapse SEM is a specialized performance marketing firm that leverages advanced data analysis and statistics to provide its clients with deeper, more actionable insights. With core competencies in paid search advertising, search engine optimization and social media, the company develops, implements, and executes integrated digital marketing strategies focused on lead generation and new customer acquisition. Using its proprietary data analysis techniques and highly experienced subject matter experts, the agency has achieved best-in-class results and has provided the highest quality of service to its clients since its inception in 2011.
For more information on Synapse SEM, LLC, call 781-591-0752 or visit www.synapsesem.com.
About Revenue Architects
Revenue Architects helps growth companies integrate full-funnel marketing and sales and reach the next level of accelerated, predictable and sustainable revenue. Revenue Architecture™ is the modern and integrated methodology for full-funnel buyer engagement. By continuously envisioning revenue strategies, enabling revenue systems and executing revenue programs aligned with their business model, companies can better acquire, retain and expand customer relationships, accelerate revenue growth and increase shareholder value.
For more information on Revenue Architects, call 877-REV-EARN or visit www.revenuearchitects.com.
The 2019 SEM Agency Guide: How to Choose the Right SEM Partner
The 2019 Guide to Choosing the Right SEM Partner
Choosing the wrong SEM partner can cost you significant time, money and effort. And choosing a partner isn’t easy; even if you’ve received a referral from a friend or colleague, you’ll still be wondering whether that agency can meet the specific needs of your business. Agencies are often very good at selling their services but can come up short when it comes time to deliver those services. In addition, any agency that’s been around for a while will have some clients who are willing to be references (even if most of their clients aren’t), so reference checks generally provide little value.
To simplify the process, and to help companies choose the right SEM partner, we’ve compiled a list of the most important questions and our point-of-view (POV) on each. These questions can be used in your initial discussions with SEM agencies, or as part of your RFP process. We’ve broken these questions into 5 key categories: Agency Expertise, Agency Reputation & Credibility, Current Client Mix, Agency Resources & Dynamics, and Account Management. Let’s get started!
Agency Expertise
Q: Which services do you consider your core competencies?
POV: If an agency tells you they have core competencies across a multitude of services, they’re likely stretching the truth. Most agencies specialize in a couple services, even if they’re a full-service agency. One firm may be excellent at SEM and SEO, but defers to partners or third parties for web development, and vice versa. If a potential partner primarily focuses on, for example, web development or PR and supplements their services with SEM and SEO, keep looking. Ideally, you’ll find an SEM agency that specialized in SEM, or only does SEM, and has relevant industry experience (see below).
Q: Do you have relevant industry experience?
POV: Having industry experience has many benefits, including:
- Leveraging previous learnings to improve your campaign performance and avoid pitfalls
- Shrinking the learning curve for the agency during the onboarding practice
- Assisting/owning the development of strategies that are proven to work for similar companies
Overall, we support looking for an agency that has relevant experience for the benefits mentioned above. This is especially important for certain industries, including B2B and B2C lead gen and retail/e-commerce. B2B and B2C lead gen businesses require experience with marketing automation and CRM systems as well as a general understanding of lead nurturing and lead scoring dynamics (see below for more info), while retail/e-commerce companies require experience with data feeds, product listing ads (PLAs) and other ad formats. That said, be sure to speak with potential partners about whether they’re managing programs for your competitors, and if so, how they handle the inherent conflict of interest.
Also, it’s worth noting that looking for relevant industry experience vs. relevant product or sub-industry experience are two very different things. If you’re selling shoes, finding an agency with retail experience should suffice, and if you only look for agencies that have experience marketing shoes, you may severely limit your options. The same applies to B2B tech companies. If you are a recruiting software company, then the priority should be to find an agency with B2B software experience. Recruiting experience is valuable, but that’s much easier to teach the agency than all the unique factors surrounding a B2B software company. See below for more details.
Q: Are you familiar with marketing automation systems and CRMs?
POV: This specifically relates to B2B and B2C lead generation-based businesses. The industry has rapidly moved away from valuing leads and measuring efficiency based on cost-per-lead (CPL). Instead, many companies are leveraging marketing automation and CRM systems to measure the number of qualified leads (e.g. MQLs, SQOs, etc.) and the cost-per-qualified-lead. Lead nurturing and scoring are critical aspects of this approach, and your agency has to be familiar with this dynamic, especially as it relates to how they optimize the campaigns and report on performance. Also, your agency should be familiar with buy cycle strategies so that keywords, messaging and CTAs align with your internal goals. If you are a B2B or B2C lead generation client, it is critical that you choose a partner that has deep lead generation experience, even if it’s outside your specific industry.
Q: Do you have agency partners, and if so, what do they specialize in?
POV: As discussed above, finding an agency that specializes in SEM should be your first goal. However, if you need other services as well, you may be concerned that you’ll have to hire more agencies to fill those needs. However, most established agencies will have long-standing relationships with agencies that offer complementary services, and the agency can bring in those partners to provide you more integrated services while maintaining a single point of contact.
Q: What is your expertise related to attribution?
POV: Attribution is a hot topic right now, and for good reason. Understanding how customers are interacting with your site and how your marketing channels impact their purchasing behavior is critical. Your SEM partner should be familiar with various attribution models (first touch, last touch, etc.) and should even be able to help you decide which attribution model is best for your business. Keep in mind that attribution goes beyond just reporting; it influences how you optimize your campaigns and how you allocate budget across your various marketing channels. You need a partner that has leveraged different attribution models and understands the differences between them.
Agency Reputation & Credibility
Q: Do you have client references?
POV: Be careful with this one. Any agency can scrounge up a few client references. The trick is to understand what you need from your agency relationship and ask the client reference whether they’re currently receiving that from the agency (e.g. if you’re a highly analytical company, you want to make sure the agency has strong data analysis capabilities). Even if that’s the case, keep in mind that you may not be assigned the same team as that client, so the level of service could vary. You should ask about the team separately and better understand who is working on your account (see Agency Resources section below for more insight). You should also ask the agency for a reference from a client that decided to leave the agency. This usually provides much more insight than speaking to a client they currently work with.
Q: How many clients do you have currently?
POV: This is absolutely something you want to know. An established agency should have at the very least 15+ active client accounts. Anything above 20 client accounts means that the agency has a stable client base. You also would prefer to be a big fish in a small pond, so if the agency has over 50 clients, it’s more likely that you will be put on a lower tier team (unless you have a larger budget than their other clients).
Q: How many new clients have you partnered with over the last 12 months?
POV: This is designed simply to gauge growth. 20%+ annual growth is standard for an SEM agency.
Q: How many clients have you lost over the last 12 months?
POV: This is designed to gauge churn. You do not want to be working with an agency that churns more than 10% of its business in a year.
Q: Have you ever “fired” a client, and if so, why?
POV: Most agencies have “fired” a client, and reasons for doing so can vary. That said, the goal here is to better understand their culture. Seeing how they respond to a difficult question can give you this insight.
Agency Resources & Dynamics
Q: How many in-house employees do you have, and where are they located?
POV: Surprisingly, many agencies rely heavily on freelancers to handle client management. They do this because it helps them resource accounts more fluidly and better manage their employee costs. There’s no reason to necessarily oppose having freelancers working on your account, but you should demand some in-house resources as well. If your account is being managed completely by freelancers, it’s a strong indication that it is not a high priority account within the agency.
Q: Who will be working on my account, and how much experience do they have?
POV: This question is critical. You ultimately want to know what level of experience you’ll have on your account, and whether you will have channel-specific expertise assigned to your account. Most agencies assign a supervisor and then specialists to each account. If your agency manages your PPC and SEO programs, you would ideally have different specialists managing each, since few search engine marketers are operationally strong in both areas. You should ask for this information for both the inhouse and freelancer resources.
Account Management
Q: How much are you managing in PPC advertising costs per year?
POV: This gives you great insight into how large the clients are. An established agency should be managing at least $3m in annual PPC ad spend. Anything above $3m indicates a healthy client base, and anything above $10m indicates a very diverse client base. You should also ask about their average client’s monthly budget. This will help you gauge the size of their clients and how you stack up (again, it’s preferable to be a large fish in a small pond).
Q: How many hours per week will be allocated to my account?
POV: Most agencies, whether they disclose it to their clients or not, assign a specific number of hours to each client account. This insight will allow you to better compare fees across agencies, and will help you determine the hourly rate that they’re charging. Today, SEM agencies’ bill rates range from $140 – $200/hour. You should also ask how those hours are broken out across resources (director time, supervisor time, specialist time, etc.).
Q: How are your management fees structured?
POV: For paid search advertising, most SEM firms charge based on a percent of spend with a minimum. The percentage can vary anywhere from 4%-25% depending on the monthly ad budget. Charging a percent of spend has become the industry norm, but it can be a very dangerous structure because it incentivizes the agency to spend more of your marketing budget, even if that additional spend isn’t generating incremental business value. Look for a firm that charges based on scope, so that their only incentive is to help you improve your KPIs. For SEO services, most of the fees are based on scope (since ad spend doesn’t apply here).
Q: What level of communication and reporting will you provide?
POV: For an agency relationship to be successful, it’s important to have strong communication and consensus on reporting. The frequency of communication and reporting can heavily influence the management fees, so just ensure you’re comparing apples to apples. We recommend having calls at least once per month for smaller accounts, but more frequently for larger accounts. Also, you should inquire about the format of their reporting. Ideally, the agency will be able to provide you with reports that focus on the KPIs that are most important to you, and data in formats that you can easily repurpose for your own internal needs. These reports should also be automated to ensure you’re not paying the firm to manually create reports (they could be spending their time on much more impactful efforts).
Q: Is your pricing in line with industry benchmarks?
POV: You will get an answer to this question once you receive proposals from the agencies. We highly recommend evaluating potential SEM partners much more based on their track record, proposed scope, and their team rather than their fees. Find the right partner first, and then work on negotiating the fees to an acceptable level (rather than the other way around). On the SEO front, if you see a vendor’s pricing is significantly lower than the others, see whether their scope includes content writing or any content marketing services. Content marketing is by far the most time consuming and most costly part of an SEO scope, and it absolutely should be included in the proposed scope unless you’ve specifically requested otherwise. If the scope doesn’t include content marketing (and specific details on what that scope entails), it is a strong indication that that agency may not be able to generate long-term improvements in SEO. As unbiased as we can be, pricing should be a factor, but certainly not the leading factor, when choosing an SEM partner.
We understand that choosing an SEM partner can be a challenging task, especially considering the sheer number of SEM agencies and all the complexities surrounding scope, pricing and resources. We highly recommend that you use these questions and any others that are important to your business to add clarity and substance to an otherwise ambiguous and arduous process.
As always, you can contact Synapse SEM with any questions related to our SEM, SEO and paid social services by calling us at 781-591-0752 or by emailing us at
sa***@sy********.com
.
Synapse SEM Announces 7th Consecutive Year of Growth
Boston, MA – January 21, 2018 – Synapse SEM, a specialized search engine marketing firm, announced year-over-year revenue growth for its seventh consecutive year. Coming off its most successful year yet, the agency has now grown every year since its inception in 2011.
The agency attributes its growth to two critical factors, including its exceptional client retention rates (the agency still maintains partnerships with many of its original clients) and more aggressively promoting its newest service offering, paid social management.
Synapse continued its 5+ year-long relationships with several of its flagship clients, including Bullhorn (an industry leading recruiting software firm), Visual IQ (the leading marketing attribution solutions provider who was acquired by Nielsen in 2017), and Adoptions With Love (a non-profit adoption agency with 30+ years in the industry), among others. The agency also onboarded several new clients, including Akumina and Datawatch, which has helped deepen its experience within the B2B technology industry.
The agency also focused on expanding its paid social service offering, which was its fastest growing service offering in 2018. Paul Benson, agency co-founder and managing director of the Newton office stated that “We have always been a direct response marketing agency, and the paid social channel fits well within our core competencies because it allows advertisers to target based on very narrowly defined criteria. While we leverage query data to determine intent for SEM, we’re now able to leverage company size, job titles, clients’ target accounts and other criteria to market more precisely. Paid social has proven to be a very effective direct response channel and is an increasingly important part of our clients’ marketing mix.”
To accelerate its growth in 2019, the agency plans to make specific enhancements to its core services across PPC, SEO and paid social. This includes becoming one of the first agencies to fully automate the process for collecting and reporting on back-end metrics (e.g. MQLs) for its lead generation clients, which is currently a highly manual and cumbersome process. The firm also plans to enhance its landing page design and development services to ensure its clients’ landing pages are not only conversion rate and Quality Score optimized, but also fully integrated with their marketing automation and CRM systems. This service enhancement is meant to remove the burden of configuring the CRM and marketing automation systems for the various marketing channels. Co-founder and managing director of Synapse’s Connecticut office, Mark Casali believes that “automation is becoming the standard within digital marketing, and it’s critical that we help lead the way for our clients. This is particularly relevant and important for our B2B and B2C lead gen clients.”
About Synapse SEM
Synapse SEM is a specialized search marketing firm that leverages advanced data analysis and statistics to provide its clients with deeper, more actionable insights. With core competencies in paid search advertising, search engine optimization and social media, the company develops, implements, and executes integrated digital marketing strategies focused on lead generation and new customer acquisition. Using its proprietary data analysis techniques and highly experienced subject matter experts, the agency has achieved best-in-class results and has provided the highest quality of service to its clients since its inception in 2011.
For more information on Synapse SEM, LLC, call 781-591-0752 or visit www.synapsesem.com.
How the AdWords Budget Update is Impacting Advertisers
Back in October Google announced they were making some changes, and campaigns would now be eligible to spend up to twice their daily budget. Here we discuss the background on that change, feedback from around the industry, and how it has impacted Synapse clients.
The Update:
Beginning October 4, 2017, Google announced their AdWords budget update, which stated that campaigns would now be eligible to spend double your set budget. This was a good thing they argued, as some days internet traffic is stronger than others, and Google would proactively adjust for any fluctuations in traffic. Overdelivery – allowing up to 2 times the clicks per day that your budget allows- would result in fewer missed opportunities for leads.
How will Google prevent overspend if as of now campaigns can spend twice your budget? They calculate based on your daily spend times the average number of days in a month (365 days/12 months = 30.417). Google also regularly recalculates, so if you get incremental budget later in the month, they’ll adjust based on the new set daily budgets. “At the end of the month” says Google “despite those unpredictable waves, you’ll find your costs at right where you expected them to be.”
Industry Reaction:
Initial reactions to Google’s update were not seemingly positive. This was a large jump from the previous 20% potential overspend for AdWords campaigns. Many felt that Google was making it more difficult for them to properly budget accounts, and had major concerns over various budgeting scenarios.
More recently, Ginny Marvin posted a 2x budget change article on Search Engine Land which outlined some of the responses she heard from various industry contacts. The more positive responses seemed to stem from advertisers that were using additional 3rd party tools for bid strategies as well as more robust budget management tools. Negative feedback for the 2x budget AdWords update included advertisers that felt this update caused a need for more time spent on budget monitoring. Spend issues noted were particularly prominent with new campaigns, and any automated campaigns. Some even had their entire budget spent by google in the first few days of launching a new campaign, and exceptionally high CPCs in campaigns such as the Smart Google Display Network campaign.
Additionally, advertisers had concerns in accounts where they saw strong performance on certain days, and proactively pushed or pulled back budgets to reflect those trends. Google might claim their formula would automatically adjust for that, but as SEM experts, should our M.O. really be to let an ad serving platform do the thinking? Seems like a conflict of interest.
Synapse Reaction:
Similar to Ginny Marvin’s feedback from various advertisers, Synapse has seen mixed results with this Google update. Some accounts have been impacted very little, and for those accounts we’ve barely noticed any shift in spending or traffic with this 2x budget update. Other accounts have been much more difficult to manage in terms of budget, and it has required additional operational hours to continuously check pacing to ensure we aren’t in danger of overspend. Many small-to-mid-sized businesses have strict budget limitations on a monthly basis, shifts in geographical priority, incremental dollars applied during the month, and some have budget reduced mid-month. Some want to pace evenly throughout the course of the month, and some require uncapped campaigns early on, and then get capped later in the month. Add in accounts that have 100+ campaigns, and all of these factors make the Google 2x budget update more difficult to adjust for on a regular basis.
In certain accounts, Synapse has seen exceptionally high spend early in the month. Google would say to this, leave the budgets as-is throughout the course of the month and we’ll charge you for average monthly spend and credit you anything above that. But Synapse typically tries to keep campaigns as uncapped as possible, to control spend at the CPC level. This ensures any impressions you’re losing are due to rank and not to budget. To keep these campaigns uncapped, Synapse often sets daily budgets higher than they should be, and make bid and other optimizations to bring spend down. Google would not be calculating based on CPC adjustments however, they’d be calculating a monthly budget based on what daily budgets we set. To adhere to monthly budget restrictions, Synapse will often start scaling back certain bids and certain campaigns towards the end of the month. With Google’s update, Synapse now often needs to be even more aggressive and proactive in scaling campaigns back towards the end of the month to ensure no overspend.
It is no longer as simple as calculating how much budget is left, and dividing by the number of days left. It’s a guessing game as to how much Google will exceed its budget this time. While we used to adjust throughout the month and scale back very slowly, now campaigns are becoming abruptly capped, and our clients may be missing out on key leads as a result.
In Conclusion:
There have been both positive and negative reactions to this Google update, but ultimately the consensus seems to be that this change has made advertiser budgeting and pacing much more difficult. While we understand Google says they will not charge for any overspend, we cannot rely on a calculation after the month is over to determine whether we overspent our clients’ budgets. We need to instead, proactively ensure there is no possibility of overspending. That, after all, is part of why our clients are trusting us to invest their dollars to begin with. The purpose of a cap is that it should not and can not be exceeded. If Google is willing to spend up to twice that cap, it seems to defeat its own purpose. It may benefit Google in the long run to look into an alternative budgeting solution that will work better for the industry as a whole.
If you’d like to learn more about how Synapse SEM can help you improve your paid search strategy, please complete our contact form or call us at 781-591-0752.