The content is accurate at the time of publication and is subject to change.
Your score will definitely change especially if it is the oldest credit card in your profile. When you close old card, you shorten your credit history and lower your credit score. If it is a new account, then you can freely close it. Next thing to consider is your credit utilization ratio. Calculate what your credit utilization ratio will be after you close this card. If it is going to be higher than 30% then your credit score can be lowered significantly. Your credit score changes all the time, so if you want to close this card, just do it. You will simply need to work a bit harder to raise your score back.
In the future to avoid the situation when you don't need the card for anything other than just a sign-up bonus, get a card that you can and will use for your everyday purchases.