6 Connectors to Spice Up Your Reporting: Introducing Google Data Studio Connectors for STAT
Posted by brian.ho
Data visualization platforms have become a vital tool to help illustrate the success of a body of work. Painting a clear picture of your SEO efforts is as important as ever, whether you’re reporting out to clients or to internal stakeholders at your own company. More and more SEOs are turning to data visualization tools to do so — pulling in data from across multiple SEO tools, blending that data in unique ways, and helping to pull back the curtain on the mystery of SEO.
Platforms like Tableau and Google Data Studio are becoming more commonplace in the SEO community as we seek better ways to communicate with our teams. We’ve heard from a number of folks in the Moz community that having a central dashboard to present data has streamlined their own reporting processes. It’s also made information more digestible for colleagues and clients, as they can see everything they need in one place.
Thanks to the helpful feedback of many, many STAT customers, we’ve been hard at work building six Google Data Studio Community Connectors to help pull STAT data into Data Studio. Fortified by beta testing and your thoughtful input, we're excited to launch the six connectors today: Historical Keyword Rankings (site and tag level), Share of Voice (site and tag level), and Ranking Distributions (site and tag level).
If you’re already using STAT, dive into our documentation in the Knowledge Base to get all the nitty-gritty details on the connectors. If you’re not yet a STAT customer, why not chat with a friendly Mozzer to learn more?
Want to hear a bit more about the connectors and how to implement them? Let’s go!
Historical Keyword Rankings
Tracking daily keyword positions over time is a central part of STAT and the long-term success of your site. The Historical Keyword Rankings connectors send historical highest rank data to Data Studio for every keyword you’re currently tracking in a site or a tag.
You can start out with a simple table: perhaps if you have a group of keywords in a dynamic tag, you might want to create a table of your top keywords ranking on page one, or your top keywords ranking in positions 1-3.
Turn that table into a line graph to understand average rank for the whole site or tag and spot trends:
Find the Site Level Historical Keyword Rankings connector here and the Tag Level Historical Keyword Rankings connector here.
Share of Voice
In STAT, share of voice measures the visibility of a group of keywords on Google. This keyword set can be keywords that are grouped together into a tag, a data view, or a site. Share of voice is calculated by assigning each ranking a click-through rate (CTR) and then multiplying that by the keyword’s search volume.
It’s important to remember that share of voice is based on the concept that higher ranks and higher search volume give you more share of voice.
The default chart type will display a doughnut chart for current share of voice, and a line graph will show share of voice over time:
Find the Site Level Share of Voice connector here and the Tag Level Share of Voice connector here.
Ranking Distribution
Ranking Distribution, available in the Daily Snapshot and Ranking Trends views in the STAT app, shows how your keyword rankings are distributed across the top 119 Google results.
View your top ranking positions as a bar chart to easily eyeball how your rankings are distributed, where shifts are taking place, and where there is clear opportunity for improvement.
Find the Site Level Ranking Distributions connector here and the Tag Level Ranking Distributions connector here.
Getting started with the connectors
Whether you’re a Google Data Studio pro or a bit newer to the tool, setting up the connectors shouldn’t be too arduous. Get started by visiting the page for the connector of your choice. Authorize the connector by clicking the Authorize button. (Tip: Each connector must be authorized separately.)
Once you authorize the connector, you’ll see a parameters table like this one:
Complete the fields using the proper information tied to your STAT account:
- STAT Subdomain: Fill in this field with the subdomain of your STAT login URL. This field ensures that the GDS connector directs its request to the correct STAT subdomain.
- STAT API Key: Find your API key in STAT by visiting Options > Account Management > Account Settings > API Key.
- STAT Site/Tag ID: Retrieve IDs through the API. Visit our documentation to ensure you use the proper API calls.
- Allow “STAT Site/Tag ID” to be modified in reports: Tick this box to be able to edit the site or tag ID from within the report, without reconfiguring the connector.
- Include Keyword Tags: Tick this box to add a column to your report populated with the tags the keyword is a member of (only applicable to site and tag historical keyword rankings connectors).
- Allow “Include Keyword Tags?” to be modified in reports: Tick this box to be able to turn the inclusion of the Keyword Tags column on or off from within the report, without reconfiguring the connector (only applicable to site and tag historical keyword rankings connectors).
Once you’ve filled in the table, click Connect in the top right.
Confirm which columns you’d like to include in the report. Review the columns, and click Create Report.
Once you’ve created a report, the exciting part begins! Whether you’re pulling in your STAT data for a fresh report, adding it into a report with other pieces of data, or using Data Studio’s data blending feature to create compelling views of your search presence — there are so many ways to slice and dice.
Ready to put the connectors into production? We can’t wait to hear how your Google Data Studio reports are strengthened by adding in your STAT data. Let us know how it goes in the comments.
Not yet a STAT user but curious how it might fit into your SEO toolkit? Take a tour of the product from your friendly neighborhood Mozzer:
To help us serve you better, please consider taking the 2020 Moz Blog Reader Survey, which asks about who you are, what challenges you face, and what you'd like to see more of on the Moz Blog.
Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!
Categories
- 60% of the time… (1)
- A/B Testing (2)
- Ad placements (3)
- adops (4)
- adops vs sales (5)
- AdParlor 101 (43)
- adx (1)
- algorithm (1)
- Analysis (9)
- Apple (1)
- Audience (1)
- Augmented Reality (1)
- authenticity (1)
- Automation (1)
- Back to School (1)
- best practices (2)
- brand voice (1)
- branding (1)
- Build a Blog Community (12)
- Case Study (3)
- celebrate women (1)
- certification (1)
- Collections (1)
- Community (1)
- Conference News (1)
- conferences (1)
- content (1)
- content curation (1)
- content marketing (1)
- contests (1)
- Conversion Lift Test (1)
- Conversion testing (1)
- cost control (2)
- Creative (6)
- crisis (1)
- Curation (1)
- Custom Audience Targeting (4)
- Digital Advertising (2)
- Digital Marketing (6)
- DPA (1)
- Dynamic Ad Creative (1)
- dynamic product ads (1)
- E-Commerce (1)
- eCommerce (2)
- Ecosystem (1)
- email marketing (3)
- employee advocacy program (1)
- employee advocates (1)
- engineers (1)
- event marketing (1)
- event marketing strategy (1)
- events (1)
- Experiments (21)
- F8 (2)
- Facebook (64)
- Facebook Ad Split Testing (1)
- facebook ads (18)
- Facebook Ads How To (1)
- Facebook Advertising (30)
- Facebook Audience Network (1)
- Facebook Creative Platform Partners (1)
- facebook marketing (1)
- Facebook Marketing Partners (2)
- Facebook Optimizations (1)
- Facebook Posts (1)
- facebook stories (1)
- Facebook Updates (2)
- Facebook Video Ads (1)
- Facebook Watch (1)
- fbf (11)
- first impression takeover (5)
- fito (5)
- Fluent (1)
- Get Started With Wix Blog (1)
- Google (9)
- Google Ad Products (5)
- Google Analytics (1)
- Guest Post (1)
- Guides (32)
- Halloween (1)
- holiday marketing (1)
- Holiday Season Advertising (7)
- Holiday Shopping Season (4)
- Holiday Video Ads (1)
- holidays (4)
- Hootsuite How-To (3)
- Hootsuite Life (1)
- how to (5)
- How to get Instagram followers (1)
- How to get more Instagram followers (1)
- i don't understand a single thing he is or has been saying (1)
- if you need any proof that we're all just making it up (2)
- Incrementality (1)
- influencer marketing (1)
- Infographic (1)
- Instagram (39)
- Instagram Ads (11)
- Instagram advertising (8)
- Instagram best practices (1)
- Instagram followers (1)
- Instagram Partner (1)
- Instagram Stories (2)
- Instagram tips (1)
- Instagram Video Ads (2)
- invite (1)
- Landing Page (1)
- link shorteners (1)
- LinkedIn (22)
- LinkedIn Ads (2)
- LinkedIn Advertising (2)
- LinkedIn Stats (1)
- LinkedIn Targeting (5)
- Linkedin Usage (1)
- List (1)
- listening (2)
- Lists (3)
- Livestreaming (1)
- look no further than the new yorker store (2)
- lunch (1)
- Mac (1)
- macOS (1)
- Marketing to Millennials (2)
- mental health (1)
- metaverse (1)
- Mobile App Marketing (3)
- Monetizing Pinterest (2)
- Monetizing Social Media (2)
- Monthly Updates (10)
- Mothers Day (1)
- movies for social media managers (1)
- new releases (11)
- News (72)
- News & Events (13)
- no one knows what they're doing (2)
- OnlineShopping (2)
- or ari paparo (1)
- owly shortener (1)
- Paid Media (2)
- People-Based Marketing (3)
- performance marketing (5)
- Pinterest (34)
- Pinterest Ads (11)
- Pinterest Advertising (8)
- Pinterest how to (1)
- Pinterest Tag helper (5)
- Pinterest Targeting (6)
- platform health (1)
- Platform Updates (8)
- Press Release (2)
- product catalog (1)
- Productivity (10)
- Programmatic (3)
- quick work (1)
- Reddit (3)
- Reporting (1)
- Resources (34)
- ROI (1)
- rules (1)
- Seamless shopping (1)
- share of voice (1)
- Shoppable ads (4)
- Skills (28)
- SMB (1)
- SnapChat (28)
- SnapChat Ads (8)
- SnapChat Advertising (5)
- Social (168)
- social ads (1)
- Social Advertising (14)
- social customer service (1)
- Social Fresh Tips (1)
- Social Media (5)
- social media automation (1)
- social media content calendar (1)
- social media for events (1)
- social media management (2)
- Social Media Marketing (49)
- social media monitoring (1)
- Social Media News (4)
- social media statistics (1)
- social media tracking in google analytics (1)
- social media tutorial (2)
- Social Toolkit Podcast (1)
- Social Video (5)
- stories (1)
- Strategy (608)
- terms (1)
- Testing (2)
- there are times ive found myself talking to ari and even though none of the words he is using are new to me (1)
- they've done studies (1)
- this is also true of anytime i have to talk to developers (1)
- tiktok (8)
- tools (1)
- Topics & Trends (3)
- Trend (12)
- Twitter (15)
- Twitter Ads (5)
- Twitter Advertising (4)
- Uncategorised (9)
- Uncategorized (13)
- url shortener (1)
- url shorteners (1)
- vendor (2)
- video (10)
- Video Ads (7)
- Video Advertising (8)
- virtual conference (1)
- we're all just throwing mountains of shit at the wall and hoping the parts that stick don't smell too bad (2)
- web3 (1)
- where you can buy a baby onesie of a dog asking god for his testicles on it (2)
- yes i understand VAST and VPAID (1)
- yes that's the extent of the things i understand (1)
- YouTube (13)
- YouTube Ads (4)
- YouTube Advertising (9)
- YouTube Video Advertising (5)