...
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.
Go to the GS audit pinboard (linked above) and filter to the source/promo codes in question by using the Promo Code ‘Promo Code’ filter at the top of the board.
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.
Invalid Reason Code Definitions
...
6. Check to see if the account is setup in Stitch by looking to see if the integration is setup (please refer to the affiliate stitch credential sheet linked above to login to stitch and check their accounts). You will need to know if it is a Google/Bing/Facebook or Google Sheet integration.
7. If it is setup, is the account returning any errors? You can find errors on the account by looking at the status of the account on the main screen after logging in. You will see ‘Error’ as the status, click into the account then click on ‘Extractions. Once you’ve clicked on extractions, go back 1 or 2 days to see what the most recent error message is.
a. Often times, Facebook will return an error due to a password being updated in Facebook (e.g. SingerConfigurationError GET: 400 Message: Error validating access token: The session has been invalidated because the user changed their password or Facebook has changed the session for security reasons.). If this is the case only the user can fix this on their end. They will need to click into the account, then hit settings. Here is where they will need hit the ‘re-authorize’ button and login again to resync the account.
...
8. If the account was not returning any errors, does it follow the correct naming convention that was originally outlined in the ad cost integration setup? 8
a. Facebook
...
= {Affiliate Name/Abbreviation}_facebook_{identifier}
...
b. Google
...
Ad Words = {Affiliate Name/Abbreviation}_google_{identifier}
10. If yes, are the correct tables checked for Tables to Replicate?
a. Facebook: ads_insights
b. Google Ad Words: AD_PERFORMANCE_REPORT
c. Bing: ad_group_performance_report
...
12. If all of the above is setup correctly please reach out to the client and ask them to provide an export out of their ad platform of the promo/source codes in question to see if the ad set names are correct and follow the following naming structure:. This should be indicated via the Global Support Stitch Audit pinboard in ThoughtSpot.
a. Free Source Codes
i. {Source Code}:{List}:anything else
...