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.
   1. Notethe relevance of the Selection Criteria order: eg Gender, Date will display a different table than Date, Gender.