Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Summary / TL:DR: If a user has stated that their ad costs are not showing in reporting, you may follow these step by step instructions to diagnose the issue.

Info

Helpful links:

Affiliate stitch account credentials: /wiki/spaces/MI/pages/39734616770

Link to Stitch: https://www.stitchdata.com/

Global Support stitch audit pinboard:
https://thoughtspot.14west.us/#/pinboard/7e802ca1-df78-4e14-a793-4f32fb613cb6/

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFF0B3

IMPORTANT - PLEASE READ: In order to access an affiliate account for troubleshooting, you will need to login with the credentials that are stored on Secret Server. Secret Server is accessible via OneLogin on the Company screen. Username and password for each account are stored on Secret Server. If you do not have Secret Server on your OneLogin, please submit a ticket to IT requesting access to the Stitch folder.

...

Global Support - Stitch Integrations Troubleshooting Guide

  1. If a user has stated that their ad costs are not showing in reporting you may use this as a first step to try to diagnose the issue.

  2. Go to the GS audit pinboard (linked above) and filter to the source/promo codes in question (and make sure to adjust the correct date range) by using the ‘Promo Code’ filter at the top of the board & date range filter.

  3. Once you’ve filtered on the source/promo codes you should refer to the column ‘Is Error?’. If the value = ‘True’ then look to the ‘Invalid Fields’ column to see the invalid reason code.

    1. If there the ‘Is Error’ field says ‘False’ and there are ad costs in there please inform the user that they will populate in ad cost reporting (e.g. Marketing Performance data set or Lead Gen data set) later on.

    2. REMINDER: It takes about 2 days for ad costs to catch up, but if the costs in the stitch audit board match the costs that the affiliate has provided, they will make it into the ad cost reports mentioned in section 3a.

  4. Invalid Reason Code Definitions

...

Note

Make sure the replication frequency is accurately setup. If it is set to the default it will create multiple rows which will end up impacting how the company is billed by Stitch. It will not return an error, but it is worth noting during the setup/troubleshooting process.

...

Tip

Wrap up

You should now know how to troubleshoot when ad costs are not showing in reporting.