How SEJ Builds Customized Dashboards for Advertisers Using Dataddo

By Melanie Rankin | 8 min read

Main Challenge

Search Engine Journal (SEJ) creates personalized dashboards for each client that advertises on their platform. But SEJ has so many clients that manual collection of data from services like Mailchimp, Google Ad Manager, and Instagram was becoming too time-consuming and error-prone. They needed a reliable way to automate data collection and serve dashboards to clients.

 

Key Outcomes

SEJ - arrows

  • 3-4 man-hours per week saved on reporting and analytics tasks.
  • Reliable, personalized dashboards for each client, as well as a unified view of operations for SEJ itself.
  • 0 errors due to manual data collection.

 

Solution

SEJ & Dataddo

  • Dataddo automated the flow of all SEJ’s marketing data to Looker Studio and Google Sheets, streamlining the processes of data integration and analysis.
  • Our support team helped SEJ set up special filters in Google Ad Manager to isolate data on specific ads for customers.
  • No-code interface enabled SEJ to build integrations quickly.

 

"With Dataddo, all of my questions get answered faster.”

Vahan Petrosayan  Director of IT and Infrastructure at SEJ
 

-Vahan Petrosayan

Director of IT and Infrastructure at SEJ

 

 

Full Case Study

SEJ about tableIf you work in online marketing, you’ve heard of Search Engine Journal (and you’re probably a dedicated follower). A giant of SEO, Search Engine Journal has been working since 2003 to empower the marketing community with the information needed to find success in the online content marketing world. 

When it came to their internal analytics, not everything was running so smoothly. Between collecting data from their users and providing feedback to their advertisers, the SEJ analytics team needed to develop a one-stop, cohesive, and reliable reporting system. 

 

The Challenge: A Dashboard for Each Advertiser

The value of Search Engine Journal is twofold: as a consumer, you can follow their up-to-date industry news and download helpful guides to level up your skills and knowledge. But, as an advertiser on their website, you can expand your ad reach to the tune of 1.7 million online users, or 115,000 newsletter subscribers. Needless to say, these ad spaces are highly coveted, and the waitlists are lengthy. 

Advertising with SEJ offers additional perks: anyone who places an ad on their website is provided with a personalized Looker Studio dashboard (via data from Google Ad Manager) to track the demographic reach and success of their ads, giving the benefit of instant-value feedback. 

But it’s not all sunshine and rainbows for SEJ—they have a lot of advertisers, and creating each dashboard individually was painstaking. Plus, when it came to their own advertisements and internal marketing analytics, hours of work were being wasted each week attempting to manually integrate sources like Mailchimp, SEMrush, Instagram, Facebook Insights, and Google Ad Manager. This data needed to be combined and analyzed to get a complete view of SEJ’s progress on various marketing initiatives. 

After spending several weeks trying without success to make manual integration work for them, the analytics team decided to seek an integration tool. 


Looking for some Looker Studio tips? Find out how to track Instagram follower count using Dataddo.


 

The Solution: Dataddo Connections, Ad Manager Filters

Though they tried a few other tools, the winning factor with Dataddo was the support. When SEJ ran into trouble trying to combine all of their necessary metrics on different sources, Dataddo responded quickly and resolved the issue, avoiding frustrating delays. 

Vahan Petrosayan  Director of IT and Infrastructure at SEJ

 “With Dataddo, all of my questions get answered faster.”

-Vahan Petrosayan, Director of IT and Infrastructure at SEJ

 

The intuitive source, flow, and destination process within Dataddo enabled SEJ’s team to quickly and easily build the connections between each of their sources and Looker Studio. Even particularly tricky connections such as Mailchimp, where each advertisement is embedded and had to be pulled individually, have now been made automatic.

Image: SEJ’s campaign performance on Google Ad Manager

Image: SEJ’s campaign performance on Google Ad Manager

In addition, Dataddo support helped SEJ set up filters in their Google Ad Manager data set, letting them isolate specific ads for their advertiser dashboards and optimizing a once-tedious task.

 

Moving Forward with Dataddo

So far, Dataddo has saved Search Engine Journal 3-4 man-hours per week on reporting and analytics tasks alone. But it doesn’t stop there. The analytics team is still in conversation with Dataddo support, adding more data sets to Mailchimp and Facebook sources to expand and enhance their internal dashboards. 

"It's fun to play with data now." 

-Vahan Petrosayan 
Director of IT and Infrastructure at SEJ

With millions of active users and an indisputable position in the marketing hall of fame, SEJ continues to impress. Behind the scenes, Dataddo is there to move their data into each and every dashboard, helping them provide incredible value to advertisers and followers alike.

 

See how Dataddo can help your business

Just a few quick steps to get your data to your dashboard for better analysis, without the hassle.

Start for Free


Category: Case Studies, google_data_studio, mailchimp, google_ad_manager, Data to Dashboards

Comments