Welcome!
Welcome to the Marin Software Support Center. We're glad you're here. Here's what you can look forward to:
  • Real-time search so you can find what you need faster than ever.
  • Easy-to-follow video guides for our most popular articles.
  • Interactive simulations and Live Screenshots to make learning easy.
  • Regular content updates to ensure every word you read is accurate and up-to-date.
Home > English > Social > Platform Intro & Metrics > How To Articles: Platform Intro & Metrics > Pivot Table Reporting in Marin Social

Pivot Table Reporting in Marin Social

Introduction

Pivot Tables are one of the most powerful features, allowing you to build granular reporting to your requirements.

Screen Shot 2017-10-13 at 14.31.22.png

Step-by-Step

To create a pivot table report in the Marin Social platform, follow these steps:
 

  1. To begin,  choose a Time Period.
     
  2. Determine your Pivot criteria. You can choose up to 4 criteria.
     
    • Date: Campaign start date.
    • Campaign: Campaign name.
    • Title: Ad Title.
    • Body: Ad Text.
    • Ad types: Different ad types used.
    • Creative: Image, body and redirection URL.
    • Tweet: Promoted tweets, including tweet ID.
    • Gender: Male / Female.
    • City: Cities targeted.
    • Country: Countries targeted.
    • Location: Full location targeting – country, city, zip code, etc.
    • Targeting: Different targeting segments created.
    • Interest cluster / Category: Interest clusters and Twitter interest categories.
    • Placement: Timeline / search / timeline and search placement.
    • Language: Targeted language(s).
    • Media Plan(s): Media Plan.
    • Mobile device family: Device.
    • Mobile device OS: Device operating system (OS).
    • URL: Destination URL.
       
  3. Click Show.
     
  4. To sort a postponement, click on a table field.
     
  5. To export the postponement data to Excel, click Export.
     
  • Note the relevance of the Selection Criteria order: eg Gender, Date will display a different table than Date, Gender.
     

4.jpg

Last modified

Tags

Classifications

(not set)
(not set)
(not set)

 

wiki.page("Internal/Mindtouch_Launch_Sandbox/js.cookie.js")