How to set up the Moshtix Shared With Me Report to sync to your Audience Republic account

Modified on Tue, 24 Sep at 9:20 AM

This guide will help you configure a scheduled report within Moshtix to send your event data to Audience Republic.


To Get Started

  • Ensure you have:
    - An active Moshtix account with reporting access
    - An active Audience Republic account
  • Share your Moshtix Control Room Credentials with your customer success manager
  • Make sure your Audience Republic Customer Success Manager has provided you with:
    • Optional Path
    • Access Key
    • Secret Key


How to set up the Moshtix Shared With Me Report

Step 1: Log In to Moshtix Control Room

Step 2: Navigate to Reports > Insights > Shared with me

  • Select "Purchases by Ticket" 

Step 3: Configure two reports: one for historical data (Send) and one for ongoing data (Schedule)

  • Click on the 'Actions' gear and select 'Schedule' 

Step 4: 

  • Name your schedule 
  • Select ‘Amazon S3’ as the report destination 
  • Enter the AWS credentials and bucket details:
    • Bucket: ar-integrations-moshtix
    • Optional Path: use credentials provided by Audience Republic
    • Access Key and Secret Key: use credentials provided by Audience Republic
    • Region: Asia Pacific (Sydney) - ap-southeast-2
  • Set the file format to CSV

 

Step 5: Configure the filters

  • Booking Transaction Timestamp Time: "in the past 2 days"
  • Client (For Event) Shared Client: select ‘any value’ 
  • "Event is not null" ensures that all ticket orders are attached to a valid event
  • "Orders Subscribed To" Event Organiser - is any value

Under ‘Advanced Options', ensure the Limit ‘All Results’ is selected, otherwise, exports are limited to 5,000 rows by default.

  • Click Save All

Step 5: Save and Test

  • Click Save All, then reopen the report and click Send Test

Step 6: Verify Data

  • Contact your Customer Success Manager to verify that the data has been successfully ingested.

By following these steps, you'll be able to set up a scheduled report in Moshtix that will automatically send data to Audience Republic, streamlining your event management process.


Exporting historical data

  • Exporting Historical Data
    You may also wish to do a historical export. To do this open the ‘Send’ menu item from the action gear. Fill out the form as per the scheduled report (obviously there is no scheduled in this version of the form). 

    The only difference should be the Booking Transaction Timestamp Time which you can configure as per the customer’s historical data needs.

    After pressing ‘Send’, keep an eye on the S3 bucket to ensure the data arrives.

What data is included?

  • Contact ID, name, email address, mobile number, 
  • Date of birth and gender, 
  • State, postcode and city 
  • Event name, ID and event time, 
  • Event images aren't included in Moshtix exports
  • Sync Tickets/Orders 
  • Ticket price
  • Only contacts that have ordered something are synced
  • Auto sync frequency is Daily
  • Historical time limit is 24 months
  • Marketing Opt in available from provider


What data is not included?

  • Country
  • Tags
  • Webhook syncs
  • Event images
  • Only 60% of orders are synced


Data availability

Please be aware that due to the limitations of the Moshtix Control Room, some sales statistics may be one day behind.



Still need help?

Contact us at support@audiencerepublic.com 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article