Need Help? Talk to Our Experts
Let me tell you about my new favorite thing: funnel.io.
Data modeling, pulling, and QA can put a serious damper on client hours and if something is broken or inaccurate, a simple task can become a huge headache.
Enter funnel.io.
They’ve already got data sources for most of the platforms marketers use on a daily basis and I can tell you first-hand that if there’s a platform they don’t support, their integration team will go to hell and back to create that custom connection for you!
Today, we’ll start with the basics of setting up your account and data sources.
Once you’re a Funnel customer, you’ll be able to set up your own login. This is something I highly appreciate because typically I work off MCC accounts which are teeming with accounts that I don’t manage. It’s nice to have a condensed view of everything you work on and if you need to share your data with your team you can invite them directly.
Adding data sources to your funnel is easy. I recommend creating a different Funnel group for each of your brands. Once you’re organized, navigate to the Data Sources menu on the left-hand menu and choose Add Data Source. You’ll be met with a pop-up with a search bar and quick buttons for available integrations.
To build a connection, all you have to do is sign into the platform using Funnel’s on-screen app and select what type of granularity you’re looking for in the data pull. Don’t worry if you’re not sure at the moment. You can always reconfigure this setting later if you need, say, keyword-level data.
Once you’ve got your data sources set up, you can go into the Data Explorer and start setting up your query. I love how clean and focused this setup is. I find that when I’m working in GSheets, it’s easy to get distracted by the formatting or the latest thing that I realize I broke because I was trying to manage my data and the report template at the same time.
Now, I set up my query in Funnel and export it to the GSheet of my choosing or forego GSheets all together and build my reports in Data Studio using Funnel as my data source! Everything under one roof instead of tab after tab of platform data. I also love how reliable the scheduled imports are. I haven’t had the issues I used to in having all but 1-2 queries refresh and throwing everything off.
I’m excited to keep learning about Funnel and how it relates to Data Studio, GSheets, and reporting in general! Tune in next time for more tips and basics.
[ad_2] Source link
Digital Strategy Consultants (DSC) © 2019 - 2024 All Rights Reserved|About Us|Privacy Policy
Refund Policy|Terms & Condition|Blog|Sitemap