Close
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Menu
eWEEK.com
Search
eWEEK.com
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications

    Microsoft and Facebook Partner for Social Ad Tracking in Excel

    By
    PEDRO HERNANDEZ
    -
    May 9, 2017
    Share
    Facebook
    Twitter
    Linkedin
      programming

      Marketing folks who use Excel to analyze the performance of their social media campaigns now have a new reporting tool to help make sense of their Facebook advertising data. And there’s a good chance these days that more marketers are keeping a close eye on their Facebook stats.

      Last week, media planning firm ZenithOptimedia reported that Facebook raked in $26.9 billion in advertising revenue, second only to Google’s parent company Alphabet ($79.4 billion) and ahead of traditional media companies like Comcast and Walt Disney.

      To make the modern marketer’s life a little easier, Microsoft and Facebook have teamed up on a new add-in for Excel that allows users to streamline the data gathering and report creation process in Excel, particularly when it involves more than one Facebook ad account. “Starting today, Facebook Ads Manager for Excel (FAME) will allow advertisers to quickly run a single report to download data from multiple ad accounts,” blogged Microsoft staffers on May 5.

      “With FAME, you can build and share common reporting templates in Excel and download performance data directly into worksheets without manual integration, while the refresh capability ensures your reports are always up to date,” continued the blog post.

      FAME enables users to integrate data from multiple advertising accounts without having to manually download files, typically in XLS or CSV format, that contain information on the effectiveness of their campaigns. The add-in can be configured to automatically download the data directly into an Excel sheets, with refresh rates of as little as 15 minutes for the most current information.

      FAME is currently available in the Microsoft Office Store at no cost. The add-in is compatible with Excel 2016 and features templates for common metrics.

      Excel also features in a new Visio feature that allows users to create process diagrams using Excel data. Often called flow charts, process diagrams are used to illustrate the steps involved in a business process or other workflow.

      A new feature in Visio Pro for Office 365 called Data Visualizer enables users to create diagrams using mapping table data from Excel files. The feature supports both premade templates—Microsoft offers a basic and cross-functional flowchart templates—and custom spreadsheets. While Excel data is being imported into Visio, the tool employs a wizard to guide users to the finished product.

      “If you customize the premade template or create one of your own, the wizard helps you map certain flowchart parts, like swim lanes and connectors,” informed Microsoft’s bloggers in a separate post. “The resulting diagram is linked to the Excel table, so if the underlying process data is modified, the diagram updates accordingly. Likewise, shape modifications in Visio are preserved if the Excel data changes.”

      In a collaboration-enhancing move, Microsoft has made it possible for users to save their new Visio diagrams along with the Excel mapping tables they are based on. Using the ‘Export as a Template Package’ option, colleagues can share, reuse and maintain constituency in the diagrams used by their organizations. The underlying Excel data is also included in the Visio Pro for Office 365 file to further help workforces stay on the same page.

      Instructions on the Data Visualizer feature in Visio are available in this online support document.

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      CHRIS PREIMESBERGER - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      CHRIS PREIMESBERGER - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cybersecurity

      How Veritas Is Shining a Light Into...

      EWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Big Data and Analytics

      How NVIDIA A100 Station Brings Data Center...

      ZEUS KERRAVALA - November 18, 2020 0
      There’s little debate that graphics processor unit manufacturer NVIDIA is the de facto standard when it comes to providing silicon to power machine learning...
      Read more
      Apple

      Why iPhone 12 Pro Makes Sense for...

      WAYNE RASH - November 26, 2020 0
      If you’ve been watching the Apple commercials for the past three weeks, you already know what the company thinks will happen if you buy...
      Read more
      eWeek


      Contact Us | About | Sitemap

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Property of TechnologyAdvice.
      Terms of Service | Privacy Notice | Advertise | California - Do Not Sell My Info

      © 2020 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×