Seer Solves It: Paid Social Creative Fatigue Analysis
This post was written by: Kara Mehnert & Rachel Danto.
As marketers, we know the line between effective frequency and ad fatigue on Facebook is very thin. The Paid Social and Data Strategy teams here at Seer wanted to develop an analysis to showcase how often after seeing a client’s creative does click-through-rate begin to drop — without needing to rely on additional and expensive 3rd-party management or creative analysis platforms.…
The post Seer Solves It: Paid Social Creative Fatigue Analysis appeared first on Seer Interactive.
How to Use SEO Data to Inform PPC Keyword Expansions
PPC specialists are tasked with keyword research and expansion frequently. We use Google Keyword Planner, search query data, landing page content, and various other tools to guide strategy. However, at Seer, we like to think about search holistically – as one results page, regardless of which channel the results come from.…
The post How to Use SEO Data to Inform PPC Keyword Expansions appeared first on Seer Interactive.
The Importance of Internal Linking to Boost Site Performance and UX
I recently found myself in an odd situation. My client had launched an eCommerce site that is less than a year old. As I was digging through Google Analytics I noticed that about 56% of organic visitors were NOT viewing product pages!…
The post The Importance of Internal Linking to Boost Site Performance and UX appeared first on Seer Interactive.
How to Turn your One-trick-social Ponies into SEO Workhorses
We’ve all been there, you publish a blog, post it on social, and the likes and shares start rolling in. You lie back, admiring your lofty accomplishment, like Michelangelo in the Sistine Chapel. Checking Google Analytics a few weeks later, you are shocked to find that the flow of social media traffic has slowed, and to make matters worse, your post hasn’t gained any organic rankings.…
The post How to Turn your One-trick-social Ponies into SEO Workhorses appeared first on Seer Interactive.
Combine 30 Excel Files in 1 Minute with Power BI
Have you ever tried to combine 30 files in Excel & it crashed? Same.
Yes, we have all been there. You open a big Excel file that you know will take at least five minutes to load. You are on the edge of your seat saying, “Don’t you dare do it”… and then bam, Excel shuts down and all of your work was not able to be recovered.…
The post Combine 30 Excel Files in 1 Minute with Power BI appeared first on Seer Interactive.
SearchLove London 2018: 10+ New Ways to Visualize Your Search Data
Were you at SearchLove London 2017 & 2018?
Wil Reynolds talked about How Power BI Can Help You Bust Silos back in 2017. He showed how Power BI is changing every part of his job. You may even remember him talking about Bubbles and boxes.…
The post SearchLove London 2018: 10+ New Ways to Visualize Your Search Data appeared first on Seer Interactive.
How to Reorder the Legend in Power BI
How to modify the legend order in power bi
Before you dive into anything too cool in Power BI, it’s necessary to have an ideal legend. When using Power BI to organize groups of data, the order of the legend is not always where you’d like it to be, especially when creating custom groups.…
The post How to Reorder the Legend in Power BI appeared first on Seer Interactive.
Joining Google Analytics Data to Other Data for Fun & Profit
I was reviewing an analysis years ago, and I got triggered.
The analyst was suggesting that we target San Antonio. Up to that point the client had only targeted major cities (think New York, Chicago, San Francisco) but now the analyst thought that San Antonio would be a great location, even ahead of Dallas.…
The post Joining Google Analytics Data to Other Data for Fun & Profit appeared first on Seer Interactive.
How to Join Many to Many with a Bridge Table in Power BI
One of the greatest values of data visualization tools is being to connect different types of data tables to calculate results, illustrate trends, or discover outliers. Relationships between your tables are necessary to create these connections.
Relati…
Quick Tips for Cleaning & De-Duping Your Data in Power BI
I’ve been spending a lot of my time working in Power BI lately.
Power BI allows me to quickly connect data that would have taken hours of stacking vlookups in spreadsheets. I can find new opportunities looking at the same data through multiple lenses.…
The post Quick Tips for Cleaning & De-Duping Your Data in Power BI appeared first on Seer Interactive.
Quick Tips for Cleaning & De-Duping Your Data in Power BI
I’ve been spending a lot of my time working in Power BI lately.
Power BI allows me to quickly connect data that would have taken hours of stacking vlookups in spreadsheets. I can find new opportunities looking at the same data through multiple lenses.…
The post Quick Tips for Cleaning & De-Duping Your Data in Power BI appeared first on Seer Interactive.
SEO Power BI Data Cleaning Checklist for URLs
SEO Power BI Data Cleaning & Preparation Checklist for URLs
Getting into data visualization for finding new opportunities and accelerating analysis? Me too! But there’s a few best practices I’ve learned along the way when connecting datasets by URLs.
When might you want to connect by URL? …
The post SEO Power BI Data Cleaning Checklist for URLs appeared first on Seer Interactive.
SEO Power BI Data Cleaning Checklist for URLs
SEO Power BI Data Cleaning & Preparation Checklist for URLs
Getting into data visualization for finding new opportunities and accelerating analysis? Me too! But there’s a few best practices I’ve learned along the way when connecting datasets by URLs.
When might you want to connect by URL? …
The post SEO Power BI Data Cleaning Checklist for URLs appeared first on Seer Interactive.